SQL Server is running slow

1. Check number of connections(SP_Who2)
2. Check the processor usage not above 80% of utilization
3. Check the memory usage not above 40-45% of utilization
4. Check the Disk utilization using Perfmon
5. Use profiler to check for the users and current SQL activities and jobs running which might be a problem
6. Finally run UPDATE_STATISTICS command to update the indexes   

No comments:

Post a Comment