Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kwirky
Starting Member
8 Posts |
 Posted - 2010-08-05 : 08:30:15
|
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 thanksKwirky  |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-08-05 : 08:43:09
|
| If it was fast, and is now slow, and assuming things haven;t changed too much (similar number of users, and size of database) then my hunch would be that routine maintenance is not being done to rebuild indexes and update statistics, and ensure that the system is defragmented. |
 |
|
|
kwirky
Starting Member
8 Posts |
Posted - 2010-08-05 : 08:46:25
|
| Thanks so much. I will look into this. |
|
|
|
|
|
|
SQL MIS Performance Issues