SQL Trace

The default trace in SQL Server - the power of performance and security auditing

  • Article

Since the introduction of SQL Server 2005, there is a simple lightweight trace that is left running by default on every SQL Server. This provides some very valuable information for the DBA about the running server, but it isn't well-documented. Feodor Georgiev reveals many of the secrets of this facility and shows how to get reports from it.


3,896 reads

Stairway to Server-side Tracing

Stairway to Server-side Tracing

  • Stairway

Learn how to use the SQL Trace subsystem in SQL Server to audit your instances. This series will examine the basics of SQL Trace and teach you how to set up, schedule, and manage traces and the data generated.

5 (1)

2011-02-17 (first published: )

1,391 reads




Hey Command: A confident name that suggests a laid-back approach to leadership. ...



Threat Key: A strong name that suggests competent security solutions. ...



Growing Fortune: A memorable name that is bursting with ambition and opportunity. ...

Read the latest Blogs


Placing Data files on NAS

By tmmutsetse

Hi experts, Is it ok to run a Production DB with data files and...

SQL Server Backup and Restore Ebook error

By as1981

When I fill in the form here https://www.red-gate.com/library/sql-server-backup-and-restore?utm_source=ssc&utm_medium=publink&utm_campaign=books&utm_content=backup_and_restore_ebook&utm_term=backupandrestore and click 'download ebook' the button...

How to upgrade the version of Microsoft SQL Server Integration Services Designer

By Weegee2017

Hi there I am trying to execute a SSIS 2008 package on a SQL...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers