beautypg.com

Clustered sql server instance – HP ProLiant DL980 G7 Server User Manual

Page 26

background image

Table 5 Possible Replica Roles

Description

Role

The Role is Resolving.

Resolving

The Role is Primary.

Primary

The Role is Secondary.

Secondary

The Role is Unknown.

Unknown

Clustered SQL Server Instance

If a SQL server is clustered, additional parameters will be displayed for Cluster Network Name,
Cluster Status and Computer Role, as shown in the figure below.

Figure 26 Clustered Database

Table 6 Possible Cluster Status Values

Description

Value

The instance of SQL Server is in an unknown state.

Unknown

The instance of SQL Server is online.

Online

The instance of SQL Server is waiting to come online.

OnlinePending

The instance of SQL Server is offline.

Offline

The instance of SQL Server is waiting to go offline.

OfflinePending

Table 7 Possible Computer Roles

Description

Role

The Role is unknown.

Unknown

There is no Role applicable in the current setup.

Not Applicable

The Role is primary.

Primary

The Role is secondary.

Secondary

CPU

The CPU page displays SQL Server and IO affinity settings and recommendations for each SQL
instance in the system. To carry out multitasking, Microsoft Windows sometimes moves process
threads among different processors. Although this is efficient from an OS point of view, this activity

26

Using HP ESO