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.

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 21 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.

How expensive are column-side Implicit Conversions?

Posted by Jonathan Kehayias on April 15, 2013 6 Responses »

Apr 152013

Jonathan Kehayias (@SQLPoolBoy) demonstrates column-side implicit conversions and the impact they can have on a workload. He concludes that you can only throw hardware at this problem for so long; a design or code change will be necessary to solve the performance issue long-term.

1 2