Wednesday, February 24, 2010

DB Engine

select *
from sys.filegroups
select *
from sys.destination_data_spaces
select *
from sys.data_spaces
select *
from sys.master_files
select *
from sys.allocation_units
select *
from sys.dm_db_session_space_usage
select *
from sys.dm_db_file_space_usage
select *
from sys.databases
select *
from sys.dm_io_cluster_shared_drives
select *
from sys.dm_io_pending_io_requests

select *
from sys.database_files
select *
from sys.database_recovery_status
--- sql 2008 --
-- select *
-- from sys.change_tracking_databases
--select *
--from sys.dm_filestream_file_io_requests
--select *
--from sys.change_tracking_files
--select *
--from sys.dm_filestream_file_io_handles

No comments:

Post a Comment