May 292016
 

SQL-GG-Side-CoverThis coming week is packed full of fun events! On Wednesday, June 1st at 2pm Eastern, I’m participating in a webinar with ActualTech Media called ‘Modern Storage Strategies for SQL Server‘ where we will talk about key concepts from the recent e-book that we released together.

Session Details: Databases are wild! How can you successfully virtualize and provide storage for SQL Server? In this case, what you don’t know CAN hurt you! This brand new webinar featuring Gorilla Guide author and SQL Server expert David Klee will help you get up to speed on the latest advancements in SQL Server performance optimization and virtualization.  Discover everything you need to know to swing effortlessly through the modern database jungle!

Register for this free webinar here!

SQLSentry03-150Next, on Thursday June 2nd at 11am Eastern I’m joining Kevin Kline and Jason Hall from SQL Sentry for a fun webinar called ‘Performance Monitoring for VMs Running SQL Server‘ where we will discuss topics around performance monitoring for SQL Servers that are running inside VMs.

Join our panel of industry experts for a deep dive into monitoring VMware and Hyper-V environments running SQL Server. The panel includes David Klee (@kleegeek), Kevin Kline (@kekline), and Jason Hall (@sqlsaurus) for a discussion covering issues like what are the important performance metrics to monitor, how to maintain peak performance, and ways that SQL Sentry Performance Advisor take all the pain out of maintaining and monitoring your VM estate for peak performance.

Register for this free webinar here!

sqlsat_maine_2016Finally, this coming Saturday, June 4th, is the next SQL Saturday in our new home, Portland Maine. I’m helping with the event, and know it’s going to be a great one! I hope anyone in the region can attend!

May 232016
 

vmworld_2016I am extremely proud to announce my participation in the inaugural SQL Server workshop at this year’s VMworld US in Last Vegas on August 27th. If your SQL Servers are running in a VMware environment, this course is critical to your success!

The first business critical applications and databases pre-conference workshop will cover all pertinent aspects of best practices for deployments and ongoing management of MS SQL Server running in virtualized infrastructure. This deep-dive full-day workshop will be delivered by VMware technical SQL Server specialists working in concert with world renowned external SQL Server and Virtualization experts, including me! The attendee will experience a workshop rich with technical content to include subjects such as vMotion for Failover Cluster Instances, Availability groups, SQLaaS with vRealize Automation and Site Recovery Manager. The content will be focused on best practices for design, implementation and management augmented with anecdotes of successful customer implementations.

SQL Server professionals, listen up. If your infrastructure admins are attending VMworld this year, please let them know about this course. Training them in the intricacies of the VMware platform as it relates to SQL Server, and having the training come from SQL Server professionals, is going to make your virtualization experience better.

Register for VMworld here!

AND – It’s not just SQL Server! A terrific Oracle on VMware session is being held on the same day as well. If you are running Oracle on VMware, I highly recommend your administrators head to this session as well!

May 102016
 

PASS_VC_VirtualizationTomorrow I’ll be presenting a new session for the PASS Virtualization Virtual Chapter called “Virtual SQL Servers, Actual Performancetomorrow at 1PM Eastern time. Register for this free webinar today!

Presentation abstract: Virtualizing your business-critical SQL Servers should not imply that they will run slower than if they were physical. When properly architected and managed, virtual SQL Servers should be equally as fast as their physical counterparts, if not faster. However, if not properly constructed, silent and seemingly random performance killers can strike and significantly hurt your database performance.

This session is packed with many tips and tricks gained from years of experience for getting the most performance from your virtual SQL Servers. The major roadblocks to performance will be discussed and the knowledge gained will help you work with your infrastructure engineers so you can optimize the system stack for performance. Tools, techniques, and processes will be demonstrated to help you measure and validate the system performance of the key components underneath your data.

May 052016
 

sqlsatiowacity2016I’m pleased to announce that I’m launching my next round of all-day precon training session at the upcoming SQL Saturday in Iowa City on 6/10/2016 called ‘The Complete Primer to SQL Server Infrastructure‘.

The focus of the course is to help those new to the enterprise server infrastructure concepts become familiar with the concept and purposes of each layer of the architecture around their databases, and how this knowledge can benefit them as data professionals. Participants will gain exposure to all layers of infrastructure and virtualization underneath SQL Server, from storage all the way through to the SQL Server instance, and will learn how to review and engineer the entire stack with a strong emphasis on SQL Server performance.

The following topics will be addressed during the course:

  • Datacenter Fundamentals
  • Infrastructure Stack Fundamentals
  • Storage and SAN Concepts and Design
  • Networking and Interconnect Topologies
  • Physical Server Technologies
  • The SQL Server Virtual Machine
  • High Availability and Disaster Recovery
  • Performance Investigation and Tuning of the Entire Stack

A working set of the screens and configuration settings referenced in the session, together with the reference slides and documentation, will be provided to attendees, for strategic reference in working with SQL Server and the infrastructure underneath in their own environments.

I am really happy to be delivering this precon, and look forward to seeing you all there! Reserve your seat at this exciting event at EventBrite here. Tickets are available at just $125!

Apr 222016
 

Next week I am participating in two exciting webinars that I want to share with you!

ScaleArc WebinarImprove App Uptime: Tips from MVP David Klee + Customer Case Study with ScaleArc
April 26 – 2:00 PM to 3:00 PM Eastern

Application availability is an “across the stack” problem – straddling the app tier, database, virtualization, and cloud infrastructure. DBAs, IT ops, and architects must do more to improve app uptime, particularly at the database tier, where failovers and maintenance cycles disrupt the app, impacting the customer experience.

Attend this webinar with Mouser Electronics’ Director of IT Operations Mark Price and me. Together, we’ll share their expertise on:

– Enhancements in clustering and Availability Groups
– Why these solutions can’t enable seamless failover
– How database-level buffering and acceleration improve app availability
– What IT can do across the stack to improve the customer experience

Get your questions answered on this live event – register here.

Next we’re going to talk about the reasons and challenges around upgrading to the latest versions of SQL Server with PernixData.

PernixLogo_smAvoiding Landmines when Upgrading to SQL Server vNext
April 27 – 1:00 PM to 2:00 PM Eastern

Upgrading to SQL Server 2014 and beyond gives you new levels of performance and flexibility. This is especially true if you are still on SQL Server 2005, which will no longer be supported by Microsoft as of April 12th, 2016.

But are you aware of the landmines that come with such an upgrade? Going in blind can cost you substantial time and money, which your business cannot afford.

Join this interactive video webinar where PernixData’s Bala Narasimhan and I will discuss how you can navigate the top challenges of a SQL Server upgrade, specifically:

– How to optimize storage to avoid database performance hits
– How to minimize SQL server licensing costs during (and after) an upgrade
– How to go virtual without sacrificing SQL Server performance
– Low cost options for in-memory computing

The webcast will feature a live Q&A. Register now or request an on-demand recording.

For more information, click here.

PASS_VC_VirtualizationAlso, on May 11th I’m presenting a new session called ‘Virtual SQL Servers, Actual Performance‘ to the PASS Virtualization virtual chapter.

Virtualizing your business-critical SQL Servers should not imply that they will run slower than if they were physical. When properly architected and managed, virtual SQL Servers should be equally as fast as their physical counterparts, if not faster. However, if not properly constructed, silent and seemingly random performance killers can strike and significantly hurt your database performance. This session is packed with many tips and tricks gained from years of experience for getting the most performance from your virtual SQL Servers. The major roadblocks to performance will be discussed and the knowledge gained will help you work with your infrastructure engineers so you can optimize the system stack for performance. Tools, techniques, and processes will be demonstrated to help you measure and validate the system performance of the key components underneath your data.

RSVP for this webinar today, and be sure to bring your questions!

Apr 082016
 

A number of you sent me some excellent questions about this topic, and my favorite asked me for the query that you can use to get this information DIRECTLY from the VMware vCenter database.

SO… here you go! Just plug in your VM name (which might differ from your FQDN name). Feel free to modify this as needed for your own purposes.

This query will fetch the Co-Stop time from within the vCenter database server. This value is the summation of Co-Stop values over a five minute interval for the last day, if the vCenter statistics collection process is set at the default (and it usually is).

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

SELECT
    vv.[name] AS VMName,
    vh.NAME AS HostName,
    cl.name AS VMwareClusterName,
    vhsd.sample_time AS SampledTime,
    vhsd.SAMPLE_INTERVAL AS SampleInterval,
    vhsd.stat_value AS CPUCoStopTime5mSumInMS,
    vv.num_vcpu AS VMvCPUCount,
    vhsd.DEVICE_NAME AS vCPUNumber
FROM
    dbo.VPXV_HIST_STAT_DAILY vhsd
    JOIN dbo.vpxv_vms AS vv ON vhsd.entity = N’vm-‘+cast(vv.vmid AS NVARCHAR)
    JOIN dbo.vpxv_hosts AS vh ON vv.hostid = vh.hostid
    JOIN dbo.VPXV_COMPUTE_RESOURCE AS cl ON cl.RESOURCEPOOLID = vh.farmid
WHERE
    vv.[name] = ‘DB01’
    AND stat_group = ‘cpu’
    AND stat_name = ‘costop’
    AND vv.[name] IS NOT NULL
    AND ltrim(rtrim(vhsd.DEVICE_NAME)) != ”
ORDER BY
    VMwareClusterName ASC, VMName ASC, SampledTime DESC, vCPUNumber ASC

Enjoy!