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.

Erin-Stellato

2018-11-28 (first published: 2016-08-17)

1,918 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.

Erin-Stellato

2017-08-23 (first published: 2015-12-23)

7,496 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.

Erin-Stellato

2014-10-17 (first published: 2012-11-19)

18,814 reads

Blogs

Drop Database Objects Practically Risk-Free!

By administrator

FIRST OF A TWO PART SERIES Some months ago, a fellow DBA came to...

Lengthen a Primary Key–#SQLNewBlogger

By Steve Jones

Another post for me that is simple and hopefully serves as an example for...

Setup SQL Server Alert to get automatically notified of database blockings

By SQLPals

Suppose you want to or need to know anytime your SQL Server is experiencing...

Read the latest Blogs

Forums

Protecting Data Between Services

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Protecting Data Between Services

User Mapping Issues

By DHeath

I have a server that is version 12.0.6214.1 and here is my issue. I...

SQL browser and port number

By John Deupree

We have several new servers running SQL 2014.  Some servers are single instance servers...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers