Library code snippets
Calculate Diskspace Used by a Table or Database
By James Crowley, published on 30 Jan 2005
Ever wondered how much storage space a particular table in your SQL Server database takes up? It's actually *really* easy to find out! Simply do
EXEC sp_spaceused 'tablename'
where tablename is the table you're interested in, and you'll get back something that looks like this:
| names | rows | reserved | data | index_size | unused |
|---|---|---|---|---|---|
| dir_pages |
4308 | 13088 KB | 12928 KB | 88 KB | 72 KB |
If you omit the 'tablename' parameter, then you'll get back two resultsets with information about the entire database:
| database_name | database_size | unallocated space |
|---|---|---|
| devfusion |
11248.69 MB | 18.52 MB |
| reserved | data | index_size | unused |
|---|---|---|---|
| 87856 KB | 81232 KB | 5152 KB | 1472 KB |
James first started this website when learning Visual Basic back in 1999 whilst studying his GCSEs. The site grew steadily over the years while being run as a hobby - to a regular monthly audience ...
Related articles
Related discussion
-
VS.NET/sql server installation problem
by daspeac (4 replies)
-
Research topic in software
by reachsangeethamathew (0 replies)
-
Job Opening - New Braunfels, Tx for C# Programmer
by kirkkelly (3 replies)
-
update database when the website is nor running on the browser
by hepsy.i (1 replies)
-
Graphical Reports in C# .net
by gulshanuetian (0 replies)
Related podcasts
-
ADO.NET "Astoria" Data Services with Shawn Wildermuth
Scott chats with Shawn Wildermuth, "the ADO Guy," about ADO.NET Data Services, aka "Project Astoria." It's REST for SQL Server. Should you care? What's REST? How does this relate to WCF or ASP.NET?
usefull info
Thanks james
This thread is for discussions of Calculate Diskspace Used by a Table or Database.