Result: name fileid filename filegroup size maxsize growth usage Here’s an example of calling that: EXEC sp_helpdb N'WideWorldImporters' The sp_helpdb Stored ProcedureĪnother system stored procedure is sp_helpdb. In this example we return information about the Cities table only. Result: name rows reserved data index_size unusedĬities 37940 4880 KB 3960 KB 896 KB 24 KB In this case, only one result set will be returned. You can also provide an object name to return data on a specific object within the database. This returns two result sets that provide the relevant information. Result: database_name database_size unallocated space To use it, simply switch to the relevant database and execute the procedure. This is a system stored procedure that displays the number of rows, disk space reserved, and disk space used by a table, indexed view, or Service Broker queue in the current database, or displays the disk space reserved and used by the whole database. This article presents six ways to check the size of a SQL Server database using T-SQL. However, if you prefer to use T-SQL to manage your databases, you’ll need to run a query that returns this information. If you’re using a GUI tool, such as SSMS to manage your databases, you can easily check the size of your database by clicking your way through the GUI (right-click the database, point to Reports, then Standard Reports, and then click Disk Usage).
0 kommentar(er)
