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

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