Jul 242017
 

One of the biggest differences with managing SQL Server Linux is with drive presentation. With Windows, we’d all scream if we saw a SQL Server with just one drive (C:) and everything piled on it. The same goes for any other operating system, including Linux. But, how do we get the additional drives added and configured properly? It’s (not) the easiest, but it’s straightforward! Let’s walk through it.

Continue reading »

 Posted by at 9:29 am  Tagged with:
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: