25
二
MSSQL(2k5,2k8)默认运行一个Trace,所以在系统故障是可以使用这个Trace来获取相关信息。
这个Trace跟踪以下事件:
select * from ::fn_trace_getinf(0)
当然我们也可以设置是否默认运行这个Trace,相关配置项名字为'default trace enabled'.
这个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文件所在位置的方法:* 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
select * from ::fn_trace_getinf(0)
当然我们也可以设置是否默认运行这个Trace,相关配置项名字为'default trace enabled'.
归类于:数据库 标签: Trace MSSQL
还没有评论!
-
第一个发布评论?
发表评论
