Using Extended Events to Detect Connection Pooling

What is connection pooling? Lets start with a definition from MSDN.
Connecting to a data source can be time consuming. To...

Matching Events into Pairs

In this article I will be taking you into the world of the pair_matching target. The pair_matching target should connote that this target works on matching like events into...

Matching Events into Pairs

In the last article I showed how to discover all of the settings that are available to a particular Target....

Too Big To Be Visible - SQL Server vs. Oracle data in SSRS reporting

[2015-Oct-20]  A sourcing system failed to return correct results (returned value was a very high figure with double digit number...

Using Extended Events to Detect Connection Pooling

What is connection pooling? Lets start with a definition from MSDN. Connecting to a data source can be time consuming....

SQLSaturday - Portland : Detect Worst Performing SQL Queries During Peak Hour

SQLSaturday - Portland : Detect Worst Performing SQL Queries During Peak Hour

SQLSaturday - Portland : Detect Worst Performing SQL Queries During Peak Hour

SQLSaturday - Portland : Detect Worst Performing SQL Queries During Peak Hour

SQLSaturday – Portland : Detect Worst Performing SQL Queries During Peak Hour

Detecting worst performing queries executed in a particular duration and how many times it got executed and fine tuning them is a single most efficient technique to fix unexpected...