Jonathan Kehayias

Jonathan Kehayias is a Principal Consultant with SQLskills. He is the youngest person ever to achieve the Microsoft Certified Master - SQL Server 2008 certification and has been a SQL Server MVP for many years. Click here for a full bio.

Improved Support for Parallel Statistics Rebuilds

Posted by Jonathan Kehayias on May 27, 2016 3 Responses »

May 272016

Jonathan Kehayias (@SQLPoolBoy) takes a closer look at a new trace flag that allows you to process multiple concurrent statistics updates on the same table.

Monitoring Availability Group Replica Synchronization

Posted by Jonathan Kehayias on August 31, 2015 10 Responses »

Aug 312015

Jonathan Kehayias (@SQLPoolBoy) of SQLskills uses practical examples to show multiple ways to monitor Availability Group replica synchronization in your environment.

Predicate Order Matters in Extended Events

Posted by Jonathan Kehayias on June 19, 2014 No Responses »

Jun 192014

Jonathan Kehayias (@SQLPoolBoy) of SQLskills discusses predicates in Extended Events, and demonstrates why you need to list state-related predicates last.

Configuring Service Broker for Asynchronous Processing

Posted by Jonathan Kehayias on March 27, 2014 22 Responses »

Mar 272014

Jonathan Kehayias (@SQLPoolBoy) continues his Service Broker series; in this post, he demonstrates asynchronous functionality by walking through a simple configuration and example.

An Introduction to Asynchronous Processing with Service Broker

Posted by Jonathan Kehayias on March 18, 2014 3 Responses »

Mar 182014

Jonathan Kehayias (@SQLPoolBoy) of SQLskills kicks off an interesting series on configuring and using Service Broker to accomplish asynchronous processing in SQL Server.

VMware CPU Hot Plug vNUMA Effects on SQL Server

Posted by Jonathan Kehayias on December 30, 2013 6 Responses »

Dec 302013

Jonathan Kehayias (@SQLPoolBoy) shows how VMWare's vCPU hotplug technology can cause serious performance problems in certain vNUMA configurations.

Looking at Database Snapshot Performance

Posted by Jonathan Kehayias on May 21, 2013 9 Responses »

May 212013

Jonathan Kehayias (@SQLPoolBoy) of SQLskills.com takes a look at snapshot performance, with some surprising observations about what happens if you have more than one concurrent snapshot.

1 2