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)

You rated this post out of 5. Change rating

2021-12-22 (first published: )

14,291 reads

Stairway to SQL Server Extended Events

Stairway to SQL Server Extended Events Level 2: Creating Basic Event Sessions in the UI

In this Level, we'll walk through the basics of using the New Session dialog in the UI to create a new event session, define its events, actions and predicates, and establish a target for the session in which to collect the event data.

You rated this post out of 5. Change rating

2021-11-24 (first published: )

8,330 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.

You rated this post out of 5. Change rating

2020-06-30 (first published: )

21,669 reads

Technical Article

Back to Basics: Capturing Baselines on Production SQL Servers

If you have not been capturing baselines on your production servers, then today is the day you can start. This article provides scripts, valid for SQL Server 2005 and higher, which anyone can use to capture basic information about a SQL Server instance.

You rated this post out of 5. Change rating

2020-06-30 (first published: )

37,039 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)

You rated this post out of 5. Change rating

2019-03-26 (first published: )

4,688 reads

Technical Article

Capturing Baselines on SQL Server: Where's My Space?

In this article, we'll tackle the topic of monitoring disk space usage. By tracking how much is in use and how much is still available, over time we'll have the data we need for better capacity planning, and can ensure that a database won't ever run out of disk space.

You rated this post out of 5. Change rating

2013-01-23

10,257 reads

Blogs

Truncate Table Pitfalls

By

 Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....

dataMinds Connect 2025 – Slides & Scripts

By

You can find all the session materials for the presentation “Indexing for Dummies” that...

“SQL Server Is Slow” Part 4 of 4

By

Parts 1, 2 and 3 got you to the (SQL) engine room. Now we...

Read the latest Blogs

Forums

visual studio seems to lose "provider" on pkg imports

By stan

hi, just to get this part out of the way, if my intended target...

ERD Tools recommendation

By Coffee_&_SQL

Hey All, I'm looking for a free ERD tool. Does anyone have any recommendations?...

Stairway to Azure SQL Hyperscale – Level 3: RBPEX Caching Layer Internals

By Chandan Shukla

Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...

Visit the forum

Question of the Day

Vector Datatype Dimensions

The new vector datatype in SQL Server 2025 requires a number dimension parameter. What is the maximum number of dimensions supported?

See possible answers