Hello, I manage an ERP on MSSQL 2008 R2 that uses cursors for almost everything ..
I am analyzing changing the value of the Cursor Threshold option, from -1 to some value N, but I am not sure how to analyze which is the best value.
I understand that if I assign 100, for any query that its recordset is less than 100, it runs synchronously, otherwise asynchronously, but I don't know how to do a metric to see if there is a real improvement.
I started by looking at the performance counters, like

But there is no "how much is the average amount of recordset" metric to use as a metric.
Do you know any documentation that helps me to define some metric to be able to measure the improvement when modifying the Cursor Threshold value?
Thank you for reading this far!!!