We are pleased to announce a new feature for our Monthly Managed Services customers and Daily Monitoring customers! New feature: Email Notification for Blocking Queries. Picture this scenario: Your SQL Server runs into blocking but you don’t find out until it is too late. Your server eventually gets to the point where it is so backlogged on the blocking that …

New Feature for Stedman Solutions Monthly Services Read more »

Learn how Optimize For Ad-Hoc Workloads can save some space in your plan cache. Transcription: Steve Stedman 0:09Hi, this is Steve Stedman and I’m here to talk about daily checkup or database health quick scan items that we come across occasionally. These are settings that we optimize or configure on the SQL Server in order to help with performance. Usually, …

Optimize For Ad-Hoc Workloads Read more »

Cost threshold for parallelism and the max degree of parallelism ( maxdop ) are 2 important setting for your SQL Server. Find out how to set these and what they should be set to. Transcription: Steve Stedman 0:09Hi, this is Steve Stedman and I’m here to talk about a couple of the daily checkup or database health quick scan items …

SQL Server Parallelism Settings – Video Tip Read more »