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.

All Forums  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  CPU Utilisation is showing 100%

Author  Topic  jkshahs Starting Member 2 Posts Posted - 2009-07-17 : 01:30:30 Can any one tell me is there are any queries in Sleeping mode , does that prove that it has adverse effect on the SQL Cpu utilisation and also can you tell me if there are any tools to identify the queries except the Trace Logs ?