Last week, I wrote about what should have been a fast system but was performing very poorly, weighing heavily on tempdb I/O performance. Our original… Read More »The ongoing saga of a slow tempdb on a fast server
During a recent engagement, the customer explained that the performance on their relatively small system was especially slow on Monday morning, but generally bad that… Read More »98% of I/O is taken up by tempdb
When we perform diagnostics on an existing SQL Server instance, or if we are setting up a new machine, it’s very important to make sure… Read More »Max Server Memory Matrix
Microsoft Azure and Amazon Web Services are taking over. Last week, a client approached me to migrate their complex environment in two phases from two… Read More »Forecast: Azure Skies Over the Amazon
I received some good feedback on my talk this Wednesday for the Calgary PASS Chapter. This has led me to consider transposing the content from… Read More »The SQL Server Performance Starter Kit
I make a lot of assumptions in my day-to-day life, as well as in my job as an IT consultant. To mitigate the inherent arrogance… Read More »Are You Sure?
The local SQL PASS chapter in Calgary is hosting yours truly as the speaker for this month. I only have an hour, which I will… Read More »I’m speaking tomorrow
As the title says, I’ll be speaking at the Calgary SQL PASS User Group on 19 August 2015. My topic is SQL Server Performance Tuning… Read More »Speaking at Calgary SQL PASS User Group on 19 August 2015
Your production environment needs Date and Number tables, to help you Get Stuff Done in sets instead of RBAR*. Doug Lane has a video on… Read More »Do it now: Date and Number tables
A customer is running in a SQL Server 2000 environment, 32-bit AWE mode, on 64-bit Windows 2003 R2. The server has 16GB of RAM and… Read More »The curious case of RESOURCE_SEMAPHORE