Answer by Joseph H. ·
Cursors point to records in the database so if you see lots of cursors being consumed, i'm guessing you're getting lots of rows back from the query execution. This might relate to the long running query, in that more work is required for broader searches. Take a look at the query string, is there lots of select statements without 'where' clauses to limit the amount of data coming back?
Set Up Demo Environment Using Pcap File 2 Answers
Using of SUID 2 Answers
TCP Sessions with Missing Packets 3 Answers