Category: Performance Tuning

Presenting this Friday at the CHUG Conference

This Friday, October 14th I will be presenting at the Centricity Healthcare Users Group (CHUG) conference in Austin TX. The session is on “Tune, Monitor and Analyze the Health of Your Centricity SQL Server” and I will be co-presenting with

Posted in CHUG, Performance Tuning Tagged with: , ,

Instant File Initialization (IFI)

One way to improve performance on SQL Server is with IFI or Instant File Initialization. Normally files are zeroed out on a database growth during an AUTOGROW, RESTORE, CREATE DATABASE or ALTER DATABASE. This is done by SQL Server when

Posted in Performance, Performance Tuning Tagged with: , , , , , , ,

How Many VLFs is Too Many?

Here is an error that popped up in the SQL Server error log today: 5/6/2016 10:10:10 AM spid22s Database [DatabaseName] has more than 10000 virtual log files which is excessive. Too many virtual log files can cause long startup and backup

Posted in Performance Tuning Tagged with:

Updating SQL Server Statistics

Updating SQL Server statistics may not be as obvious as it may sound. Imagine this scenario. I invite you over for dinner and a game of Scrabble. After dinner, I start to do the dishes, while you set up the

Posted in Performance Tuning Tagged with: , , , , , , ,

GE Centricity EMR Performance Tuning.

I have been doing work with multiple clients using the GE Centricity EMR product which makes extensive use of Microsoft SQL Server. The performance issues that you run into with Centricity are very similar to what I see working with

Posted in Performance Tuning Tagged with: , , , , ,


Here is a discovery that I made using the Database Health Monitor historic wait monitoring, on a server with slow storage where the backups were being written. If you are seeing excessive waits on the PREEMPTIVE_OS_GETPROCADDRESS wait type and xp_create_subdir is

Posted in Performance, Performance Tuning Tagged with: ,

What is a Page Split

Tables, and indexes are organized in SQL Server into 8K chunks called pages. If you have rows that are 100 bytes each, you can fit about 80 of those rows into a given page. If you update one of those

Posted in Performance, Performance Tuning Tagged with: , , , , , , ,

Error Log: I/O is Frozen On Database

I/O is Frozen on Database. You are scanning your SQL Server Logs and discover the following error messages. There may be a long list of them, one frozen and one resumed for each database on your SQL Server. I/O Is Frozen

Posted in Performance, Performance Tuning Tagged with:

Steps to Improve ETL Performance Using SSIS

Some of the biggest performance tuning wins that I have had over my career have been related to performance tuning queries that are being called from SSIS. So often the actual query performance gets overlooked in the SSIS environment. A

Posted in Performance Tuning, SSIS Performance Tagged with: , ,

Statistics IO for Performance Tuning in SSMS

Statistics IO and Statistics Time is another SQL Server Performance Tuning Tip to help you better understand performance bottlenecks. Have you ever wanted to know exactly how long it took for a query to run? Have you ever wondered how many

Posted in Performance, Performance Tuning Tagged with: , , ,