Erin Stellato


Stairway to SQL Server Extended Events

Stairway to SQL Server Extended Events Level 1: From SQL Trace to Extended Events

Over the course of this stairway series, we're going to explore in detail the use of Extended Events as a diagnostic data collection tool, to track down causes of poor performance in SQL Server. This first level will start from a point known and familiar to many DBAs, namely the use of SQL Trace to track down and investigate long-running queries.

5 (2)

2021-12-22 (first published: )

12,887 reads

Technical Article

5 Reasons You Must Start Capturing Baseline Data

It is widely acknowledged within the SQL Server community that baselines represent valuable information that DBAs should capture. Unfortunately, very few companies manage to log and report on this information, and DBAs are then forced to troubleshoot from the hip and scramble to find evidence to prove that the database is not the problem. This article will make a compelling argument for why DBAs must start capturing baseline information, and will create a roadmap for subsequent posts.

2020-06-30 (first published: )

20,778 reads

Stairway to SQL Server Extended Events

Stairway to SQL Server Extended Events Level 4: Extended Events Engine - Essential Concepts

In this level, we're going to dig a little deeper into the Extended Events engine, its architecture, and fundamental components. It will give you a deeper understanding of why, in general, an Extended Events session is inherently lower in overhead than an equivalent SQL Trace. We'll also investigate how to design our event sessions to minimize any unnecessary overhead during event data collection, even when we need to create relatively complex event sessions to investigate difficult performance problems.

5 (1)

2019-03-26 (first published: )

4,046 reads

Blogs

Migrating or Recovering a TDE Protected Database 

By

When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...

New Pluralsight Course – Securing Azure Kubernetes Service (AKS) Clusters

By

My new course “Securing Azure Kubernetes Service (AKS) Clusters”, co-authored with my good friend...

Join Denny Cherry and Associates at SQL Bits 2023

By

I am very excited and lucky to be speaking once again at SQLBits along...

Read the latest Blogs

Forums

Issue importing data to SQL table

By Jobs90312

Hi everyone, I have a XML file in which data looks like this: <ArrayOfHomeModel...

Database details missing in SYS.MASTER_FILES view

By sanei05

Hi, I noticed that one of the database information is missing in sys.master_files catalog...

Single index reorg took 2 full days or more to complete

By JasonO

I'm running an index maintenance job on 1 of my large database as the...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers