|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Viewing Table size in Management StudioI have a DB that is growing in size, and I would like to see the amount
of disk space taken up by each table. Enterprise Manager used to have a screen that displayed the total space used for each table in a given database. MS seems to have taken this handy feature away in Management Studio, unless it is there but still hidden. I could just run sp_spaceused on each table, but that is time consuming. I'd rather see it all in one place. Thanks, John Press F/ to open the summary window. Select the desired database in Object Explorer. In the summary
Window, you now have a report named "Disk Usage". It can take a while for that report to run on a large database, though... -- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ <jhoge***@yahoo.com> wrote in message news:1158329447.513455.179270@e3g2000cwe.googlegroups.com... >I have a DB that is growing in size, and I would like to see the amount > of disk space taken up by each table. > > Enterprise Manager used to have a screen that displayed the total space > used for each table in a given database. > > MS seems to have taken this handy feature away in Management Studio, > unless it is there but still hidden. > > I could just run sp_spaceused on each table, but that is time > consuming. I'd rather see it all in one place. > > Thanks, > John > In SSMS, in the [Object Explorer] pane, click on the database, press the
[F7] key. In the [Summary] window, click on the [Report] drop down arrow,and select [Disk Usage]. Expand the [Disk Space Used by Tables]. -- Show quoteArnie Rowland, Ph.D. Westwood Consulting, Inc Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous <jhoge***@yahoo.com> wrote in message news:1158329447.513455.179270@e3g2000cwe.googlegroups.com... >I have a DB that is growing in size, and I would like to see the amount > of disk space taken up by each table. > > Enterprise Manager used to have a screen that displayed the total space > used for each table in a given database. > > MS seems to have taken this handy feature away in Management Studio, > unless it is there but still hidden. > > I could just run sp_spaceused on each table, but that is time > consuming. I'd rather see it all in one place. > > Thanks, > John > Thanks guys.
I see the report menu on the summary pane but it is greyed out. I did a full install of SQL server onto my machine, so I don't know why it would be grey. Thanks, John Have you selected a database in the Object Explorer pane?
-- Show quoteArnie Rowland, Ph.D. Westwood Consulting, Inc Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous <jhoge***@yahoo.com> wrote in message news:1158344469.180957.207570@h48g2000cwc.googlegroups.com... > Thanks guys. > > I see the report menu on the summary pane but it is greyed out. I did a > full install of SQL server onto my machine, so I don't know why it > would be grey. > > Thanks, > John > Arnie,
The report menu is active when I select the entire server. As soon as I select a database it goes grey. John Is it active when you select a system database e.g. master? If so check the
compatability mode of the database you are trying to view. It needs to be 80 or higher for the report icon to be active although for the Disk Usage report it actually needs to be 90 to get data back otherwise you'll just get an error in the report. Show quote news:1158345304.978525.29320@i42g2000cwa.googlegroups.com... > Arnie, > > The report menu is active when I select the entire server. As soon as I > select a database it goes grey. > > John > Thanks,
Switching the compatibility level to 9.0 did the trick. John  |
|||||||||||||||||||||||
Other interesting topics