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
 General SQL Server Forums
 New to SQL Server Administration
 why server keeps busy?

Author  Topic 

allan8964
Posting Yak Master

249 Posts

Posted - 2013-04-06 : 13:35:37
Hi there,

I have a sql database server which holds some data for SharePoint reports. No one knows since when it goes crazy. Now 100% CPU used, even when the reporting jobs are done. How can I check what it's running and how to make it work normally? Thanks in advance.

allan8964
Posting Yak Master

249 Posts

Posted - 2013-04-06 : 14:18:29
OK, I found a source at http://blog.sqlauthority.com/2009/01/07/sql-server-find-currently-running-query-t-sql/
That solves my puzzle.
Go to Top of Page
   

- Advertisement -