Grey DeLisle- Xandra, DMV Voice Wayne Knight- Baron Von Sheldgoose, Sheldgoose Ancestors Jessica DiCicco- April, May, June Jim Cummings- Captain Charon, Dead Guy Dee Bradley Baker- Leopold the Horrible, Tengu, Ari the Aracuan Bird Kevin Michael Richardson- Lord Felldrake, Devil Donald, Border...
DMV to display health of both AG and Distributed AG The below query displays a wealth of information about the health of both the availability group, and the distributed availability group. (Reproduced with permission from Tracy Boggiano.) SQL Copy -- displays sync status, send rate, and redo...
The SQL query editor in the Azure portal SQL Server Management Studio (SSMS) Azure Data StudioPermissionsIn Azure SQL Database, depending on the compute size, deployment option, and the data in the DMV, querying a DMV may require either VIEW DATABASE STATE, or VIEW SERVER PERFORMANCE STATE,...
Additionally, you can query the DMV sys.dm_exec_request on the secondary replica to find out which session is blocking the REDO thread, and then you can take corrective action. The following query returns the session ID of the reporting workload that is blocking the redo...