Why You Need Baselines

Regularly when working with clients, I implement a basic baseline package to collect key metrics. At a minimum I like to capture CPU utilization, page life expectancy, disk I/O, wait statistics, and a database inventory. This allows me to track and trend what normal CPU utilization looks like, as well as to see if they […]

SSMS 17.6 is available

If you are using Azure SQL Database Managed Instance, you may want to consider installing the latest SQL Server Management Studio. There are bug fixes for Always On, Setup, Object Explorer, Data Classification (important for GDPR), SMO, and Database Mail. Read the official release here or jump right to the download page here.

Microsoft Database Experimentation Assistant with SQL Server 2017

If you’ve tried using the Microsoft Database Experimentation Assistant (DEA) with SQL Server 2017 prior to CU1 to replay a trace, then you’ve likely encountered an error like the one below telling you that the Preprocessed IRF path is empty or contains invalid files. The great news is that after applying CU1, this has been […]