Availability Group (AG)

Technical Article

Monitoring Availability Group Replica Synchronization

  • Article

If you are deploying SQL Server Availability Groups, one of the important aspects of a successful deployment is monitoring the synchronization of the secondary replica databases with the primary replica - but there are multiple ways to do this. Jonathan Kehayias goes through each, explaining their different benefits and drawbacks.

You rated this post out of 5. Change rating

2015-09-17

2,771 reads

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.

You rated this post out of 5. Change rating

2013-07-23

3,177 reads

Blogs

TRY_PARSE Limitations: #SQLNewBlogger

By

I got a notification from a question I’d posted at SQL Server Central: Getting...

SQL Server sa Account Security: Rename, Disable & Best Practices

By

SQL Server sa Account Security: Rename, Disable & Best Practices In...

Stanford Emerging Technology Review 2026 Report is out

By

Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...

Read the latest Blogs

Forums

Are You Working More Hours?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Are You Working More Hours?

Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time

By Massimo Preitano

Comments posted to this topic are about the item Stairway to Reliable Database Deployments...

A Limited Startup

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Limited Startup

Visit the forum

Question of the Day

A Limited Startup

I add this parameter to SQL Server 2025 in the Configuration Manager:

-mDynamics
What does this do?

See possible answers