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 course) but let’s make one more push. This month I’d like you to take a look at the default trace and the system health extended events session. Last month I had you looking at the built in reports in SSMS because they have a ton of great information and can be really convenient. Well these have even more information, some of which you won’t find anywhere else, but they aren’t all that convenient. On top of that they have a fixed amount of rolling storage so the information goes away over time. In fact depending on the level of activity of the server the information in the default trace can go away within less than a day. That means that if there is something in there you need, you need to get to it pretty quickly. Combine that with the difficulty of getting to the information means you’d best have some practice.

So take some time this month and review what information is available (for example the deadlock graphs), run some tests, and read the data.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

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

ToadWorld Pro of the Month November 2013
%d bloggers like this: