Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

up vote 5 down vote accepted

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

Example:

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
2  
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

 
discard

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.