Recently I published a blog about new DMV in SQL Server 2017 called dm_os_enumerate_fixed_drives. While doing that I found another new DMF (Dynamic Management Function) sys.dm_os_file_exists.
SQL SERVER – Msg 3013 – Cannot Create Worker Thread. BACKUP LOG is Terminating Abnormally
One of my clients sent email to know my quick suggestion on one of the error messages. Let us learn how to fix error related to worker thread.
Cannot create worker thread.
BACKUP LOG is terminating abnormally.
SQL SERVER – Msg 0, Level 11 – A Severe Error Occurred on the Current Command. The results, if Any, Should be Discarded
It’s always fun to fix something when there is no meaningful error message. As you can see in the blog title, message id = 0 and it doesn’t tell me how to fix the issue. Here is my checklist whenever someone reports below severe error:
SQL Authority News – 11 Years of Daily Blogging – 4200+ Blog Posts
Today, I complete 11 years of daily blogging on SQL Authority. I have so far blogged 4200 blog posts on this blog. 11 years have about 4015 days and it seems that I have written over 1 blog posts every single day.
SQL SERVER – SQL Express Installation Error – Wait on the Database Engine Recovery Handle Failed
Sometimes I get emails from software vendors who use SQL Server as a part of their product. One of such vendor contacted me for an issue where their software install was failing because SQL Express was not getting installed. It was failing with an error. The error message which they shared was “Wait on the Database Engine recovery handle failed”.
SQL SERVER – Adding New Database to AlwaysOn Replica is Slow
First, let me clarify, the words in the subject of this blog are the exact words used by my client and whatever you do and say but “customer is always right!”. Here is the complete story where we faced issue related to AlwaysOn Replica.
SQL SERVER – How to Auto Start SQL Followed by a Crash?
Sometimes I do get some quick questions from my existing clients. I try to help them as much as possible. Most of the time, I provide them link to my blog or someone else’s blog. If there is no relevant information based on my search, then I provide them relevant information and write a blog for future reference. This blog is an outcome of one such email communication. Here is the short question about auto start SQL.
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.