HP ProLiant DL980 G7 Server - Manual (Page 25)

Table 5 Possible Replica Roles (continued)
Description Role
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
can reduce SQL Server performance under heavy system loads, as each processor cache is
repeatedly reloaded with data. Assigning processors to specific threads can improve performance
under these conditions by eliminating processor reloads and reducing thread migration across
Optimizations Pages 25