Memory Dump

  • Does anyone have a query that will tell me what query was running when I experienced a memory dump?

    MCSE SQL Server 2012\2014\2016

  • Hi,

    If you want to know what query caused the memory dump, you need to look into the memory dump. You need to use a debugger, such as WinDBG, for that purpose. If you have a mini-dump, you're in luck, as it only holds relevant data to the issue making the query bit easier to find.

    Mika Sutinen, Senior DBA
    @SQLFinn on Twitter
    Blogging at SQLStarters[/url]

  • There's a way in SQL to find the query, I just got out of a class with MS that showed us and I can't find the query. If I find it I will post it.

    MCSE SQL Server 2012\2014\2016

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply