MS SQL Server - Database Size (Free,Used)

Author

Database Size (Free,Used)

Joe K.

2005-03-30, 7:03 pm

In SQL Server Enterprise Manager taskpad will display database size free and
used space.

What tables within SQL Server is this information stored?

Is there another way to obtain database size free and used space?

Thanks,

Narayana Vyas Kondreddi

2005-03-30, 7:03 pm

See sp_spaceused in SQL Server Books Online. In master databse, you could
run the following to see what tables this procedure accesses:

sp_helptext sp_spaceused
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/

"Joe K." <Joe K.@discussions.microsoft.com> wrote in message
news:805D5942-D569-4083-99B4- E537F845D880@microso
ft.com...

In SQL Server Enterprise Manager taskpad will display database size free and
used space.

What tables within SQL Server is this information stored?

Is there another way to obtain database size free and used space?

Thanks,

Hari Prasad

2005-03-30, 7:03 pm

Hi Joe,

Sysindexes system table in each database stores all the space information. You could also use the system stored procedure
"sp_spaceused " to get the space usage. For transaction log usage use DBCC SQLPERF(LOGSPACE)

Thanks
Hari
SQL Server MVP

____________________
________________
Joe K. Wrote:

In SQL Server Enterprise Manager taskpad will display database size free and
used space.

What tables within SQL Server is this information stored?

Is there another way to obtain database size free and used space?

Thanks,

Sent via SreeSharp NewsReader http://www.SreeSharp.com

Sponsored Links