SQL Server Default Trace

Microsoft SQL Server database administrators have many excellent logging and debugging tools available to them. Among these is the “default trace.” The SQL Server database engine ships with a special trace enabled and logging *.trc or “trace” files to the default SQL LOG folder (database system log messages, *not* transaction logs). These traces can be viewed with the SQL Server Profiler tool included with the standard SQL Management tools install option. Find more details in the following related articles:

If more detailed trace information is needed, the SQL Profiler provides the ability to select specific trace criteria beyond what the default trace provides. See the official Microsoft documentation or search the web for more on SQL Server tracing and profiling features.


About notesbytom

Keeping technology notes on WordPress.com to free up my mind to solve new problems rather than figuring out the same ones repeatedly :-).
This entry was posted in Database and tagged , , , , . Bookmark the permalink.

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