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
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… Read more
Thank 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… Read more
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… Read more
I’m learning how beneficial SIOS iQ is to your virtual SQL Server environments, and you should too.
SIOS iQ is a new machine-learning utility that helps you optimize your VMware-based environments to understand VM waste, reliability, and cause-and-effect relationships with performance anomalies in the infrastructure. It connects into VMware’s vCenter… Read more
If you live in the Midwest region around Iowa, Nebraska, South Dakota, and Minnesota, you should consider attending the first-ever SQL Saturday in Sioux Falls, SD, on July 18th.
It is going to be held at University Center, 4801 N Career Ave Avera Hall, Sioux Falls, South Dakota. Read more
A few weeks ago, while at the incredible SQL Saturday Madison, I had a great discussion with a few of the other speakers about SQL Server VM-level memory counters and their (lack of) validity on the actual memory usage properties of the SQL Server engine. A while back, I… Read more
The third Level in my Stairway to Virtualization series is now live at SQL Server Central! In this Level, we will review building the ideal VMware-based virtual machine for your SQL Server workloads. Review and incorporate your own corporate standards and policies into these recommendations, and build the VM… Read more
Yesterday the next installment of the Stairway to Virtualization series went live on SQL Server Central! This level focuses on the core “why” questions when it comes to building the ideal SQL Server virtual machine. It focuses on all of the core “why” questions, such as how to configure… Read more
Recently, I was able to help SimpliVity work to develop a reference architecture document for running resource-intensive SQL Server virtual machines on the SimpliVity OmniCube platform. We went through a lot of different OLTP workload types and have put together a number of best practices for virtualized SQL Server on… Read more
A few weeks ago Bala Narasimhan from PernixData and I recorded a short conversation where we discussed the tips and tricks that both DBAs and Infrastructure Administrators need to maximize the performance of their systems without significant re-architecting of their environments. Check it out!
Bala Narasimhan, Vice President of Products from PernixData, and I recently sat down and discussed the convergence of infrastructure, SQL Server, virtualization, and storage systems. We chatted about some of the ongoing challenges of high performance virtualized SQL Servers and the impact they can have on the rest… Read more
My recent post on using the new DiskSpd utility to help you benchmark your storage is a great primer on how to use DiskSpd. But… what if you want to run multiple tests? For example, what if you want to run both read and write tests with a varying degree… Read more
This past week I had the pleasure of being part of the second SQL Server virtualization workshop held by VMware. The first workshop, held last year, was a tremendous success and we all wanted to keep the momentum going with more SQL Server gurus. Over the last few months,… Read more
I have two exciting SQL Saturday preconference training sessions coming up in the month of May!
The first is my Virtualization for SQL Server Professionals training session at SQL Saturday Rochester NY on Friday, May 15th.
Session Abstract: Microsoft MVP and VMware vExpert David Klee leads this full-day introduction… Read more
If you experience a WSFC failover during a VMware vMotion / Hyper-V Live Migration with your virtualized SQL Servers when using Availability Groups, you might have server and/or networking hardware that takes a bit longer than usual to handle the network port failover. This can lead to short unexpected outages… Read more
I am very happy to announce that I will be presenting two sessions at this year’s IT/Dev Connections conference in Las Vegas! The conference is held September 14-17th at the ARIA Resort. My two sessions are:
Maintaining the performance of a mission-critical SQL Server… Read more
I’m proud to announce my company, Heraflux Technologies, is looking to fill the position for Vice President of Business Development. When we first started our company in September 2013, we had a number of short and long term goals about how we wanted to grow and scale our… Read more
Recently, my friend Mike Fal ( b | t ) released a PowerShell script that can sample the counter inside SQL Server that one of my favorite database benchmarking utilities, HammerDB, uses to produce the transactions per minute counter value that the benchmarking utility outputs.
I thought I’d counter… Read more
Today I presented a new session on the various paths to becoming a consultant to the PASS Professional Development Virtual Chapter. I thoroughly enjoyed presenting this session, and the questions were great! Plus, the coordinators for the VC have the session up on YouTube already!
The slides for this… Read more