It's useful when doing some things using EXECUTE AS, reverting etc and you want to check which user context is in place at what point in the process.

Sue

I think you maybe one version away from being able to set something up. What versions are supported depends on some other information such as the distributor and the type...

Thanks for the update and please do post back. I'm sure I'm not the only one curious about this issue so any updates would be great.

Sue

If nothing shows in the database_mirroring DMV, you should be fine but may want to consider disabling the endpoint for awhile before deleting.

Sue

Seconds. Standard time formatting in SQL Server would be - Hours:Minutes:Seconds.FractionalSeconds

Sue

You may want to take a look at dbatools - there is a Copy-DbaSsisCatalog cmdlet that might work for you. There is a decent amount of granularity if you read...

If you already checked everything including the network trace and found nothing I don't have anything to add other than I would wonder if it's random. Your post indicates it...

Statistics updated on the primary will be sent to the secondaries. There is a bug on 2016 with updating stats with fullscan so you would want to make sure you...

You may need to start checking for issues with the NICs. Make sure the firmware is current and doesn't have known issues with iSCSI (Broadcom for whatever reason seems to...

If the secondary is unavailable for an hour, the primary would switch to asynchronous commit. There is a session timeout period that defaults to 10 seconds. If that is exceeded,...

When you are viewing the Execution plan, you can right click on the execution plan window, select Save Execution Plan As...and save it as an sqlplan file. Others can open...

They are stored in the ReportServer database so if you move the database, you have moved those reports.

Sue

The default trace and the Schema Change report would show index drops, creations. The report captures what is in the traces so the two are basically the same. Those would...

You may want to start by checking the cluster log as well as the Windows event logs at the times the issue hits.

Sue

It depends on if you are looking for the information like AWR or just looking for query plans. You can get information similar to AWR by enabling the Data Collector...