Kbase 20820: MSS SQL Server Dataserver: Cursor Preservation
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
GOAL:
What functionality changes were made with Preserved Cursors in patch releases for Progress 9.1B and Progress 9.1C
GOAL:
What is preserved cursor?
GOAL:
What are the default switches for preserved cursors for Progress 9.1B and 9.1C?
FACT(s) (Environment):
MS SQL DataServer
Progres 9.1B
Progress 9.1C
FIX:
PROGRESS 9.1B09:
A new implementation was put in place for the MS SQL Server DataServer
Progress 9.1B09 patch: preserved cursors.
The feature allows server side cursors in Microsoft SQL Server to be preserved beyond a transaction boundary. Under many circumstances, preserved cursors can result in a significant performance improvement. However, in some instances, degradation has also been experienced as the result of this setting
This feature is turned ON, by default. User may need to turn it off using connection parameter: -Dsrv MSS_PRESERVE_CURS,0, thus turning on and off Preserve Cursors enables user to determine if a problem was introduced by the new switch or not.
PROGRESS 9.1B19:
In patch 9.1B19, the Preserved Cursor switched, is turned OFF, by default. The reason for this is because of problems against cursor preservation code that affected the DataServer stability. User should not tun on this option within Progress DataServer 9.1B.
PROGRESS 9.1C:
In this version, the Preserved Cursor switch is turned OFF, by default. Although this option can be turned ON as Progress 9.1C is more stable than it's predecessor. User should do benchmarking tests to verify DataServer stability with this switch.