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.

2011-03-28

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,682 reads

Blogs

ConFoo–The Future of Database Development in Containers

By

I delivered a talk at the ConFoo conference. I’ve never been to this live,...

Daily Coping 25 Feb 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

2020 Advent of Code–Day 3

By

This series looks at the Advent of Code challenges. As one of my goals,...

Read the latest Blogs

Forums

Shortcutting Git Commands

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Shortcutting Git Commands

What's a Lot of Money?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What's a Lot of Money?

Newb - SQL Server IIF() Function

By FGJ

I am using the following function: IIf([var1Title] != '', [var1Title] + ' - '...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers