SQLTeam.com | Weblogs | Forums

Stored Procedure suppressing errors?


#21

Looks like the Avg Wait Time on the HADR_SYNC_COMMIT wait is 15ms... This may not actually be a problem, since the code is executed so often ?

Also, I did confirm that the infrastructure team did configure the AG as Synchronous Commit - ugh...
This may have been a non-issue after all, but thanks guys for chiming in and making me think!


#22

If I was looking at network latency only - then 15ms wouldn't necessarily be a problem. Most applications do very well with even higher latency - but that all depends on how that application works.

For SQL Server - with a synchronous AG I would probably be concerned with 15ms latency. At least concerned enough to review further and determine if it really is an issue. It may not be an issue for your application.