Différentes petites requêtes pour l’analyse de la mémoire et des espaces occupés

EXEC sp_spaceused
SELECT fileid, name, filename, size, growth, status, maxsize
FROM dbo.sysfiles WHERE (status & 0x40) <>0
DBCC sqlperf(logspace)
DBCC showfilestats
DBCC MEMORYSTATUS
-- SQL 2000
select * from sys.sysperfinfo
-- http://support.microsoft.com/kb/271624
-- SQL 2005
select * from sys.dm_os_performance_counters
-- SQL 2008
select * from sys.dm_resource_governor_workload_groups