Articles Posted in the " Troubleshooting " Category


  • TSQL Tuesday #88 -Communication is the Key

    TSQL Tuesday #88 -Communication is the Key

    I thank Kennie Nybo Pontoppidan (b|t) for hosting TSQL Tuesday #88. Topic for this month is daily database related WT…….

    TSQL2SDAY-300x300

    Last week I was setting up a collection of wait statistics with five minutes interval using a while loop. I was wrapping up Paul Randal’s (b|t) code from this blog post in a loop and persisting in a table to analyze later.

    I made it a habit in my career to have my peers review my code. I sent my code to one my colleague and asked him to review. Meantime …


  • SQL Server system_health Session Retention

    As per Microsoft’s books online

    The system_health session is an Extended Events session that is included by default with SQL Server. This session starts automatically when the SQL Server Database Engine starts, and runs without any noticeable performance effects. The session collects system data that you can use to help troubleshoot performance issues in the Database Engine. Therefore, we recommend that you do not stop or delete the session.

    What this article does not tell you is your individual file size is 5 MB and number of maximum rollover file is 4. Meaning you will only get 20 MB of …