Sp to determine size of db | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Sp to determine size of db

Hi!Folks
I need to know the size of db.Is there is any built in sp which can be used to get the size of each database(data+log)
SP_SPACEUSED & SP_HELPDB and books online is best resource for further information.
http://vyaskn.tripod.com/track_sql_database_file_growth.htm for relevancy. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
there is a free tool availble to monitor the growth of your DB
http://www.sqlservercentral.com/col…reehealthhistoryandperformancemonitoringt.asp this script will be notified when automatic database file growth occurs. This script will log file growth. It will not log file shrink but could be easily modifed to do so http://www.sqlservercentral.com/scripts/contributions/1547.asp —————————————-
Cast your vote
http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka

]]>