sp_readrequest kept showing up as a long running procedure. It is Database Mail waiting on its queue with a 600 second timeout, usually nothing to worry about.
How to Find How Many Rows Each Query Returned Along with Execution Plan? – Interview Question of the Week #115
Want to see How Many Rows Each Query Returned along with its execution plan? Here is a query for it, and why reads and worker time matter more.
How to Get Status of Running Backup and Restore in SQL Server? – Interview Question of the Week #113
How do you check the status of running backup and restore operations? Here is the script I built to see every backup and restore running on the server.
SQL SERVER – How to Apply Patch in AlwaysOn Availability Group Configuration?
A Patch in AlwaysOn Availability Group needs a sequence matched to the topology. I start this two-replica example with the secondary.







