The SQL Server Default Trace


Starting with SQL Server 2005, Microsoft SQL Server has a default trace. I think many of you have already heard about it, but I wonder if all of you are aware of the potential of the default trace. In case you are not aware of it, I found a great article by Feodor Georgiev, that explains what is the default trace, Feodor explains which events are logged in the default trace and gives examples on how to retrieve information from the default trace. At the end of the article Feodor provides a link to the documentation of his default trace reports, from that link you will be able to download a MSI file that you can install on you workstation. I downloaded the MSI an tried the reports on SQL Server 2012. In the documentation you will find instructions on how to access the reports. You can find the article here.

Advertisements

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 )

Google+ photo

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

Connecting to %s