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 |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
 Posted - 2012-06-29 : 11:22:18
|
| I've a client who is currently complaining of performance issue in their server. They've a set of automated process which they run for bid processing and its causing a bottleneck in server. Most often server gets hung and have to be restarted.I've done some analysis on it and have following observationsthere was no waiting or blocking tasks in the queue or the number of waiting threads is less than the number of processorsThe memory also look fairly stable and there was sufficient memory available alwaysThere were some very few occasions (2) where we had some high disk waiting queue and other than that it was also okPage splits/sec were quite high on more occasions and they did change fill factor of indexes to handle thisThe Catch hit rate was also quite high (99 %)I've also looked and asked to rebuild indexes/stats on few of tablesThe analysis of top worst performing queries suggested most of them have high amount of logical reads. There were also couple of cases where OPENROWSET query is causing high execution time which is a simple pull of data and a xp_cmdshell callCould anybody give me pointers on how to proceed on this further?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
Performance bottleneck in server