February 4, 2004 at 7:37 am
How to obtain simply the total/used space for a SQL Server db and for table/cluster/index (for Oracle, you have to use 2 or 3 dictionary views).
February 4, 2004 at 8:21 am
The stored procedure sp_spaceused is probably what you want.
Refer to the BOL for more information on how it's used and what the results are.
-SQLBill
BOL = Books OnLine = Microsoft SQL Server Help
Installed as part of the Client Tools and found at Start>Programs>Microsoft SQL Server>Books OnLine
February 4, 2004 at 8:36 am
thank for the reply, but with this procedure, you can't have information SIMPLY (without writing another procedure ) for 1 table. If you would like to get information for all of the tables, or for table starting with a prefix, or to limit the output (you need only the table_name + size , not the other columns related to index...). I am working with Oracle and I find that is more simple and flexible to have this info (using a simple SELECT statement ....).
February 9, 2004 at 3:03 am
You can do the same with MSSQL too
You can query the sysindex table to get the space usage informations, so you can define the filter criteria you want.
Have a look on the sp_spaceused stored proc (sp_helptext sp_spaceused) to see how the space usage informations are calculated
Bye
Gabor
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply