Through the virtual looking glass – monitoring virtualised SQL
Using demos and theory this session shows how virtualisation changes the way we need to monitor the performance of a virtualised instance of SQL Server. By simulating bad resource contention and overloading we will see how SQL Server’s own performance counters and wait stats along with Perfmon’s counters react to CPU, memory and storage pressures. Some performance counters in the virtual world hide issues, while others exaggerate it, the purpose of this session is to demonstrate a balanced and well-rounded approach to performance monitoring in the virtual world along with best practices to avoid poor virtualised performance.
Gavin is a solution architect leading, designing and implementing information platform and data centre transformations. He has a track record of delivering projects that provide new functionality, consolidation, and standardisation. He also provides guidance in the broader areas of enterprise IT landscapes and operational best practices. He is also one of 25 Microsoft Certified Architects for SQL Server in the world and a Microsoft Certified Master, and holds architect certification from the Global IT Architect Association, IASA. His technical expertise focuses on Microsoft SQL Server data platforms and cloud infrastructures, primarily in the retail and services sectors.