-->
Returns information about the operating system volume (directory) on which the specified databases and files are stored in SQL Server. Use this dynamic management function to check the attributes of the physical disk drive or return available free space information about the directory.
Drivers Transactionele Analyse
- Having an issue with your display, audio, or touchpad? Whether you're working on an Alienware, Inspiron, Latitude, or other Dell product, driver updates keep your device running at top performance. Step 1: Identify your product above. Step 2: Run the detect drivers scan to see available updates. Step 3: Choose which driver updates to install.
- MyDMV offers personalized and secure online services without the need to mail in forms or make a trip to a local DMV office.Log into MyDMV toChange your addressCheck your license status (driving privilege)Check your registration informationOrder your driving record (abstract)Restore your revoked licenseYou can complete all other online services without signing into MyDMV.
Syntax
Drivers Transactional Analysis
Arguments
database_id
ID of the database. database_id is int, with no default. Cannot be NULL.
file_id
ID of the file. file_id is int, with no default. Cannot be NULL.
Table Returned
| Column | Data type | Description |
| database_id | int | ID of the database. Cannot be null. |
| file_id | int | ID of the file. Cannot be null. |
| volume_mount_point | nvarchar(512) | Mount point at which the volume is rooted. Can return an empty string. Returns null on Linux operating system. |
| volume_id | nvarchar(512) | Operating system volume ID. Can return an empty string. Returns null on Linux operating system. |
| logical_volume_name | nvarchar(512) | Logical volume name. Can return an empty string. Returns null on Linux operating system. |
| file_system_type | nvarchar(512) | Type of file system volume (for example, NTFS, FAT, RAW). Can return an empty string. Returns null on Linux operating system. |
| total_bytes | bigint | Total size in bytes of the volume. Cannot be null. |
| available_bytes | bigint | Available free space on the volume. Cannot be null. |
| supports_compression | tinyint | Indicates if the volume supports operating system compression. Cannot be null on Windows and returns null on Linux operating system. |
| supports_alternate_streams | tinyint | Indicates if the volume supports alternate streams. Cannot be null on Windows and returns null on Linux operating system. |
| supports_sparse_files | tinyint | Indicates if the volume supports sparse files. Cannot be null on Windows and returns null on Linux operating system. |
| is_read_only | tinyint | Indicates if the volume is currently marked as read only. Cannot be null. |
| is_compressed | tinyint | Indicates if this volume is currently compressed. Cannot be null on Windows and returns null on Linux operating system. |
| incurs_seek_penalty | tinyint | Indicates the type of storage supporting this volume. Possible values are: 0: No seek penalty on this volume, typically when the storage device is PMM or SSD 1: Seek penalty on this volume, typically when the storage device is HDD 2: The storage type can't be determined when the volume is on a UNC path or mounted shares NULL: The storage type can't be determined on Linux operating system Applies to: SQL Server (starting with SQL Server 2019 (15.x)) |
Drivers Transactional Analysis
Security
Permissions
Transactional Drivers Questionnaire
In-person driver license appointments are currently only available for licenses that are expired or are expiring by February 28, 2021. Customers are encouraged to renew online, if eligible. REAL ID compliance deadline has been extended until October, 2021. REAL ID transactions are not currently conducted outside of renewal transactions.
Requires VIEW SERVER STATE permission.
Examples
A. Return total space and available space for all database files
The following example returns the total space and available space (in bytes) for all database files in the instance of SQL Server.
B. Return total space and available space for the current database
The following example returns the total space and available space (in bytes) for the database files in the current database.
See Also
Drivers Transactional Analysis
sys.master_files (Transact-SQL)
sys.database_files (Transact-SQL)