Only official documentation which I could find was about wait statistics related to Parallel Backup Queue is very little available online.
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.
Do Queries Always Respect Cost Threshold of Parallelism? – Interview Question of the Week #216
Question: Do Queries Always Respect Cost Threshold of Parallelism?
SQL SERVER – FIX: 3637 – A Parallel Operation Cannot be Started From a DAC Connection
This was indeed one of an interesting error which I have never seen earlier and it is about DAC Connection.Â
Here is the complete error message which my client reported.
SQL SERVER – Update Table Statistics in Parallel with FULLSCAN
SQL Server Performance Tuning is a much simpler job if you know exactly where to look for and how to tune the configurations. Here is the real world scenario which I encountered during the recent Comprehensive Database Performance Health Check. During the performance tuning exercise, we realized that for one of the table we needed to update the statistics with the full scan as the table was a very critical table for their business. However, every time whenever we were running the update statistics job, the query was running very slow and almost never finish.
SQL SERVER – New Parallel Operation Cannot be Started Due to Too Many Parallel Operations Executing at this Time
One of my clients contacted me via my On Demand (50 Minutes) offering and they were seeing below error message in ERRORLOG – New parallel operation cannot be started due to too many parallel operations executing at this time.
Does Parallel Threads Process Equal Rows? – Interview Question of the Week #211
Question: Does Parallel Threads Process Equal Rows?