Collections
AUDITTEXT_PIPE
Full text for audit entries
AUDIT_PIPE
Audit entries
CFG_RESOURCE
Configured resources
DEVICE_CONFIGURATION
Devices configured for storage
DEVSPACE
Device space usage
FULLEST_SEG_DB
Fullest (non-tempdb) database segments
FULLEST_SEG_TEMPDB
Fullest tempdb database segments
GLOBALSTATS
Global statistics
INDEXSTATSALL
Index stats for all databases
LISTENER
Listeners
LOGFILE
Error log entries from local file
LOGINS
Summary statistics for logins
LOGIN_STATS
Internal JOIN collection used by LOGINS collection; summary statistics for logins
LOGSHOLD
Transactions that prevent truncation points from moving
MDA_BLOCKTREE
Blocked processes
MDA_CACHEDOBJECT
Data cache objects
MDA_CACHEDSQLTEXT
SQL text of cached statements
MDA_CACHEDSTMT
Cached statement statistics
MDA_CACHEPOOL
Data cache buffer pools
MDA_DATABASE
Databases
MDA_DATACACHE
Data cache activity
MDA_DATACACHE_SUM
Data cache summary
MDA_DEADLOCK_PIPE
Deadlocks
MDA_DEVICE_IO
Device I/O activity
MDA_ENGINE
Engines
MDA_ERRORLOG_PIPE
Error log entries (from MDA)
MDA_HEALTH_ACTIVITY
Health activity
MDA_HEALTH_INSTANCE
Health instance information
MDA_HEALTH_NETIO
Health network I/O
MDA_HEALTH_PROCESS
Health processes information
MDA_LOCK
Locks
MDA_LOCKTIMEOUT_PIPE
Lock timeouts
MDA_MONITORING_OPTIONS
Monitoring options
MDA_MONITORING_PIPE_OPTIONS
Monitoring pipe options
MDA_NETWORK_IO
Network I/O activity by processes
MDA_OPENOBJ
Open object activity
MDA_PROCBATCH
Current executing batches
MDA_PROCCACHE
Summary statistics of the procedure cache
MDA_PROCESS
Processes
MDA_PROCSQLPLAN
Parsed SQL plans for current executing statements
MDA_PROCSQLPLANTEXT
SQL plan text for current executing statements
MDA_PROCSQLTEXT
SQL text of current executing statements
MDA_PROCSTACK
Procedure stack for current executing statements
MDA_PROCSTMT
Current executing statements
MDA_RECENTSQLTEXT_PIPE
SQL text of recently executed statements
MDA_RECENTSTMT_PIPE
Recently executed statements
MDA_STMTCACHE
Summary statistics about the statement cache
MDA_SYSLOAD
Summary statistics about system load
MDA_SYSPROCS
Procedure activity
MDA_SYSTIMEDEVENTS
System timed events
MDA_SYSTIMEDEVENTS_CLASS
System timed events by classes
MDA_TEMPDB_TOP_VIEW
TempDB activity
MDA_TEMPDB_USAGE
TempDB usage by process
MDA_THRESHOLD_PIPE
Threshold events for configured resource limitations
OPENTRANS
Open transactions
RESOURCE_LIMITS
Resource limits defined by a system administrator to regulate server resources
SEGUSAGE
Segment space usage
SPINLOCK
Spinlock activity
SPINLOCK_FREQ
Spinlock usage histograms (frequency graphs)
SUSPECT_OBJECTS
Suspect objects
SYSCONFIGURES
ASE instance settings, or parameters
TIME_RANGE
Time ranges for resource limits
TRANSLOG
Transaction log activity
TRANSLOGINFO
Transaction log extended information
TWOPHASECOMM
Two-phase commit (2PC) transactions