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
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