Purpose

The purpose of this article is to teach you the process of setting the Polling Interval using Enterprise Manager in Microsoft SQL Server 2000.

Setting up Polling Interval

The polling interval determines how often SQL Server Service Manager checks the state of Microsoft SQL Server, SQL Server Agent, and Microsoft Distributed Transaction Coordinator (MS DTC).

Following steps describe you the process of setting Polling Interval:

1. Click Start, go to Programs, then go to Microsoft SQL Server and click Enterprise Manager.

2. Click Tools in menu bar, then click Options.

3. Select the Poll server to find out state of server and related services checkbox, and select or type the value in seconds for Poll interval (seconds).

4. Click OK.