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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-10-20 : 08:08:25
|
| Andrew writes "We are having some slowness issues here at work with a particular SQL installation. This installation is a ia64 installation of 2000. It is currently sitting at build 8.00.2030, we realize 2187 is currently available, but due to political issues obtaining a test box, we are unable to apply this patch at present. We've been working with Microsoft for the last 5 months but have yet to make any real headway. Typical scenario is, we get a call from the NOC mentioning that they have business units that have users/customers are having issues with the application (this is a consolidated environment, with 8 fairly heavily used databases), we ask the NOC to check to see if it is only that app, or is it across the board while we check performance on the server, it has always been across the board. We have a tool called Indepth for SQL server that we use heavily for pinpointing these sorts of problems. Every time this issue has come up, we see CPU time (in Indepth) skyrocket, but our actual CPU time in perfmon is mostly very low, typically less than 30%. The strange thing we have noticed however is that when this issue is occurring sql server privileged time hangs around 3x that of SQL Server User time. As soon we see the privileged time drop back down to where it should be (around 1/3 of the user time) we can reliably call the NOC back and expect the users not to have a problem from that point until it happens again (may be a hour, day, week, or month we have yet to find any sort of pattern or any specific reoccurring jobs/queries that run during these periods).I know that when SQL privileged time is high, it typically means that SQL isn't using the UMS to scheduler as much to schedule SQL tasks, which is a prime suspect in the slowness, but for the life of me, can't figure out what's causing this issue. Any ideas/suggestions would be extremely appreciated." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-10-20 : 08:10:53
|
| Obvious question, just want to make sure: you've elminated any other process that might be running on the server as the culprit? I'm not familiar with InDepth so I don't know if it clearly identifies the app that's using the CPU. |
 |
|
|
|
|
|
|
|
SQL Server Priviliged time