Thursday, March 22, 2012

Database Size

I want how can i do to do capacity planning in sqlserver 2000.
Do you make scripts (vbs) who query the sysfiles tables and transfer the answer in excel ?
Please help me.
Philselect cast(sum(m.[size]) * 8 as nvarchar)+N'KB' AS DB_SIZE, cast(sum(l.[size]) * 8 as varchar)+N'KB' AS LOG_SIZE
from dbo.[sysfiles] m, dbo.[sysfiles] l
where m.[groupid] != 0
and l.[groupid] = 0|||Thanks for your answer, can i query other database server with this query ?|||[servername].[database].[dbo].[sysfiles]

where the server and database have been linked to the SQL Server you are running the query from

No comments:

Post a Comment