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
 

pass_summit_2015

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!

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.