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 …

PREEMPTIVE_OS_GETPROCADDRESS and xp_create_subdir Read more »

The Quick Scan report in Database Health Monitor detects when you are performing SQL Server backups without compression, when the compression option is available. This applies to Full backups, Transaction log backups and Differential backups. Not using compressed backups? Why not? …

Using SQL Server Compressed Backups Read more »

Over the last year, I have published many videos to YouTube with Free SQL Server Training. You can find these on my YouTube Channel at the following link: https://www.youtube.com/steveStedman   Most of the focus has been around training people for …

Free SQL Server Training Videos Read more »

Max Server Memory Setting Explained If you have more memory than your database and applications on the SQL Server will ever use than this is not a problem, but when you run into memory constraints this setting is much more …

Max Server Memory – SQL Server Read more »

In SQL Server there is a special connection that can be used to connect to the database, the remote Dedicated Admin Connection or (DAC). This is a special connection that allows the administrator to connect to the SQL Server even …

SQL Server – Dedicated Admin Connection (remote DAC) Read more »

I have just released version 2.1 of Database Health Monitor, this release involved 2 months of development since version 2.0 was released in July. People often times ask me if this is free, or free to use in production, or …

Database Health Monitor version 2.1 Just Released Read more »

This Saturday, September 12th, 2015 I will be presenting at SQL Saturday Las Vegas. My presentation is on Database Corruption, here are the details. When Database Corruption Strikes – Will you be ready? Duration: 60 minutes Track: Enterprise Database Administration …

Presenting at SQL Saturday Las Vegas Read more »