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 |
|
darkdusky
Aged Yak Warrior
591 Posts |
 Posted - 2009-02-19 : 05:52:05
|
| I am trying to find the source of high CPU usage in SQL Server 2005. I used Activity Monitor in SQL Server 2008 to analyse the 2005 server - it shows me the query running (it is the function sys.fn_varbintohexsubstring) - but I can not track down any more details such as username, application or even database name)I've tried the DMVSelect * from sys.dm_exec_query_statsorder by execution_count desc-can the sql_handle column help me? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-19 : 12:13:58
|
| You can use server-side profiler for that. |
 |
|
|
|
|
|
high cpu usage