Performance Analysis (PA) is unable to provide the object names for the stored procedures that are being executed on a read-intent replica (AlwaysOn with ApplicationIntent=ReadOnly). It says "Unknown Stored Procedure" and grouped ALL stored procedure executions into it. The primary replica looks good.
Does PA support the read-intent replica option in SQL Server 2012 AlwaysOn feature?
PA supports the read-intent replica option since version 7.0.448. Please upgrade to that version.
If there are still problems getting TSQL Batches data please follow the steps below:
Note:
The previously captured "Unknown Stored Procedure" items will not change in history. Only for the future time period, after implementing the above solution, the TSQL batches names will be seen correctly.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center