Monday, 14 April 2014

Monitor and Alert SQL Stack dumps

As many of know not all stack dumps raise an error in SQL Server and may go unnoticed for days, SQL stack dumps can sometimes cause database corruption and its always better to analyse the server immediately after a stack dump. Since there are no errors raised we cannot configure normal SQL Alert to report the SQL Stack dumps, I created a PowerShell script which can also be scheduled as a SQL Agent job to monitor the SQL Stack dumps, I have used Chad Millers invoke-sqlcmd2 just for flexibility in the future, you can use native invoke-sqlcmd without any issue. 

 If you want to schedule this script as SQL Agent job remember to comment the clear-host and the invoke-sqlcmd2 function in the below script and try to use invoke-sqlcmd instead.Also I have scripted this to check the stack dumps for last one hour as I am running the SQL agent every hour in my environment, please change accordingly.

at

12 comments:

  1. SQLbuzz27 July 2016 at 13:29

    Hi - I am new Powershell language. can you tell excellently how to implement this change ?

    ReplyDelete
  2. SQLbuzz27 July 2016 at 13:30


    here is the error i am facing
    PS C:\Windows\system32> Param
    The term 'Param' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spell
    ing of the name, or if a path was included, verify that the path is correct and try again.
    At line:1 char:6
    + Param <<<<
    + CategoryInfo : ObjectNotFound: (Param:String) [], CommandNotFoundException
    + FullyQualifiedErrorId : CommandNotFoundException

    PS C:\Windows\system32> (
    >> [Parameter(Mandatory=$false,Position=0)]
    >> [String]$sqlinstance_name = 'DMSQADB'
    >> )
    >>
    Missing closing ')' in expression.
    At line:3 char:5
    + <<<< [String]$sqlinstance_name = 'DMSQADB'
    + CategoryInfo : ParserError: (CloseParenToken:TokenId) [], ParentContainsErrorRecordException
    + FullyQualifiedErrorId : MissingEndParenthesisInExpression

    ReplyDelete
  3. SQLbuzz27 July 2016 at 13:30


    here is the error i am facing
    PS C:\Windows\system32> Param
    The term 'Param' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spell
    ing of the name, or if a path was included, verify that the path is correct and try again.
    At line:1 char:6
    + Param <<<<
    + CategoryInfo : ObjectNotFound: (Param:String) [], CommandNotFoundException
    + FullyQualifiedErrorId : CommandNotFoundException

    PS C:\Windows\system32> (
    >> [Parameter(Mandatory=$false,Position=0)]
    >> [String]$sqlinstance_name = 'DMSQADB'
    >> )
    >>
    Missing closing ')' in expression.
    At line:3 char:5
    + <<<< [String]$sqlinstance_name = 'DMSQADB'
    + CategoryInfo : ParserError: (CloseParenToken:TokenId) [], ParentContainsErrorRecordException
    + FullyQualifiedErrorId : MissingEndParenthesisInExpression

    ReplyDelete
  4. Charlesday12 July 2020 at 08:11

    I am looking for and I love to post a comment that "The content of your post is awesome" Great work! best medical alert system

    ReplyDelete
  5. angel13 July 2020 at 01:56

    I am looking for and I love to post a comment that "The content of your post is awesome" Great work! license class d

    ReplyDelete
  6. Jacob18 December 2020 at 23:35

    Fortunate, with every one of these advantages to the Polar pulse monitor the cost is entirely reasonable for some individuals. https://bestmonitorhub.com/

    ReplyDelete
  7. Harry jack9 February 2021 at 07:29

    This is to diminish the danger of SIDS. Probably the best technique to ensure that your infant is in acceptable position while dozing is having rest screens to monitor his developments while dozing.http://beitragpost.com/best-portable-monitor-2021-usb-screens-for-working-from-home/

    ReplyDelete
  8. Shubham Singh4 June 2021 at 02:22

    I absolutely loved your content.. thanks for sharing
    Coupe Du Monde Football
    Hd Football Wallpapers
    Fifa World Cup News
    Maliika Tech News
    Sabuj Tech

    ReplyDelete
  9. Techconsumptions1 December 2021 at 01:35

    For any individual who doesn't as of now use CommentLuv this post gives an extraordinary summation of the module and you feature the advantages and its helpfulness very well to be sure.

    I particularly like how you discussed catchphrases. This is an element that I haven't utilized at this point, chiefly in light of the fact that I haven't actually been sure about how to utilize it appropriately. In any case, your basic clarification shows how straightforward it truly is. So I will have a go at doing it in this remark and trust that it works OK 🙂

    Read More: Best Gaming PC Under 800

    Best Gaming PC Under 1000

    ReplyDelete
  10. Unknown10 February 2022 at 02:13

    I particularly like how you discussed catchphrases castle clash mod apk

    ReplyDelete
  11. Unknown10 February 2022 at 02:20

    For any individual who doesn't as of now use CommentLuv this post gives an extraordinary summation of the module and you feature the advantages and its helpfulness very well to be sure Best Graphics Card Under 150

    ReplyDelete
  12. Unknown10 February 2022 at 02:22

    For any individual who doesn't as of now use CommentLuv this post gives an extraordinary summation of the module and you feature the advantages and its helpfulness very well to be sure Best TIG Welder under 1500

    ReplyDelete

Subscribe to: Post Comments (Atom)