Wednesday, March 7, 2012

Monitor SQL data/log file % used

Is there a way to monitor the % (or size) of the data file used in a SQL
2005 database? I can use the Performance Monitor to track the log file (Log
file(s) used size (kb)), but I don't see the same option for the data file.
Am I jut missing something?
ThanksQuery select size from sys.database_files in SQL 2005 or select size from
sysfiles in SQL 2000.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Tim Kelley" <tkelley@.company.com> wrote in message
news:O5Tb7pe0GHA.1040@.TK2MSFTNGP06.phx.gbl...
> Is there a way to monitor the % (or size) of the data file used in a SQL
> 2005 database? I can use the Performance Monitor to track the log file
> (Log file(s) used size (kb)), but I don't see the same option for the data
> file. Am I jut missing something?
> Thanks
>

No comments:

Post a Comment