Administering SQL Server
Cursors Event Category
Use the Cursors event category to monitor cursor operations. For example, you can determine when a cursor is executed and what type of cursor is used by monitoring the CursorOpen, CursorExecute, and CursorImplicitConversion event classes. Tracing specific event classes can be useful to determine the actual cursor type used for an operation by an instance of Microsoft® SQL Server™, rather than the cursor type specified by the application.
