Weird SQl server reboots, what to look for?

  • 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

  • You should look at the SQL Server logs as well as the server level logs.

    Whats the OS?

  • 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.

  • 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.

  • 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