In-memory computing is gaining widespread acceptance as a way to speed database performance by moving hot data into main memory. But, in-memory solutions tend to be limited in functionality, lack scalability without… Read more
I am proud to be offering several training opportunities at the upcoming PASS Summit in Seattle, WA during the week of October 26th. PASS Summit is the world’s largest and most attended conference for Microsoft SQL Server and BI professionals. This conference is fantastic, and if you are attending,… Read more
Have you ever wondered if that black box in your datacenter called the network is performing as well as it should be? Do you have random periods of time where normally fast data movement processes seem to take forever, but the diagnostics on your servers all seem fine? What about… Read more
I am very pleased to announce that Argenis Fernandez, (now including) Jimmy May, and I will be presenting a new precon training session at this year’s PASS Summit in Seattle entitled “The Complete Primer to SQL Server Virtualization“. This all-day preconference training session is to be… Read more
A while back, 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… Read more
Next week is the wonderful IT/Dev Connections conference in Las Vegas, and I’m proud to announce that I’m presenting two sessions! The conference is being held at the ARIA Resort and Casino from September 14-17.
If you are one of the lucky ones who gets to attend VMworld USA this year, and you have any number of virtualized databases in your environment, you need to attend these sessions!
Next Wednesday, August 19th, at noon Eastern the PASS Virtualization Virtual Chapter will be holding an open questions and answers session on anything related to SQL Server virtualization, with me as your host! Send over your questions to either Tom Norman (VC lead), or over to me and we’ll get… Read more
Omaha’s next SQL Saturday event is going to be held on August 15th at the University of Nebraska – Omaha’s Mammel Hall at 6708 Pine Street, Omaha NE. The speaker line up is coming soon, and is sure to be fantastic! Make sure to mark your calendars and register… Read more
I am very pleased to announce that Argenis Fernandez and I will be presenting a new precon training session at this year’s PASS Summit in Seattle entitled “The Complete Primer to SQL Server Virtualization“. This all-day preconference training session is to be held on Monday, October 26th,… Read more
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