?
Solved

Threading and network load

Posted on 2013-06-27
4
Medium Priority
?
259 Views
Last Modified: 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.
Any idea?
0
Comment
Question by:lrbrister
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 40

Accepted Solution

by:
Kyle Abrahams earned 1600 total points
ID: 39281808
For the first box you should be okay . . . just monitor the system ram on the windows 7 box, but since you say you're using less than 8% for it you have plenty of room to grow, possibly even a bit overkill.

If the DBA says you're fine, I would trust them.   They usually have a good knowledge of hardware and how DB changes will effect overall performance.  My one main concern would be hard drive space . . . considering the storage requirements of the records (eg: how long they're needed for).
0
 

Author Comment

by:lrbrister
ID: 39281887
ged325
Thanks.
I'll watch and see if anyone else has anything significantly different to say and then award points if not.
0
 
LVL 23

Assisted Solution

by:nemws1
nemws1 earned 400 total points
ID: 39281953
(Don't give me any points)

I agree with ged325.

1) sounds like this should run fine on this hardware, even though it does have less hardware

2) my only concern is to make sure your DBA sets the max memory to a reasonable value for both instances of the DB server.  If both are set to use all the available memory, you can have issues.  However, this is really easy to fix.

Good luck!
0
 

Author Closing Comment

by:lrbrister
ID: 39281975
Thanks folks.
0

Featured Post

Cloud Training Guides

FREE GUIDES: In-depth and hand-crafted Linux, AWS, OpenStack, DevOps, Azure, and Cloud training guides created by Linux Academy instructors and the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question