Cursor downgrades

DataServer for Microsoft SQL Server

Additional Features to Enhance DataServer Performance : Connection pooling : Monitoring cursor and connection use : Cursor downgrades

Cursor downgrades

Cursor downgrades are monitored by the DataServer, according to the type of cursors in use:

For firehose cursors, the DataServer counts the number of times a cursor is downgraded, and writes the count to the log file at the end of the session.

Consider increasing the number of DataServer managed connections if firehose cursors are frequently downgraded.

For downgrades of Fast Forward-Only cursors, a message is written to the log file when the downgrade occurs.