by David | Nov 16, 2020 | Best Practices, Cloud, Performance, SQL Server, Tech Video
Have you ever cringed when you received your monthly cloud bill? Does it feel like you’re overpaying for your cloud services, but don’t know how to reduce your monthly cloud spend? In this video, I am revealing the secret to save on cloud costs that vendors...
by David | Oct 21, 2020 | Performance, SQL Server, Tech Video, Technology
I just released a new training video (one of many to be released in the upcoming months) showing you how to set up Windows Perfmon for ongoing 24×7 collection. Recording ongoing performance information is vital to have a running history of the system state in...
by David | May 22, 2020 | Best Practices, Business, Performance, SQL Server, Technology
People want to make things faster. It’s in our nature as IT professionals. What are you tuning for? I’ve been asking that a lot later. I have to sit back and ask some very basic questions to try to see where people’s IT-related pain is at. What is...
by David | Apr 10, 2020 | SQL Server
I recommend leaving the hyper-threaded logical cores enabled in the host BIOS, but not depending on them for performance gains. Hyperthreaded CPU cores, or logical cores, should not be factored into CPU overcommitment rations as if they are full processor cores. Every...
by David | Apr 6, 2020 | SQL Server, Virtualization
Resource pools are used to hierarchically partition available CPU and memory resources, and are available for use at the VMware host cluster layer. To better prioritize certain VMs over others, especially in a highly concurrent VM farm, I recommend leveraging three...
by David | Mar 19, 2020 | Cloud, SQL Server, Technology
I’ve talked for months now about the ability to run SQL Server on the Linux platform. For those of you interested in exploring the benefits of this platform, you’re in luck! Microsoft has pre-built images ready to go on the Azure cloud, running SQL Server...