Posts
Sort by recent activity
Querying/Reporting from SQL Response
I'd like to be able to make the performance of our SQL Servers more transparent to my bosses. In particular, I'd like to be able to report on worst queries for blocking, most common deadlock situat...
Log Shipping - Cleaning up Restored Files
I've done a fair bit of searching the forums etc., so forgive me if this has been answered elsewhere:
I'm running the below code to restore the t-logs:DECLARE @errorcode INT
DECLARE @sqlerrorcode I...
Collecting Trace Data
I have enabled the collection of trace data on both servers which are being monitored. However, I am yet to see any trace data appear in the performance snapshot for any alert. I have checked deadl...