Articles tagged

01 October 2018
01 October 2018

Adaptive Query Processing in SQL Server 2017

As new versions of SQL Server have been released, the Query Optimizer has undergone many improvements. Adaptive Query Processing, new in 2017, represents a new direction. This set of features provides some flexibility for varying join types, multi-statement table valued functions, and memory grants. In this article, Robert Sheldon explains the three features that make up Adaptive Query Processing … Read more
27 September 2018
27 September 2018

Extended Events Workbench

The Extended Events (or XEvents) feature has been part of SQL Server since 2008, but many database professionals struggle to get started using it. In this article, Phil Factor demonstrates several useful Extended Event sessions that measure just one thing in each. He then provides the code necessary to parse the resulting XML into something you can use.… Read more
10 April 2018
10 April 2018

Execution Plans and Data Protection

One of the most important tools for query tuning is the ability to view execution plans. They are even portable; you can send an execution plan to get advice from someone who doesn't have access to the underlying data. Have you even considered that sensitive information might travel along with the plans? Hugo Kornelis explains how execution plans affect data protection. … Read more
and 10 September 2014
and 10 September 2014

SQL Server Performance Troubleshooting with SQL Monitor 5

Any SQL Server monitoring tool must gather the metrics that will allow a DBA to diagnose CPU, memory or I/O issues on their SQL Servers. It should also provide a set of accurate, reliable, configurable alerts that will inform the DBA of any abnormal or undesirable conditions and properties, as well as specific errors, on any of the monitored servers. This article provides an in-depth guide to the monitoring and alerting functionality available in one such tool, Redgate SQL Monitor. It focuses on the latest edition (5.0), which includes several key new features, such as performance diagnosis using wait statistics, the ability to compare to baselines, and more.… Read more
03 April 2013
03 April 2013

Top Six SQL Monitor Metrics for Analysis

Many SQL Server metrics tell their story best when displayed together on the same graph, so you can see how the things you're measuring vary against each other, over time, in order to gain a summary of the stresses on the server. So what six metrics should you choose? Grant comes up with his six favourite diagnostic metrics.… Read more