Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

This morning I am unable to log into SQL Server because it appears to be busy doing something, so much so that CPU usage is constantly at 98%-99%. I am guessing that something has gone wrong with the maintenance plan that ran over the weekend, but I can't get into the error logs see what is happening.

On logging in I keep getting messages like "insufficiently memory in the buffer pool" and "the server is not responding".

Is there any way I can figure out what is happening without logging onto to the server? Or some way I can squeeze in a login?

share|improve this question
up vote 5 down vote accepted

Try connection to it remotely with PowerShell.
This usually requires less resources then a full fledged RDP-session.


invoke-command -computername myServer -scriptblock {Get-Process}

This way you can get a look at what's running remotely and later on, kill it.

share|improve this answer
Let's hope that the remote servers powershell has been configured for remote execution. winrm quickconfig to the rescue! – Mark Henderson Jun 4 '12 at 9:29
Ah, yes, that is something we do on every install :). – Bart De Vos Jun 4 '12 at 9:31

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.