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
Today at 11am Central time I will be presenting a new session entitled “Journey to Being a Consultant” for the PASS Professional Development Virtual Chapter. For those of you who are interested in exploring the options in becoming a consultant, sign into this free session here! Read more
I am very proud to announce that one of my PASS Summit 2014 sessions was selected as one of the Top 10 of the conference, and the presentation is now available on the Best of PASS Summit 2014 list. The session is “Right-Sizing Your SQL Server Virtual Machine”,… Read more
As I mentioned in my storage benchmarking post, storage performance is one of the critical infrastructure components underneath a mission-critical SQL Server.
My defacto storage benchmarking utility has been recently updated. Last October, Microsoft released a great free utility called diskspd, and it is freely available at http://aka.ms/DiskSpd.… Read more
Today I’d like to announce that I have been selected as a PernixPro for 2015! It’s a program similar to VMware’s vExpert, Microsoft’s MVP, and other community awards for those that help spread the word about PernixData. I’m very proud to be a part of this program! Read more
My good friend Ed Leighton-Dick has created a great new challenge, adapted from a challenge issued by Seth Godin back in January. Are you part of the SQL Server landscape and have wanted to get into technical blogging but just haven’t gotten there yet? Now’s your chance! Ed is issuing… Read more
I am pleased to announce a brand new pre-conference training session, entitled “SQL Server Virtualization for VM Admins“, to be launched on Friday, April 10th, the day before the upcoming SQL Saturday event in Madison, Wisconsin. The price is only $100 for the entire day of training! Read more