September 22, 2014 at 11:38 am
Hi all,
I have a problem that I'm having a difficult time trying to solve. Basically, every Sunday night, at roughly the same time each week, the server becomes more or less unreponsive. Other servers cannot communicate via linked server, and when attempting to log on to the machine via RDP, the machine reacts very sluggishly.
When I finally do manage to connect via RDP, looking at the task manager shows that the SQL Server process is using up all available CPU. I can't even connect to SQL Server using sqlcmd or SSMS, nor can I connect using the DAC.
This lasts for around two hours, after which the server returns to normal functionality.
Can anyone help me with finding out what is happening on the server at this time? I've looked over the log files, there is no trace of any problems occurring. The last job which is set to execute finishes at about 9:50 PM.
Any ideas on where I can look to find what is going on?
September 22, 2014 at 12:55 pm
If it happens consistently, schedule a server-side trace to start just before the problem occurs and run long enough to catch the entire thing, then you can review the trace file and see what was in it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 23, 2014 at 8:59 am
Thanks for the suggestion, Gail.
I've scheduled the server-side trace. Now we see if it finds anything for me ...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply