LinkedIn | FaceBook | Twitter
At the server-level, I explained a lot of these kinds of reports. This report has much of the same information on transactions, but it is scoped to a single database. I often use the server reports to locate any issues, and if I find some I use this report (and the ones that follow) to narrow the search.
Here are the major parts of the report. The first band shows the Top Oldest Transactions, and the bands that follow have the same information but in other chronological arrangements:
In this continuing series on the Standard Reports in SQL Server Management Studio , we’re now up to the