May 9, 2012 at 1:34 pm
Hello all
I have a mid size server with sql server 2008 R2, 42 gb of ram, an several midsize to large databases, I know that one of those have something wrong, because anytime I change it from single user to multi_user it casues a reboot on the sql server every few minutes withoyt apparent reason, I already ran checkdb agaist it and it didn't show any error, do you have an Idea of the things that I should be looking at as to try to solve this issue?
Btw that db is around 400gb
Thanks in advance
May 9, 2012 at 1:44 pm
You should look at the SQL Server logs as well as the server level logs.
Whats the OS?
May 9, 2012 at 1:45 pm
Basic troubleshooting I'd follow:
Check your SQL logs
Check your Windows logs
Run SQL Profiler against the DB (save results to file or table)
If you can, restore a copy of the suspect DB onto a separate server and see what happens there.
May 9, 2012 at 1:47 pm
Are there any indications when it's in single user mode that something is trying to run in that DB? Something may be running in the context of that DB that's restarting the server, especially if xp_cmdshell is enabled.
May 9, 2012 at 1:57 pm
The OS is windows server 2008 R2, I already look into the logs and the only thing I saw was a query against one of the bigger tables, nothng fishy in there, windows logs shows anything too, I'll set a profiler
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply