结构化查询语言Understanding SQL Server 2008 Performance Measure…….pptVIP

* sys.dm_db_index_operational_ stats Columns Pt 1 Cumulative counts Range and table scans started on index or heap Single row retrievals from index or heap Rows that were fetched through forwarding record Row locks requested Page locks requested Cumulative counts and elapsed times database engine Waited on row lock Waited on page lock Waited because of latch contention Waited on I/O page latch * sys.dm_db_index_operational_ stats Columns Pt 2 Cumulative counts Leaf-level insert, delete, update, delayed delete operations Above leaf-level insert, delete, update, delayed delete operations Zer