on 05-24-2019 11:37 AM
Just upgrade from ASE15.7 to ASE 16. Found that Cursor Looping in stored procedures is very slow in ASE 16 than ASE15.7.
Any suggestions?
Not sure if this is your problem or not, but there's a lot more work done in the auditing system in ASE 16 because ASE logs SQL text for every audited event (there's no way to turn this off). So check to see if there are a gazillion auditing entries for the operation inside the cursor loop.
Also, in certain circumstances, auditing operations in a cursor loop can use up procedure cache. So also check to see if your procedure cache is getting used up (sp_monitorconfig "procedure cache")
Good luck
Later edit: Oh, I guess the first thing to check is the query plan of the operation inside the cursor loop. I should've said that first.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.