Threading and network load
Posted on 2013-06-27
I have a service that I'm building that will run multiple threads to monitor sales force phone call status.
Simple reading of number of calls per day and send XML data to SQL Server
It posts about 1000 records a minute through WCF
The service runs fine on my (dev) PC which is
Windows7 8GB RAM and 4 processors
The network, ram, and processor load is all < 8% of total
When I move the service to live it will be on a Windows Server 2008
That server currently has 4GB RAM and 2 processors
First part of question...is that enough for the service?
This server is dedicated to ONLY this service and the WCF that sends the data to a SQL Server 2005 (Believe it or not) Server instance
The SQL Server 2005 has about 6 databases on it but one is a heavy load and handles our in-house application with about 120 users.
The other database will be the one that is receiving this 1000 records a minute from WCF
Second part of question...
I feel uneasy about both databases on same SQL Server.
I'm told by DBA it'll "handle it fine" but not sure.