Tag Archives: default trace

  1. SQL Homework – December 2019 – The default trace and the system health session.

    Leave a comment

    December 2, 2019 by Kenneth Fisher

    I know this is the holiday season for many of us (which ones depend on your religion and nationality of …
    Continue reading

    Category: Microsoft SQL Server, SQL Homework, SQLServerPedia Syndication | Tags: , , , ,

  2. Default Instance Reports – Configuration Changes History

    Leave a comment

    July 17, 2017 by Kenneth Fisher

    Hey, who changed the max memory setting for the xyz instance? The good news is that this information is captured …
    Continue reading

    Category: Auditing, Microsoft SQL Server, Settings, SQLServerPedia Syndication, SSMS | Tags: , , ,

  3. What is the system_health extended events session?

    4

    July 5, 2017 by Kenneth Fisher

    Similar to the default trace the system_health session is automatically started up when the instance starts and collects information about …
    Continue reading

    Category: Microsoft SQL Server, SQLServerPedia Syndication, System Functions and Stored Procedures | Tags: , ,

  4. What is this default trace you speak of?

    4

    June 12, 2014 by Kenneth Fisher

    I frequently see the default trace mentioned in answers to forum questions, blog posts, articles, even training sessions. My knowledge …
    Continue reading

    Category: Microsoft SQL Server, SQLServerPedia Syndication, System Functions and Stored Procedures | Tags: , ,

Follow me via RSS

RSS Feed RSS - Posts

RSS Feed RSS - Comments

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,753 other subscribers

Follow me on Twitter

@sqlstudent144

Archives

Categories

Meta

ToadWorld Pro of the Month November 2013