forum.venkateswarlu.net
      Register      Login
How do you troubleshoot SQL Server if its running very slow?

2 replies to this topic

Subramaniam R #1
Member
152 Points
 Posted on 25 Jul 2013 05:26 PM IST How do you troubleshoot SQL Server if its
running very slow?  
SQL Server     766 views     Reply to this topic
Aisha Bobby #2
Member
96 Points
 Replied on 26 Jul 2013 12:53 PM IST

First check the processor usage to see that processor is not above 80% utilization.

Secondly, check the memory not above 40-45% utilization.

Finally, check disk utilization using Performance Monitor, SQL Profiler to check for  the users and current SQL activities and jobs running which  might be a problem.

 
Reply to this topic
Subramaniam R #3
Member
152 Points
 Replied on 26 Jul 2013 05:20 PM IST Thanks for your valuable reply Aisha 
Reply to this topic