Today I begin a week-long series where I will be discussing various SQL Server Monitoring Tools. My primary job is to help people with my consulting workshop Comprehensive Database Performance Health Check. While I help the customer with their various SQL Server performance issues, I often see my customers struggle with the monitoring their SQL Server’s health. One of the primary discussion at the end of consultation which we do is what tool is the best for their environment and how it can prevent them to walk into another trouble. Today we will talk about SQL Diagnostic Manager (SQLDM)Â in brief.
SQL Server Monitoring Week – Database Performance Analyzer
Today I begin a week-long series where I will be discussing various SQL Server Monitoring Tools. My primary job is to help people with my consulting workshop Comprehensive Database Performance Health Check. While I help the customer with their various SQL Server performance issues, I often see my customers struggle with the monitoring their SQL Server’s health. One of the primary discussion at the end of consultation which we do is what tool is the best for their environment and how it can prevent them to walk into another trouble. Today we will talk about Database Performance Analyzer (DPA) in brief.
How to check the ANSI Compatibility of SQL Server Queries? – Interview Question of the Week #221
Question: How to check the ANSI Compatibility of SQL Server queries?
SQL SERVER – Docker Volume and Persistent Storage
I have received some rave reviews of my article on SQL SERVER – How to Get Started with Docker Containers with Latest SQL Server?. It was amazing to hear that people really get started after reading my article on docker. One of the most popular questions I keep on receiving was what happens when we have to patch or upgrade SQL Server. Well, that is a fantastic question. In today’s blog, I will explain to you how we can get Docker Volume and Persistent Storage.
SQL SERVER – Audit Script to Get CPU and Memory Information with MAXDOP Guidelines
If you are reading this blog regularly the name of Dominic Wirth may not be new for you. He has in the past sent some very interesting scripts for audit for our blog and I am including his new script in this blog which is about how to Get CPU and Memory Information with MAXDOP Guidelines.
Logistics: SQL Server Performance Tuning Practical Workshop for EVERYONE – April 23, 2019
There has been lots of buzz about the very first online class SQL Server Performance Tuning Practical Workshop for EVERYONE which is scheduled on April 23, 2019. Unless you are leaving under a rock, you would know that the class is now 100% sold out and I can’t accommodate any more person. If you are really interested, write an email to me and I will make an exception.
SQL Puzzle – Correct the Incorrect Query – Win Price Worth USD 1000 – Aggregate and Subquery
It has been a while since we have seen a puzzle so let us do a small puzzle today. Actually, this is a very simple puzzle if you have worked with SQL Server for a while. I got an email from one of the readers from the blog post and he wanted me to correct the following query which he had written. Well, I have been working with SQL Server for over 19 years and I often do not remember the syntax and have to look up online. Here is a very simple puzzle for you which involves Aggregate and Subquery.
How to Get FREE Consulting Hours to Tune Your SQL Server Performance?
As you know now there are only six days to my most looked forward SQL Server Performance Tuning Practical Workshop for EVERYONE – April 23, 2019. I have already opened a lot of seats for the class but the demand for the class is constantly increasing. There are two major perks for the signing up the class 1) Free UNLIMITED replay for the class for 30 days and 2) FREE Consulting Hour.
SQL SERVER – Difference Between Azure Data Studio and SQL Server Management Studio
Earlier I blogged about SQL SERVER – Getting Started with Azure Data Studio. After reading the blog post, I receive an email from a reader asking about the primary difference between Azure Data Studio (ADS) and SQL Server Management Studio (SSMS). Well, before we start the conversation let us see the following image.
Does ARITHABORT Setting Negatively Impact SQL Server Performance? – Interview Question of the Week #220
Question: Does ARITHABORT Setting Negatively Impact SQL Server Performance?