API/Server-Side Cursors

• Jared Hunt

  Mr or Mrs. 500

  Points: 527

  More actions

  May 7, 2008 at 12:09 pm

  #182038

  We have a classic ASP web application (third party product) which uses a COM+ component for the middle tier. It primarily executes API cursors against the DB, which I think is only one of many issues.

  So far, I've collected data via PerfMon capturing the following counters;

  1. Cached Cursor Counts = 1560 (average)

  2. Cursor Memory Usage = 1149800 KB(average)

  3. Cursor Requests per sec = 5.2 (average)...max = 25!

  Here's are my problems...

  1. The Active Cursors counter shows 0 (zero).

  2. The sys.dm_exec_cursors DMV returns 0 results. i.e. SELECT * FROM sys.dm_exec_cursors(0)

  It is easy to see the cursor activity within profiler as RPC's. Why would the DMV and Active Cursors Counter not return any data?

  Any help is greatly appreciated. I have not been able to find a clear answer to this online.