February 23, 2012 at 7:40 am
Hi,
I am planning to get more diskspace for my sqlserver box.
Before that i would like do some statistics on space usage of my db. so that i can give a report to get more disk volume.
i need to a code which can iterate through out of my db and
result has to be inserted one table
how can use
sp_spaceused 'table'
February 23, 2012 at 7:45 am
what information do you want, how big a table is in terms of its storage?
there are the reports at db level which gives that kind of information
right click a DB, reports, standard reports, then select a report
February 23, 2012 at 8:04 am
yes....
i need data for each table in database where as i am using sqlserver 2005.
February 23, 2012 at 8:07 am
I am not getting report options
February 23, 2012 at 8:09 am
Simha24 (2/23/2012)
I am not getting report options
take a look for the performance dashboard reports for SQL 2005
also on a side note, this is the 2008 section, you will get the right answers quicker if its posted in the right area, as its 2008 you get these reports as standard, 2005 you dont
February 23, 2012 at 8:16 am
also take a look at sp_msforeachtable
e.g
sp_msforeachtable 'exec sp_spaceused [?]'
February 23, 2012 at 12:44 pm
run on each database - it will break it each table by MB.
select object_name(id) [Table Name], [Table Size] = convert (varchar, dpages * 8 / 1024) + 'MB'
from sysindexes where indid in (0,1)order by dpages desc
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply