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.
| 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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
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.aspxTara 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 helpsRegardsShankySQL Server MVPhttp://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx |
|
|
|
|
|
|
Sql Server Performance