Answer by Joe 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?
JANUARY 15, 3:00 PM GMT / 10:00 AM ET