VMware vSphere 6.5 breaks your SQL Server vNUMA settings

vmwareVMware’s latest release of the vSphere virtualization suite, version 6.5, changes how they handle vNUMA presentation to a virtual machine, and there’s a high likelihood that it will break your virtualized SQL Server vNUMA configuration and lead to unexpected changes in behavior. It might even slow down your SQL Servers.

Here’s what you need to do to fix it.

Read more


VMware Expert Database Workshop Wrapup

Two weeks ago, Heraflux was proud to be part of the next wave of the SQL Server Expert Workshop hosted by VMware Corporation in Sofia, Bulgaria. These sessions are driven from VMware Corporation’s desire to produce the best hypervisor for mission-critical applications. Periodically, VMware invites a number of SQL Server and Oracle experts from around the world to meet for a three day interactive workshop on all aspects of database virtualization. The goals are two-fold: to educate these individuals on where VMware is going with database virtualization, and to learn from them on the current challenges they face and their experiences with enterprise virtualization so they can improve the platform and features.

This session was held at the VMware Sofia Bulgaria office, where a number of the technical experts who build the various platforms and features that VMware users utilize every day.

vmware-corp-sofia-bulgaria

This session’s attendees come from the SQL Server community from all over the world, including Netherlands, Slovenia, United Kingdom, Germany, Austria, Bulgaria, Poland, Italy, Kosovo, Norway, South Africa, and United States.

In addition to the attendees are a number of veterans of the class, including Michael Corey of Corey & Associates, Allan Hirt of SQLHA, Denny Cherry of Denny Cherry & Associates Consulting, and David Klee from Heraflux.

Many individuals from VMware Corporation push very hard for months to make these sessions happen, including:

  • Don Sullivan, Product Line Marketing Manager, VMware
  • Mohan Potheri, Senior Solutions Architect, VMware
  • Deji Akomolafe, Staff Solutions Architect, VMware
  • Niran Even-chen, Staff Solutions Architect & Double VCDX, VMware
  • Harry Girgorov, Events and Program Manager, VMware
  • Ralitsa Drumeva, Management Assistant, VMware

Michael Corey took some amazing photos during the event, and they are available here:

Day 1 Day 2 Day 3

Twitter #VMWSQL

This event is Heraflux’s third iteration of this training session, and like previous sessions David Klee assisted in the class by giving multiple training sessions on the inner workings of the VMware platform and tuning for performance.

These sessions are world-class, and the knowledge transfer is bidirectional.

Heraflux would like to thank VMware for letting us continue to be a part of these sessions, and would like to thank the VMware staff in Bulgaria for their incredible hospitality and comradery.

20161117_205345

20161114_081635

20161115_21233020161115_212442

20161115_152208

We look forward to the next one, wherever in the world it is held!


SQL Saturday Lincoln Wrap Up

sqlsat552_webThis past weekend our Solutions Architect Cody Chapman presented at this year’s SQL Saturday in Lincoln, Nebraska on the topic “Ping! (No Reply)“.

Session Abstract: Oh! ASYNC_NETWORK_IO just went through the roof! What just happened?

Ever wonder how common tasksSolutions Architect such as how servers communicate, how cross-subnet Availability Group failover to your disaster recovery site work, or why ‘they’ always recommend a dedicated network adapter for your WSFC? De-mystifying the networking underneath your databases makes you a stronger database professional. This deep dive technical session will cover many of the critical aspects of enterprise-level networking and how your database servers communicate with the rest of the world. Topics and demonstrations include networking technologies, quality of service, VLANs, routing, monitoring, and trending.

By the end of this interactive session, you will be able to check your own networks for their performance and know how to converse with the networking admins to help improve the overall performance.

The slides have been posted for you to download! Feel free to contact us if you have any questions!


SQL Server Infrastructure and Virtualization Boot Camp

Heraflux is proud to announce the availability of our new training offerings! We are launching a live web-based version of our one-day SQL Server infrastructure and virtualization master class. We are hosting an all-day training session before the end of the year to help you take advantage of quiet(er) times around the holidays. Select from one of the dates that works best for you and register today!

Tuesday, November 22nd – 10:00am to 6:30pm Eastern

Thursday, December 29th – 10:00am to 6:30pm Eastern

Looking to ramp up on the infrastructure and virtualization underneath your databases? Want to learn how to work effectively with the other silos in your IT organization? This live web-based training will help take you to the next level by understanding the architecture, performance characteristics, and performance tuning opportunities of the storage, physical server hardware, virtualization hypervisor, and VM layers underneath your critical SQL Server databases.

David KleeMicrosoft MVP and VMware vExpert David Klee leads this full-day introduction to getting the most out of the infrastructure underneath your SQL Server environment. The focus of the course is to help those new to the enterprise server infrastructure concepts become familiar with function and purpose 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.

Intended Audience

The intended audience of this course is information workers (both business and IT-centric) involved with architecting an enterprise IT strategy for SQL Server.

Course Topics

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

Course Objectives

Upon completion of this course, attendees will be able to:

  • Understand key infrastructure concepts
  • Determine the optimal infrastructure configuration for best performance
  • Review their own enterprise infrastructure for performance bottlenecks
  • Construct a SQL Server virtual machine template with best practices for agility and performance
  • Understand how and what stack metrics to benchmark and baseline to ensure proper objective performance measurement
  • Identify and remediate common infrastructure-related SQL Server performance killers
  • Understand proper capacity management techniques for long term management

Prerequisites

Attendees with the following experiences will benefit the most from this course:

  • Basic familiarity with the core components of a server
  • SQL Server installation and configuration
  • Exposure to SQL Server performance metric measurement and identification

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.

Seats are limited in this training offering, so register now!

Tuesday, November 22nd – 10:00am to 6:30pm Eastern

Thursday, December 29th – 10:00am to 6:30pm Eastern