HP AiO400t HP StorageWorks All-in-One Storage System User Guide (440583-005, F - Page 100
Table 29 Operating status: SQL Server properties
View all HP AiO400t manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 100 highlights
• General tab-(SQL Server, SQL Server database, SQL Server database component) Displays the name of the application, the total capacity reserved for the application, and its operating status: Table 29 Operating status: SQL Server properties Status indicator Value OK Warning Critical SQL Server is running and storage is online. No alerts. See the Alerts list for more information. See Table 45 on page 113 for alert descriptions. See the Alerts list for more information. See Table 45 on page 113 for alert descriptions. • Storage tab-(SQL Server database component) Displays the database component's storage space, including allocated space, used space, free space, and the following storage allocation details: Table 30 Storage tab: SQL Server database component properties Property Value Application Path Path to the file directory on the server that hosts SQL Server where the database component's data is saved by SQL Server. The file directory is located on the volume created on the iSCSI LUN exported by ASM to the server that hosts SQL Server. Protocol Communication protocol used to transfer data between the server that hosts SQL Server (and the database component) and your HP All-in-One Storage System. Application Server Host Name Name of server that hosts SQL Server and the database component. Application Server Volume - Name Name of the volume on the server that hosts SQL Server to which SQL Server saves the database component's data. The volume resides on the iSCSI LUN (logical disk) exported by ASM to the server that hosts SQL Server. Application Server Volume - Status Status of the volume on the server that hosts SQL Server where the database component is stored. Application Server Volume Exclusive Storage Indicates if database component storage is configured with exclusive storage. See Table 19 on page 72 for more information. Application Server Volume - RAID The RAID level to which the database component storage is configured. Level See Customizing RAID levels on page 73 for more information. Application Server Volume - RAID The RAID stripe size to which the database component's storage is Stripe Size configured. See Table 19 on page 72 for more information. Application Server Volume - Read Speeds up reads when enabled. This setting is determined by the storage Cache array, not ASM. Application Server Volume - Write Speeds up writes when enabled. This setting is determined by the storage Cache array, not ASM. Application Server Volume Number of Hot Spares The number of hot spares with which the database component storage is configured. See Table 19 on page 72 for more information. 100 Monitoring storage