March 10, 2020 at 2:14 pm
One of my critical database server had an unexpected reboot followed by server hung issue but sadly we are unable to find any related errors in the event logs or SQL logs . Also there was no dumps generated . I recollect there is a way that the dumps can be generated later as well and also how can i make sure dumps/logs are generated if such unexpected reboot happens in the future . Server is Win server 2012 . Please guide
March 10, 2020 at 3:44 pm
You can check dumps here: https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-server-memory-dumps-transact-sql?view=sql-server-ver15
If a dump isn't triggered for the hung/reboot, not sure you will see a SQL dump or there's value in producing one later. You're usually looking for memory contents.
Did you have any of these errors? https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2005/administrator/cc917684(v=technet.10)?redirectedfrom=MSDN
March 11, 2020 at 1:21 am
Hi Steve
No luck , neither do i see any memory dump generated or sql errors you posted above in the logs .
March 11, 2020 at 5:40 pm
I am guessing this might not necessarily be a SQL issue? I know you can create a dump (https://support.microsoft.com/en-us/help/917825/use-the-sqldumper-exe-utility-to-generate-a-dump-file-in-sql-server) when you have issues. Maybe keep that link on the desktop of the server.
I'd double check windows logs as well
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply