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
7. Need to check fragmentation and rebuild or reorg the indexes if it is required.
No comments:
Post a Comment