Bắt đầu giới thiệu sự kiện được theo dõi thời gian Thay vào đó Of hoặc Sau khi Insert, Update, Delete, Merge Lắng nghe để hàng trăm Windows / SQL Server SQL 179 Màn hình các sự kiện sự kiện Server nội bộ Mỗi một quá trình chờ đợi một tài nguyên Tất cả các sự kiện bảo mật | Technology Introducet 1 Events Tracked Data Available Performance DML Triggers fires T-SQL Beginning Instead Of or After Inserted and deleted Synchronous within transaction code on table events of time Insert Update Delete Merge tables all columns all changes with user context depending on width of table and amount of code may have a significant impact PerfMon SysMon Windows utilities Beginning of time Listens for hundreds of Windows SQL Server events Counters for nearly any event no actual data Virtually no impact SQL Trace and Profiler SQL Server internal monitoring and UI Monitors 179 SQL Server internal events Event data no actual data Profiler may have an impact trace alone has little impact Wait States tracks system waits 7 Every time a process waits for a resource Aggregate count of waits by wait type No impact C2 Auditing combines SQL Trace and security settings for compliance 2000 All security events All security-related data Minor impact Common Criteria Compliance combines SQL Trace and security settings for compliance 2005 All security events All security-related data Minor impact DMVs dynamic management views catalog views 2005 Massive details for all metadata and current status No impact Management Studio Reports easy way to view DMV data 2005 Builds on many of the DMVs Some impact depending on report Performance Dashboard downloadable add-on with extra reports 2005 Builds on many of the DMVs Some impact depending on report DDL Triggers responds to server and database DDL events 2005 All server and database DDL events and logins EventDate provides all info in XML format Rarely called so no real impact Change Tracking synchronously records which rows have been updated 2008 Row inserts updates and deletes PK with net change columns changed very limited user context Little impact Change Data Capture asynchronously reads T-Log and records data changes 2008 Insert Update Delete Merge All or net data changed all column values no user context Reads from .
