Best way to monitor high worker thread on SQL Server
It is common to see high worker count issue on the production server and it can have a range of negative impacts on SQL Server performance and stability, potentially...
2023-03-31
72 reads
It is common to see high worker count issue on the production server and it can have a range of negative impacts on SQL Server performance and stability, potentially...
2023-03-31
72 reads
This question has come up many times how to capture the SQL Server Database Recovery Progress or Total time take to recover a database. It will help to plan...
2019-05-16 (first published: 2019-05-04)
445 reads
An interesting issue regarding SQL Server Transaction Replication/CDC log reader agent job can’t be started with the following error:
Msg 18752, Level...
2018-09-19 (first published: 2018-09-10)
7,953 reads
I was playing with SQL Azure on my brand new Surface pro device. I open the Windows Powershell ISE as administrator to...
2018-09-19
1,104 reads
As the business requirement, It is very common to see a request for adding a new article or subscription to...
2018-08-22 (first published: 2018-08-06)
1,885 reads
When you are working on the AlwaysOn feature, it is crucial to understand how the AlwaysOn commit process works. This...
2018-08-15
5,007 reads
With SQL Server 2016, Microsoft is installing SQL Server Telemetry or CEIP (Customer Experience Improvement Program) Services by default. It...
2018-08-13 (first published: 2018-07-30)
39,870 reads
There are many times you as DBA or Developer needs to get all row count from all tables or row...
2018-08-13
6,199 reads
In the SQL Server AlwaysOn setup, whenever you are using a listener to connect to a secondary node, you have...
2018-08-10 (first published: 2018-07-26)
2,537 reads
In this blog, I am NOT going to discuss the SQL Server licensing model. If you are looking for that...
2018-08-03
2,444 reads
By SQLPals
While I always configure transaction log backups for every database in non-simple recovery model,...
By Steve Jones
There’s a video of Bill Gates taking a drive in an autonomous car around...
It is common to see high worker count issue on the production server and...
I have a stored procedure that was created to run dynamically. Other than me...
I have the following historical wait report for my SQL server. I have noticed...