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
Showing posts with label capacity. Show all posts
Showing posts with label capacity. Show all posts
Thursday, March 22, 2012
Subscribe to:
Posts (Atom)