LinkedIn | FaceBook | Twitter
One thing that I haven't mentioned yet is that you can export your reports, either to Acrobat (PDF) or Excel Spreadsheet format. Just right-click anywhere in your report and select "Export" from the menu. I use the Excel versions more often than PDF, because I usually want to do something with the reports once I create them.
In these two reports we're talking about Cursors, which is a looping construct used in the SQL language. Many people see cursors as especially bad, but I think they have their place, if used correctly. The problem is that they aren't always used correctly, so one of things both DBA's and developers spend time on is finding long-running cursors, hence these two reports. Although the columns this report generates are pretty self-explanatory, these reports are very useful - funny how that works out. Simple is good.
Activity - All Cursors
This report shows the activity of all active cursors. You'll get information on which cursors are running, and a list of the CPU time and IO reads and writes. You can use these to track down your longest cursors as the system runs, and then re-factor them to be more efficient. This is another "stacked" report, with the Session ID and user name as the outer “band” in the table which contains the two others. This lets you view the cursors by transaction, by user. You also get part (but not all) of the SQL Statement in the cursor. More importantly, you get the name of each cursor the ID/user is running. Here are the columns:
The values in the Properties field describe the cursor from a system perspective. The values are concatenated with lines between them, and the values themselves represent the following:
Declaration Interface | Cursor Type | Cursor Concurrency | Cursor scope | Cursor nesting level | Creation Time
For the actual values themselves, check about midway down on this page.
Activity - Top Cursors
This report has the same columns and information as the "All Cursors" report, with the exception that the Session ID's and user information are on the same line, with the other information below that.
The only issue is that if you have only one cursor, it fits all these categories!
You get the following reports:
Top 10 Oldest Cursors - The oldest cursor the system has recently run.
Top 10 Dormant Cursors - The cursors that are currently not responding or doing any work.
Top 10 IO Intensive Cursors - The cursors that are taking the most IO (storage) resources.
Top 10 CPU Intensive Cursors - The cursors that are taking the most CPU resources.
PingBack from http://www.soundpages.net/computers/?p=4039
I've completed documenting all of the Standard Reports in SQL Server Management Studio. You can get to