Erin Stellato


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.

2018-11-28 (first published: )

3,297 reads

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 (1)

2017-08-23 (first published: )

9,591 reads

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.

2014-10-17 (first published: )

19,677 reads

Blogs

What is a model database?

By

Do you ever take a look at SSMS in the System Databases section? People...

Daily Coping 26 Jan 2021

By

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

Rowcount estimates when there are no Statistics

By

When you don't have statistics, what does SQL use to calculate the estimated number...

Read the latest Blogs

Forums

How to create a gantt chart for event rooms during a day

By PatrikW

Hi all, This will be my first ever post in a forum like this....

[ODBC Error]

By DBA_007

When backup job runs we are receiving the below error and database connection closes....

Error: The size necessary to buffer the XML content exceeds the buffer quota

By Jim-S

Hi Guys, I have a report named Master and a report named Child, Child...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers