Hi guys, I'm working on improving performance in a billing database and am trying to find out if all cursors that are open eventually get closed and de-allocated.
The one of the processes that i'm working to improve loops on 90000-ish records.. which then loops on data usually using cursors from other tables for each of the 90000 records.
My question is how can i detect if my cursors are being closed and de-allocated? this database has about 1300 stored procs (somewhere around 200000 lines of SQL code) so its not like is easy to read through the code to make sure they all get closed
Thanks for any help in advance.
[Edit] - we are running Microsoft SOL Server 2005 FYI.
Social Networking Bookmarks