Sep 102015

ITnDevConnections_logo_TylerOptimized_236x59Next week is the wonderful IT/Dev Connections conference in Las Vegas, and I’m proud to announce that I’m presenting two sessions! The conference is being held at the ARIA Resort and Casino from September 14-17.

The first session is Benchmarking Your SQL Server Environment, located in Bluethorn 4 on September 15 from 11a-12:15p. I’m co-presenting this session with Ben DeBow from Fortified Data.

What do you do when a user reports that “the database is slow again”? Do you run the user’s queries to see how the database is working? How do you try to track down the issues your users report? Wouldn’t you like to quickly whip out some performance numbers and review the platform to see if anything is amiss? This informative session will show you how to eliminate the subjectivity in the performance of your mission-critical SQL Server systems and replace it with objective performance metrics. Benchmarks and baselines can help you quickly find any performance anomalies in the environment, plus help you project performance and capacity into the future. Tools, techniques, and scripts will be shared and demonstrated.

The second session is called Handle with Care: Virtual SQL Servers, and is located in Bluethorn 5 and 6 on September 16th from 1:15-2:30p.

Maintaining the performance of a mission-critical SQL Server system during the virtualization process is different from less resource-intensive applications. Practices and processes that have worked for years for less-complex applications can detract from the performance of a large database server; but why? This hypervisor-agnostic session will explore the reasons why SQL Server is so hard to successfully virtualize and give you many strategies for working through each challenge to get the most performance out of your virtualized SQL Server systems. We’ll present tips and tricks for solving performance problems at each layer: storage, interconnects, hypervisor, VM, OS, and SQL Server. If you manage at least one virtualized SQL Server system in your environment, this session is for you!

I hope to see all of you at the conference, and if you have a SQL Server virtualization, performance tuning, or infrastructure question that you want to talk one-on-one with at the conference to discuss any challenges you’re experiencing, drop me a line and let’s meet up!

Aug 122015

Next Wednesday, August 19th, at noon Eastern the PASS Virtualization Virtual Chapter will be holding an open questions and answers session on anything related to SQL Server virtualization, with me as your host! Send over your questions to either Tom Norman (VC lead), or over to me and we’ll get them answered for you! Any SQL Server virtualization question is welcomed in this no-holds-barred open session.

RSVP for this free webinar here! I look forward to seeing you all there.

Jul 102015


I am very pleased to announce that Argenis Fernandez and I will be presenting a new precon training session at this year’s PASS Summit in Seattle entitled “The Complete Primer to SQL Server Virtualization“. This all-day preconference training session is to be held on Monday, October 26th, at the Seattle Conference Center.Argenis FernandezDavidKlee

This interactive session is sure to be a blast! If you have a virtualized SQL Server in use today, you need to be at this training event.

Virtualization is here to stay, and learning more about the infrastructure underneath your mission-critical SQL Servers will make you a better DBA. If they are not already virtualized, it’s probable that they will be virtualized soon. The virtual infrastructure is a vital portion of the server ecosystem, and this session is designed to ramp you up so you can do everything from understand the sysadmin lingo to quickly identify and triage infrastructure issues.

(Plus, we both have quirky senses of humor and love Nerf projectiles, so you’re sure to get a laugh or two!)

Training session abstract: Your SQL Servers are mostly virtualized at this point, but have you lost the control you used to have over the infrastructure when they were physical servers? Do your SQL Servers “feel” slower now that they are virtualized? When architected and managed with SQL Server in mind, this added layer can help to improve the SQL Server’s availability and ability to change with the business, but only when executed properly.

This all-day, interactive, and hypervisor-agnostic pre-conference session is designed to help data professionals learn more about virtualization and infrastructure. Discover how this new layer can be used to improve the management, availability, and performance of your databases. You will be exposed to all layers of virtualization underneath the SQL Server, from storage to hypervisor. Discover many useful tips and tricks to tuning the database layer to boost performance and availability. This session addresses these topics:

* Virtualization and infrastructure fundamentals

* The SQL Server virtual machine (VM)

* Networking, support, and licensing

* High availability and disaster recovery

* Performance investigation and tuning of the entire stack

Register for the PASS Summit today (and do it before July 12th, when the price hikes!) and make sure to sign up for this precon! This is the best event for SQL Server practitioners, hands down, and this event is vital for the continued professional growth and efficacy in the role of a data professional.

Jun 292015

I recently recorded a podcast with the SQL Server Radio group and discussed virtualization, high availability, and independent consulting topics. I had a lot of fun!

We talked about:

  • What’s important to know when virtualizing SQL Server
  • How to properly size your VM
  • What metrics to monitor when virtualizing
  • When to use SQL Server High Availability features and when to use them at the virtualization side
  • When NOT to virtualize
  • Some of my most challenging projects

In addition, we talked about starting a company and the life of an independent consultant.

Check out this Podcast here!

Jun 262015

I have an exciting training session announcement! On Friday, July 10th, I will be presenting a full-day training class ahead of the SQL Saturday event in Columbus, OH entitled “SQL Server Virtualization for VM Admins“.  (DBAs are very welcomed too!)

Abstract:  This full-day course is an introduction to enabling and managing a virtualized SQL Server environment. The focus of the course is to help those infrastructure systems professionals who manage a business-critical virtual SQL Server environment understand the impact of SQL Server on their environments and how to better architect the platform to maximize availability and performance. Participants will gain exposure to the impact of virtualized SQL Server to all layers of virtualization underneath SQL Server, from storage to hypervisor to the SQL Server instance, and will learn how to construct the entire stack with a strong emphasis on SQL Server performance. High availability, disaster recovery, multi-tenancy, and performance tuning topics will all be explored during the session.

Seats are limited, so reserve yours today! At only $99, this course is sure to help you get more out of your virtualized SQL Server environment!

Jun 232015

http://www.mssqltips.comThank you all for attending my MSSQLTips webinar today with Sumeet Bansal from Tegile Systems! In the presentation, I made reference to a disk stall collector that you can use to help collect and store database file-level latency statistics into a database for future reference, as well as an aggregation script that analyzes the metrics to provide a percentile analysis of the storage performance trends. These metrics can be presented to a storage administrator to help you demonstrate latency trends and help identify any performance challenges.

Teglie-Logo-Blue-Transparent-smallThe scripts are available for you to download and execute here.

Disk Stall Collector Instructions

Disk Stall Collector Setup

Disk Stall Collection Aggregation

In addition to the disk stall collector, which collects disk latency metrics at the SQL Server level, you can also use Perfmon to collect raw data at the Windows layer. I have a Perfmon setup guide on this site that you can use to set up Perfmon for 24×7 collection to overlay Windows-level statistics with the SQL Server-level statistics from the disk stall collector. Check out the guide here!