Configure The Cursor Threshold Option In SQL Server 2008

Posted in SQL | Cursor February 20, 2020
Tags: Cursor Threshold Option, SQL Server, Configure Cursor Threshold, Cursor in SQL
In this article I will demonstrate how to configure the threshold option using SQL Server Management Studio.
  • 3102

In this article I will demonstrate how to configure the threshold option using SQL Server Management Studio. According to Microsoft, Cursor threshold option is used to specify the number of rows in the cursor set at which cursor keysets asynchronously. When keyset is generated by cursor, query optimizer specifies the number of rows returned for that result set.

To configure cursor threshold option:

Step 1

Open SSMS, connect to database engine and open Object Explorer.

Step 2

In Object Explorer, right click on a server and select Properties.

PropertiesOfServer.jpg

Step 3

Server Properties will open on selecting Properties of Server.

PropertiesOfServer1.jpg

Step 4

Click Advanced.

PropertiesOfServer2.jpg

Step 5

Expand Miscellaneous. Under Miscellaneous, enter the desired value in Cursor Threshold option. Click Ok.

PropertiesOfServer3.jpg

Note: If value cursor threshold is set to -1, it denotes that all keysets will generate synchronously and 0 denotes that all kesets will generate asynchronously.

    © 2020 DotNetHeaven. All rights reserved.