| title | Display Data and Log Space Information for a Database | Microsoft Docs | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| ms.custom | |||||||||
| ms.date | 06/13/2017 | ||||||||
| ms.prod | sql-server-2014 | ||||||||
| ms.reviewer | |||||||||
| ms.technology | supportability | ||||||||
| ms.topic | conceptual | ||||||||
| helpviewer_keywords |
|
||||||||
| ms.assetid | c7b99463-4bab-4e9b-9217-fcb0898dc757 | ||||||||
| author | stevestein | ||||||||
| ms.author | sstein | ||||||||
| manager | craigg |
This topic describes how to display the data and log space information for a database in [!INCLUDEssCurrent] by using [!INCLUDEssManStudioFull] or [!INCLUDEtsql].
In This Topic
-
Before you begin:
-
To display data and log space information for a database, using:
Permission to execute sp_spaceused is granted to the public role. Only members of the db_owner fixed database role can specify the @updateusage parameter.
-
In Object Explorer, connect to an instance of [!INCLUDEssNoVersion] and then expand that instance.
-
Expand Databases.
-
Right-click a database, point to Reports, point to Standard Reports,, and then click Disk Usage.
-
Connect to the [!INCLUDEssDE].
-
From the Standard bar, click New Query.
-
Copy and paste the following example into the query window and click Execute. This example uses the sp_spaceused system stored procedure to report disk space information for the
Vendortable and its indexes.
USE AdventureWorks2012;
GO
EXEC sp_spaceused N'Purchasing.Vendor';
GO -
Connect to the [!INCLUDEssDE].
-
From the Standard bar, click New Query.
-
Copy and paste the following example into the query window and click Execute. This example queries the sys.database_files catalog view to return specific information about the data and log files in the [!INCLUDEssSampleDBobject] database.
USE AdventureWorks2012;
GO
SELECT file_id, name, type_desc, physical_name, size, max_size
FROM sys.database_files ;
GO
SELECT (Transact-SQL)
sys.database_files (Transact-SQL)
sp_spaceused (Transact-SQL)
Add Data or Log Files to a Database
Delete Data or Log Files from a Database