Availability Group (AG)

Technical Article

Are my actual worker threads exceeding the sp_configure 'max worker threads' value?

  • Article

Tom Stringer (@SQLife) was working on some HADR testing for a customer to simulate many availability groups and introduce significant load into the system to measure overhead and such. In his quest to do that he was seeing behavior that he couldn’t really explain and so worked with him to uncover what was happening under the covers.


3,177 reads


Daily Coping 18 Aug 2022


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

New parameter in sp_DBPermissions and sp_SrvPermissions: @CopyTo


I’ve added a new parameter to my permissions scripts (well, just the main two...

Creating TAIL on Windows for Text Files


UPDATE: Article changed based on the comment from Mr. Sewell. I wrote recently about...

Read the latest Blogs


How to use PowerShell to set secure SA passwords for bulk servers

By Vincent92

Comments posted to this topic are about the item How to use PowerShell to...

INSERT EXEC statement cannot be nested, the Simple Solution

By Daniel Brink

Comments posted to this topic are about the item INSERT EXEC statement cannot be...

Cleaning Tables

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Cleaning Tables

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers