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 - 2001-11-01 : 09:08:35
|
| Martha writes "Dear All,I have a problem with my company's database server.When using task manager that comes with Win NT, it show that CPU usage is 100%, and from the process, the SQL server is using approximately 98% of the whole resource.I want to be able to get the data on which spid (from Enterprise Manager or sp_who2 in Query Analyzer) that used the most CPU resource so I can track what is wrong with the server.Are there any tools that can be used for that?SQL profiler is definately out of the question since it works on SQL syntaxlevel, not spid level.Thanks before,Marth" |
|
|
|
|
|
spid with hungry resource