25

MSSQL:Default Trace

MSSQL(2k5,2k8)默认运行一个Trace,所以在系统故障是可以使用这个Trace来获取相关信息。
这个Trace跟踪以下事件:
Database
    * Data file auto grow
    * Data file auto shrink
    * Database mirroring status change
    * Log file auto grow
    * Log file auto shrink
Errors and Warnings
    * Errorlog
    * Hash warning
    * Missing Column Statistics
    * Missing Join Predicate
    * Sort Warning
Full-Text
    * FT Crawl Aborted
    * FT Crawl Started
    * FT Crawl Stopped
Objects
    * Object Altered
    * Object Created
    * Object Deleted
Security Audit
    * Audit Add DB user event
    * Audit Add login to server role event
    * Audit Add Member to DB role event
    * Audit Add Role event
    * Audit Add login event
    * Audit Backup/Restore event
    * Audit Change Database owner
    * Audit DBCC event
    * Audit Database Scope GDR event (Grant, Deny, Revoke)
    * Audit Login Change Property event
    * Audit Login Failed
    * Audit Login GDR event
    * Audit Schema Object GDR event
    * Audit Schema Object Take Ownership
    * Audit Server Starts and Stops
Server
    * Server Memory Change
查看Trace是否在运行以及Trace文件所在位置的方法:
select * from ::fn_trace_getinf(0)
当然我们也可以设置是否默认运行这个Trace,相关配置项名字为'default trace enabled'.
 
还没有评论!
    第一个发布评论?
发表评论
 名字(必须)
 邮箱(可选)
 网址(可选)