SQL Trace

External Article

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

Blogs

A New Word: Ghough

By

ghough – n. a hollow place in your psyche that can never be filled;...

T-SQL Tuesday: Encryption and Data Protection

By

I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...

Parameterize your Databricks notebooks with widgets

By

Widgets provide a way to parameterize notebooks in Databricks. If you need to call...

Read the latest Blogs

Forums

SSRS Report Upgrade issue with # Temp tables for 800+ lines of Query

By ralahari

one of the Report which calls two Data sets , Data set1 Contains ,...

How to Implement

By ralahari

Hi Team, I want the sample code to join the Table based on case...

Community at PASS Summit

By Ryan Booz

Comments posted to this topic are about the item Community at PASS Summit

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers