HP AiO400r HP StorageWorks All-in-One Storage System User Guide (440583-006, J - Page 109

Value, Property, Warning Threshold tab, Data File or Log tab, Data File tab, Description

Page 109 highlights

Property Value 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 21 on page 77 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 79 for more information. Application Server Volume - RAID The RAID stripe size to which the database component's storage is Stripe Size configured. See Table 21 on page 77 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 21 on page 77 for more information. Application Server Volume - Mount Paths Path the volume is mounted on, on the server that hosts SQL Server. The volume is built on the iSCSI LUN exported by ASM to the server that hosts SQL Server. • Warning Threshold tab-(SQL Server database component) Allows you to change the percent full warning threshold value for the database component. See Setting a percent full warning threshold on page 80 for more information. • Data File or Log tab- (SQL Server database component) One of these two tabs is available depending on whether the database component is a data file or log. • Data File tab-Displays the data file's free space and the following storage allocation details about the SQL Server data file: Table 34 Data File tab: SQL Server database component properties Value Data File Name Filename File Group Data File Space Available Description Name of database data file. Relative path to where the database data file is stored on the server that hosts SQL Server. File group of data file. This value is assigned by SQL Server. Free storage space available for data file. HP StorageWorks All-in-One Storage System 109

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188
  • 189
  • 190
  • 191
  • 192
  • 193
  • 194
  • 195
  • 196
  • 197
  • 198
  • 199
  • 200
  • 201
  • 202
  • 203
  • 204
  • 205
  • 206
  • 207
  • 208
  • 209
  • 210
  • 211
  • 212
  • 213
  • 214
  • 215
  • 216

Value
Property
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 - Name
Status of the volume on the server that hosts SQL Server where the
database component is stored.
Application Server Volume - Status
Indicates if database component storage is configured with exclusive
storage. See
Table 21
on page 77 for more information.
Application Server Volume -
Exclusive Storage
The RAID level to which the database component storage is configured.
See
Customizing RAID levels
on page 79 for more information.
Application Server Volume - RAID
Level
The RAID stripe size to which the database component's storage is
configured. See
Table 21
on page 77 for more information.
Application Server Volume - RAID
Stripe Size
Speeds up reads when enabled. This setting is determined by the storage
array, not ASM.
Application Server Volume - Read
Cache
Speeds up writes when enabled. This setting is determined by the storage
array, not ASM.
Application Server Volume - Write
Cache
The number of hot spares with which the database component storage is
configured. See
Table 21
on page 77 for more information.
Application Server Volume -
Number of Hot Spares
Path the volume is mounted on, on the server that hosts SQL Server. The
volume is built on the iSCSI LUN exported by ASM to the server that hosts
SQL Server.
Application Server Volume - Mount
Paths
Warning Threshold tab
—(SQL Server database component) Allows you to change the percent full
warning threshold value for the database component. See
Setting a percent full warning threshold
on page 80 for more information.
Data File or Log tab
— (SQL Server database component) One of these two tabs is available
depending on whether the database component is a data file or log.
Data File tab
—Displays the data file's free space and the following storage allocation details about
the SQL Server data file:
Table 34 Data File tab: SQL Server database component properties
Description
Value
Name of database data file.
Data File Name
Relative path to where the database data file is stored on the server
that hosts SQL Server.
Filename
File group of data file. This value is assigned by SQL Server.
File Group
Free storage space available for data file.
Data File Space Available
HP StorageWorks All-in-One Storage System
109