The MS SQL Device Detail attribute group contains attributes that you can use to monitor the usage and performance of devices.
AutogrowthIndicates whether the autogrowth feature is enabled for a device. If the autogrowth feature is enabled, the maximum file size is displayed as restricted or unrestricted. The following values are valid:
Chapter 4. Attributes reference 145
External value Internal value Description
Not Collected -1 The value could not be collected.
Disabled 0 The autogrowth feature is disabled.
Restricted 1 The growth is restricted.
Unrestricted 2 The growth is unrestricted.
Autogrowth UnitIndicates the unit of file growth. If the autogrowth feature is enabled for a device, the file growth value is displayed either in a percentage or MB. The following values are valid:
External value Internal value Description
Not Collected -1 The value could not be collected.
Not Applicable -2 The value is not supported.
Percentage 1 The file growth is displayed in percentage.
MB 2 The file growth is displayed in MB.
Autogrowth ValueIndicates the growth value of a file. The following values are valid:
External value Internal value Description
Not Collected -1 The value could not be collected.
Not Applicable -2 The value is not supported.
Database NameThe name of the database. The value format is alphanumeric string with a maximum 30 characters; for example, KOQ3. Each database name is unique. The SQL server also assigns each database its own identification number. The following values are also valid:
External value Internal value Description
No Data nodata No data is collected.
Database Name (Unicode)The Database name. Valid values include text strings with a maximum of 384 bytes. The following values are also valid:
External value Internal value Description
No Data nodata No data is collected.
Device Free SpaceThe number of megabytes (MB) of free space on a device. The value format is a decimal with two decimal places allowed; for example, 10.00. Adequate space is required to support database and system administration activities. Set alerts for abnormal conditions. Refer to this value when estimating space needed for tables, indexes, logs, and system administration. The following values are also valid:
External value Internal value Description
Not Collected -1 The value could not be collected.
Device Free Space PercentThe percentage of free space on the device. The value format is a percentage with two decimal places allowed; for example, 15.00. Adequate space is required to support database and system administration activities. Set alerts for abnormal conditions. Refer to this value when estimating space needed for tables, indexes, logs, and system administration. The following values are also valid:
External value Internal value Description
Not Collected -1 The value could not be collected.
Device NameThe name of the device allocated for the database. The value format is an alphanumeric string with a maximum of 64 characters; for example, DATA_1. The logical name of the device is stored in the name column of the sysdevices table. Use the device name in storage-management commands.
Device Name (Unicode)The Device name. Valid values include text strings with a maximum of 384 bytes.
Device SizeThe number of megabytes (MB) on the device. The value format is an integer; for example, 20. Use this value when analyzing the amount of free space. The following values are also valid:
External value Internal value Description
Not Collected -1 The value could not be collected.
Option 1 for calculation :Autogrowth is enabled and has unrestricted growthThis algorithm considers the hard disk drive freespace for calulation
Disk size = Total free space on all hard disk drives that contain the database files Device Size = Disk size + Total database file size
Device Freespace = Device Size - Current allocated space of database file Device Freespace Percent = (Device Freespace / Device Size) X 100
Option 2 for calculation: Autogrowth is enabled and has restricted growthThis algorithm considers the maximum size of the database and hard disk drive free space for calculation.
Device maximum size = The restricted maximum size allocated to the database file Disk size = Total free space on all hard disk drives that contain the database files Condition (a): If device maximum size < Disk size
Device Size = Device maximum size
Device Freespace = Device Size - Current allocated space of database file Device Freespace Percent = (Device Freespace / Device Size) X 100 Condition (b): if Device maximum size > Disk size
Device Size = Disk size
Device Freespace = Device Size - Current allocated space of database file Device Freespace Percent = (Device Freespace /Device Size) X 100
Option 3 for calculation: Autogrowth disabledThe database maximum size is the initial file size of the database at the time of database creation.
Device max size = Initial file size of the database at the time of database creation.
Device Size = Device maximum size
Device Freespace = Device Size - Current allocated space of database file
Chapter 4. Attributes reference 147
Device Freespace Percent = (Device Freespace / Device Size) X 100
Device TypeIndicates the type of device allocated for the database. The following values are also valid:
External value Internal value Description
Log file 1 Indicates that the device stores the
transaction log for the database.
Database file 2 Indicates that the device stores data for the
database.
For future use 3 Indicates that the device supports future
compatibility.
Full text 4 Indicates that the device supports a
full-text catalog.
FILESTREAM 5 Indicates that the device is a FILESTREAM
device.
Not collected -1 The value could not be collected.
The value indicates the type of data that is stored on the device. Databases are frequently spread across several devices due to size, performance, and recoverability issues.
Host NameThe name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in situations or for historical data collection.
Hub TimestampThe time when this data was inserted at the hub. This attribute is not available for use in situations. Otherwise, this attribute is available to use like any other attribute, for example it is available for reports, queries, and workspaces.
Mirror Device NameThe name of the mirror device for the database. The value format is an alphanumeric string with a maximum of 64 characters; for example, /dev/rsd2g. The mirror device duplicates the contents of a primary device. Refer to the logical and physical names of the device that is being mirrored. The following values are also valid:
External value Internal value Description
Not applicable N/A The value is not supported.
OriginnodeThe key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in situations. Otherwise, this attribute is available to use like any other attribute, for example it is available for reports, queries, and workspaces.
Physical Device NameThe name of the physical device allocated for the database. The value format is an alphanumeric string with a maximum of 30 characters; for example, DATA_1.
Physical Device Name (Unicode)The Name of the physical device. Valid values include text strings with a maximum of 192 bytes.
Sample TimestampThe timestamp that indicates the date and time the product collected the sample for the SQL server. A sample is the data the product collects about the SQL server. The format is
MM/DD/YY HH:mm:SS, where:
Format Description
MM Month
DD Day
Format Description
YY Year
HH Hour
mm Minute
SS Second
For example, 01/25/02 08:00:00 indicates that the product collected the data from the SQL server on Friday, January 25, 2002 at 8:00 a.m.
ServerThe name of the SQL server. The value format is an alphanumeric string with a maximum of 30 characters; for example, CFS_SVR5.
Server VersionThe version of the SQL Server. The value format is the version in the format w.x.y.z; for example, 10.0.2531.0.
Server Version (Superceded)The version of the SQL Server. The value format is the version in the format x.y.z; for example, 10.0.253.
Note: For the complete version of the SQL Server, see the Server Version attribute.