How do I troubleshoot a server I can't get logged into?
- by Karl
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?