January 23, 2011 at 12:30 am
1)cpu utilization is 100percent how will troble shoot it?
2)how can troble shoot time out errors?
plzzz any one
January 23, 2011 at 12:51 am
This article has a good overview of Troubleshooting Performance issues in SQL Server.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
January 23, 2011 at 12:55 am
srik780 (1/23/2011)
1)cpu utilization is 100percent how will troble shoot it?2)how can troble shoot time out errors?
plzzz any one
This is a little vague to get a good response.
(1) I would start with creating a Performance Monitor log. You can check here [/url]for a good list of counters to include. Here is a good tutorial on it as well.
(2) I don't really understand this one.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
January 24, 2011 at 7:07 am
srik780 (1/23/2011)
1)cpu utilization is 100percent how will troble shoot it?2)how can troble shoot time out errors?
plzzz any one
a) the BEST way to learn performance analysis and tuning is to hire a mentor to teach you how to do it using your system. You learn and your system gets improved at the same time.
b) use task manager to make sure it is sqlserver.exe that is actually burning the cpu. Assuming it is, sp_whoisactive is the first place I would start. You can also use some of Glenn Berry's very fine performance DMVs to see what queries are doing what. Note that bad queries can do this, missing indexes, or simply too much work for your box to handle.
c) timeouts are easy to troubleshoot by using sp_whoisactive to check for blocking and then fix your design/queries/indexes to stop the blocking. there are other causes of timeouts but this is by far the most common.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply