vasoov
Active Member
Good day folks,
Has anyone out there set their SQL server to use asynchronous cursors via the sp_configure command? Are there noticeable improvements in reponse times? My production database is 80GB in size and growing. Occasionaly the users report screen freeze problems, so I am wondering whether this could be due to the server needing to entirely populate the cursor before returning data to the client.
Has anyone out there set their SQL server to use asynchronous cursors via the sp_configure command? Are there noticeable improvements in reponse times? My production database is 80GB in size and growing. Occasionaly the users report screen freeze problems, so I am wondering whether this could be due to the server needing to entirely populate the cursor before returning data to the client.