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!

Jun 222015
 

This Tuesday, June 23rd, at 3pm Eastern time I will be co-presenting a free live webinar with Sumeet Bansal from Tegile Systems at MSSQLTips entitled “Performance insights and tuning of Physical and Virtual SQL Servers”. Register for this free webinar here! All registrants will be registered for a raffle for  GoPro Hero digital video camera too!

Webinar Description:

This session will cover some of the best practices on setting up SQL Server in a virtual environment. You will learn what knobs and levers to tweak to get the best performance out of your setup. The speaker will cover various methods of collecting and analyzing performance data as well as pinpointing performance bottlenecks. You will also see a demo of performance you should expect from your virtualized SQL Servers. By the end of the session, you will have the information to improve utilization by leveraging virtualization for your SQL Server platform while delivering high performance. You will also have the necessary tools and data to have an educated conversation with your storage teams.

Speakers:

DavidKlee David Klee is a Microsoft MVP and VMware vExpert with over seventeen years of IT experience. David spends his days handling performance and HA/DR architecture of mission-critical SQL Servers as the Founder of Heraflux Technologies. His areas of expertise are virtualization and performance, datacenter architecture, and risk mitigation through high availability and disaster recovery. You can read his blog at davidklee.net, and reach him on Twitter at @kleegeek.
SumeetBansal Sumeet Bansal as a VP of IT and lead DBA implemented flash technology at wine.com in late 2009 to solve critical business problems. He implemented the first data warehouse at wine.com to streamline analytical reporting. He has over 16 years of IT experience covering database platforms such as Oracle and SQL Server along with datacenter architectures. His database experience involves extensive hands-on work with database performance, application acceleration and systems administration. Summet has been the resident SQL Server and database expert at several top flash companies including: Fusion-io, Violin Memory and most recently Tegile.
Jun 152015
 

SIOS_logoRGB160x160I’m learning how beneficial SIOS iQ is to your virtual SQL Server environments, and you should too.

SIOS iQ is a new machine-learning utility that helps you optimize your VMware-based environments to understand VM waste, reliability, and cause-and-effect relationships with performance anomalies in the infrastructure. It connects into VMware’s vCenter Server and profiles the workload and performance trends in the environment. The content that it delivers helps you see more about how the environment is performing and trending, and does so in a different way than any other product on the market today.

sios_iq_01  sios_iq_02

Currently the platform is in a ‘Freeview’ mode while the platform matures, but you can register and download it for free today.

I think it’s fantastic, and shows a lot of potential. The impact of this utility for understanding the true impact analysis of performance troubles on your infrastructure will help you immensely. Deploy it today and see what you think!

May 222015
 

memory-ramA few weeks ago, while at the incredible SQL Saturday Madison, I had a great discussion with a few of the other speakers about SQL Server VM-level memory counters and their (lack of) validity on the actual memory usage properties of the SQL Server engine. A while back, I blogged about this but I want to revisit it here.

VM-level memory counters simply cannot be trusted for SQL Server workloads at this time. Period. VM memory counters are not application aware, and as a result, are not aware of the way that in-guest applications use memory.

Continue reading »