Share via

Database Replica object are only valid for secondary?

Alen Cappelletti 1,047 Reputation points
2022-02-11T11:44:07.463+00:00

Hi I'm analyzing metric on this page

https://learn.microsoft.com/en-us/sql/relational-databases/performance-monitor/sql-server-database-replica?view=sql-server-ver15
and in the abstract I read "...This object is valid only on an instance of SQL Server that hosts a secondary replica."

Is it true this? 'Cause I see on the header "View on..." and there is "Primary replica" also.

For example, I understood that the last one metric "Transaction Delay" is related to primary...
"Total delay in waiting for unterminated commit acknowledgment for all the current transactions, in milliseconds"

I interpret the last column as the reference to read the data where it is specified.
Can you clarify me?
Thank you

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.