Jul 242017
 

I’ll be speaking at two New England area SQL Server user groups in the next few days! First, tonight I’ll be at the Portsmouth, NH, SQL Server Users Group speaking on the newly announced SQL Server on Linux. It’s going to be a blast showing folks that SQL Server on Linux is a viable alternative for businesses out there.

Next, tomorrow night I’ll be at the downtown Boston SQL Server Users Group tomorrow night for a session on Performance Tuning for SQL Server VMs. This session gets a little free-form, as I encourage all attendees to bring your specific questions, challenges, (mis)conceptions, opinions, etc. to the table and let it all out.

RSVP for these events if you’re in the area, and if not, ping me and let me know if your user group would like a presentation on these topics!

 Posted by at 9:11 am
Jul 232017
 

My slide deck from the recent webinar series 24 Hours of PASS, Summit Preview session, where I presented a session called Virtual CPUs: Right to Ludicrous Speed, are now available for you to view up at SlideShare. Let me know if you have any questions! I hope to see you all at the PASS Summit later this year!

Jul 122017
 

I get asked all the time – “why virtualize SQL Server if I’m content with my physical servers today?” The normal answer, outside of the usual answers of increased agility, flexibility, cloud-readiness, etc., is that license optimization is possible if your organization has enough scale to license a set of virtualization hosts and manage VM density to maximize licensing.

But, what if your organization does not have the sheer volume needed to cross that break-even point on the virtualization investment? What if the SQL Server version, platform, and app are happy? What other talking points do we have that can encourage virtualizing every SQL Server?

There are quite a few less-tangible benefits, such as VM migrations for hardware or SAN upgrades, ease of system-level backups and disaster recovery, improved operational high availability choices, and greater flexibility and agility in the datacenter. However, it’s difficult to put a dollar amount on this one. All of these are operational benefits that save staff time and energy. But, what about saving cost?

We need to look a bit further out. Eventually, the third-party vended app vendors are going to stop supporting the older versions of SQL Server, and the new versions have all migrated to core-based licensing, which can potentially lead to an unexpected cost during application upgrades. Moving to VMs now – or then – allow you to allocate the number of vCPUs that are needed at the time, rather than whatever the current hardware contains. Future physical server purchases will get harder to find smaller core count servers, all of which will increase the license spend. The vCPUs in a SQL Server instance can be licensed by virtual cores, and that can contribute to a reduction in future licensing purchases. The fact that these VMs could reside on the current VM infrastructure (as long as it is capable and contains enough free resources) could also help reduce or eliminate a future hardware purchase as well.

I know I’m preaching to the virtualization-friendly choir here, but if SQL Server virtualization is not the right call for right now, as time goes on, the necessity for maintaining or reducing CAPEX along with reducing OPEX will make virtualizing these systems a more appealing option as time goes on.

And… virtualizing these platforms is step number one in your cloud readiness strategy. And you are moving towards the cloud, right?

 Posted by at 6:24 pm
Jul 052017
 

If you are actively managing VMware environments with workloads that have high performance needs (such as all of the virtualized SQL Servers that we work on), this new book called VMware vSphere 6.5 Host Resources Deep Dive, written by Frank Denneman and Niels Hagoort, is a must read book! Designed for VMware-oriented system architects, this book walks the reader through each layer of host resource allocation and management in a way that no other book has ever accomplished.

This book redefined the phrase “deep dive”, and I’m taking a lot of notes for future authoring and presentations. The depth of content is unparalleled in tech authoring.

Topic sections such as CPU, memory, storage, and networking, the four main areas of resource management on any virtualization host, are presented. Anyone can talk about these settings in general, but the advanced VCDX-level topics are covered in incredible depth. We work with a lot of advanced virtualized SQL Server VMs, and significant discussions from this book for performance tuning these SQL Servers include:

  • Advanced vNUMA balancing and optimization
  • CPU core counts versus clock speed
  • vNUMA memory speeds and non-local memory access
  • Clearing up misconceptions about vSphere Balanced Power Management
  • Queues and resource allocations

Go get this book – NOW! It’s a must read, and read it twice. No, three times. Then give the book to colleagues who can benefit. I’ve got two copies on my desk right now, and know who these will be sent to after I’m done re-reading them!

Jul 032017
 

I’m proud to announce that I’ve been selected to present a session in this year’s 24 Hours of PASS: Summit Preview webinar series entitled Virtual CPUs: Right to Ludicrous Speed. This session is scheduled for July 20th, 2017, at 03:00 GMT, or July 19th at 11pm Eastern.

These webinar series are a sneak peek at some of the sessions to be presented at this year’s PASS Summit in Seattle the last week of October. These sessions are from world class speakers and authors who we have all been studying under for years, and now you can see them live!

Session abstract: One of the largest points of contention with virtual SQL Servers and the VM administrators is how to configure the CPUs. Experience says more CPUs are better for performance. VM admins say less is better. Third-party vendors say you need all of them (and it doesn’t matter how many your hosts have either). Can over-provisioning virtual machine CPUs speed things up, or does it slow things down? What is the right methodology to determine the correct number of virtual CPUs? How does this configuration align with the physical servers? From sampling and analyzing performance data, to “right-sizing’ your SQL Server virtual machine CPU count, to properly aligning the VM with the physical server NUMA topology, you will gain the understanding of how to properly manage and validate your virtual SQL Server vCPU configuration in this insightful session. Valuable tips and tricks will be shared that you can take back to your virtual SQL Servers and immediately apply to your own environments.

Register today to watch these sessions!

 Posted by at 8:54 am  Tagged with:
Jun 302017
 

I’m proud to announce that my sessions for this year’s VMworld 2017 conference in Las Vegas have turned up in the VMworld Content Catalog! I have four exciting sessions (if you’re a database geek) at the conference, and for those DBAs with VMware administrators attending this conference, tell them to attend these sessions so they can help build a better platform for your data.

ALL DAY SQL Server on VMware Boot Camp

The second revision of our business critical applications and databases pre-conference workshop is to be held at VMworld 2017 US this year on August 26th!

We 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 workshopwill 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! Add the training course at the bottom of the VMware Education courses during the registration process.

Monster VMs (Database Virtualization) with vSphere 6.5: Doing IT Right [VIRT1309BU]

with Michael Corey

VMware vSphere 6.5 has made a lot of changes to enhance the performance of Monster virtual machines (VMs). Databases by their very nature are the classic Monster VMs. If Monster VMs are not virtualized properly, they will never perform well and can negatively impact the performance of other VMs on the hosts. In this presentation, we will teach you how to properly virtualize Monster VMs/databases with vSphere 6.5. We will discuss why you should virtualize and take a look at some installation issues as well as how to architect for performance in terms of vSphere 6.5 specifics, including the storage layer, the processor, memory considerations, and the network layer. Topics will also include NUMA, memory reservations, and how to avoid common mistakes. These lessons will help you optimize any workload you are virtualizing.

Performance Tuning and Monitoring with Virtualized Database Servers [VIRT1430BU]

with Thomas LaRock

Business-critical database platforms are the last holdouts to enterprise virtualization. These systems are the most resource-demanding and latency-sensitive applications, and at the first symptoms of infrastructure challenges the DBAs blame the infrastructure. Successful virtualization of these platforms requires a different approach to virtualization from other applications. The speakers will share their years of experience in virtualizing data platforms. You will learn how to validate your VMware environment and manage the performance properly. Scalability concerns will be addressed through discussions on scaling database VMs upwards and outwards as you work with the DBAs to manage the data lifecycle. Key talking points will help you learn how to perfect database virtualization from a technical, an organizational, and people level.

SQL Server on vSphere: A Panel with Some of the World’s Most Renowned Experts [VIRT1930PU]

with Niran Even-Chen, Thomas LaRock, and Allan Hirt

Continuing from last year’s successful session, learn from some of world’s most renowned SQL Server experts’ real-life experiences gained while virtualizing the most demanding SQL Servers! In this panel discussion, you will also have the chance to ask your own questions about SQL Server on VMware vSphere and get answers from the SQL Server gurus.

For those of you who don’t manage SQL Servers in a VMware environment, check out all of the fantastic sessions in the performance tuning areas, as they are sure to help you boost performacne across your vSphere farms.

Register for VMworld USA today, and make sure to select the SQL Server on VMware boot camp as part of registration! I look forward to seeing you all there!