DMV (Dynamic Management Views)

Backup-Restore

msdb..sp_delete_backuphistory '1-Jan-2005'	msdb..logmarkhistory	msdb..backupset
msdb..backupfile	msdb..backupmediaset	msdb..backupmediafamily
msdb..restorefile	msdb..restorefilegroup	msdb..restorehistory

Index Related

sys.indexes	sys.dm_db_index_usag	sys.Indexes	sys.dm_db_index_physical_stats
sys.dm_db_index_usage_stats	sys.index_columns

SQL Server Operating System

sys.dm_os_sys_info	sys.dm_os_performance_counters	sys.dm_exec_requests
sys.dm_exec_sessions	Master..sysprocesses	sys.dm_exec_connections
sys.dm_os_waiting_tasks	sys.dm_os_wait_stats	sys.dm_os_nodes

   

SQL Server Agent Tables

dbo.sysjobactivity	dbo.sysjobhistory	dbo.sysjobs	dbo.sysjobschedules
dbo.sysjobservers	dbo.sysjobsteps	dbo.sysjobstepslogs	dbo.sysoperators
dbo.sysproxies	dbo.sysschedules	dbo.syssessions

Database Development, Management & Maintenance Related

sys.columns	sys.check_constraints	sys.filegroups
sys.linked_logins	sys.master_files	sys.backup_devices
sys.configurations	sys.database_files	sys.databases
sys.default_constraints	sys.dm_tran_locks	sys.dm_tran_locks
sys.foreign_key_columns	sys.foreign_keys	sys.foreign_keys
sys.indexes	sys.key_constraints	sys.objects
sys.partitions	sys.remote_logins	sys.server_principals
sys.servers	sys.sql_logins	sys.syscharsets
sys.syslanguages	sys.types	sys.dm_db_file_space_usage

Security Related DMVs

sys.certificates	sys.credentials	sys.database_permissions
sys.database_principals	sys.securable_classes	sys.server_permissions
sys.server_principals	sys.server_role_members	sys.sql_logins
sys.symmetric_keys	sys.user_token

Log shipping Related DMVs

use msdb

log_shipping_monitor_alert	log_shipping_monitor_error_detail	log_shipping_monitor_history_detail
log_shipping_monitor_primary	log_shipping_monitor_secondary

Mirroring - Working with Mirroring Related DMVs

sys.database_mirroring	sys.database_mirroring_endpoints	sys.database_mirroring_witnesses
sys.dm_db_mirroring_connections	Sys.databases

Replication Tables in the Distribution Database

MSarticles	MSreplication_objects	MScached_peer_lsns	MSreplication_subscriptions
MSdistpublishers	MSrepl_commands	MSdistribution_agents	MSrepl_errors
MSdistribution_history	MSrepl_originators	MSdistributiondbs	MSrepl_transactions
MSdistributor	MSrepl_version	MSlogreader_agents	MSsnapshot_agents
MSlogreader_history	MSsnapshot_history	MSmerge_agents	MSsubscriber_info
MSmerge_history	MSsubscriber_schedule	MSmerge_sessions	MSsubscriptions
MSpublications	MStracer_tokens

Replication Tables in the Publication Database

MSpeer_response	MSmerge_contents	MSpub_identity_range	MSmerge_current_partition_mappings
sysarticlecolumns	MSmerge_dynamic_snapshots	sysarticles	MSmerge_errorlineage
sysarticleupdates	MSmerge_generation_partition_mappings	sysmergearticlecolumns	MSmerge_genhistory
sysmergepublications	MSmerge_partition_groups	sysmergeschemaarticles	MSmerge_past_partition_mappings
sysschemaarticles	MSpeer_conflictdetectionconfigresponse	syssubscriptions	MSpeer_lsns
systranschemas

Replication Tables in the Subscription Database

MSdynamicsnapshotjobs	MSmerge_settingshistory	MSdynamicsnapshotviews
MSsnapshotdeliveryprogress	MSmerge_current_partition_mappings	MSsubscription_properties
sysmergearticles	MSmerge_generation_partition_mappings	sysmergepartitioninfo
MSmerge_genhistory	sysmergepublications	MSmerge_identity_range
sys.dm_repl_articles	sys.dm_repl_schemas	sys.dm_repl_tranhash
sys.dm_repl_traninfo