Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL based MIS Troubles

Status
Not open for further replies.

kwirky

MIS
Apr 22, 2010
85
AU
Hi,
My company is running an MIS which is SQL based. We are having issues with what we think might be 'traffic' in the afternoons, when the work load of users increases.
We have virtualised the servers with the understanding that this would increase the lanes on our highway thus making traffic flow faster. This workded for a couple of months, but it is now back to an extremely slow system, which it simply shouldn't be.
We are running SQL 2005 Server, and Windows Servers 2003, 2005 & 2008.
The total number of staff using the system would be about 100 spread over 5 servers (2 of which are physical servers).
We have also recently thrown a bunch of GB at the memory.
Does anyone have any idea where to start looking at a solution to this problem?

Many thanks
Kwirky
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top