Michael Swart notes that cursor performance can be hidden from monitoring tools:
The
OPENstatement is missing fromsys.dm_exec_query_stats. I want to demonstrate that.
There are a few workarounds, and Michael even provides us a handy table, so read the whole thing.