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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Sql Server Performance

Author  Topic 

Kuldip
Starting Member

4 Posts

Posted - 2014-10-20 : 19:10:58
Users are complaining Sql server is very slow. I have checked in the performance monitor that %Process time is going sometimes higher than 50%. what should i do to reduce this

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-10-20 : 19:13:26
I wouldn't be concerned about 50% CPU usage as that is not a bottleneck number. But it could indicate missing indexes.

You first need to identify where the problem areas are. You can run a trace to get this info, or various other methods. We have sp_whoisactive setup collecting data every minute, so we can use that for high level stuff.

I would also run the missing indexes report and target anything with an impact of over 20000000. You'll need to proceed with caution though as it'll recommend "duplicate" indexes.

Make sure you have an update stats job running frequently, such as at least daily.

Run Perfmon to determine if you have IO, memory or other issues.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

Shanky
Yak Posting Veteran

84 Posts

Posted - 2014-10-21 : 07:38:58
Just posting a fragment that user is complaining is not going to help. This sound more like interview question MS has already written a whitepaper on how to go with troubleshooting SQL Server performance please see http://technet.microsoft.com/en-us/library/dd672789%28v=sql.100%29.aspx

Tara we must have some check on quality of question one post such questions are too open ended and interview question for freshers which is very difficult to solve virtually.

Hope this helps

Regards
Shanky
SQL Server MVP
http://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx
Go to Top of Page
   

- Advertisement -