Browse by Tags

• blocking
• dbcc
• defrag
• index
• locking
• loss
• performance
• process
• profiler
• security
• showcontig
• sql server
• trace
• troubleshoot

Rebuild some fragmented indexes - problem with Extent Scan Fragmentation value
24 August 07 04:24 AM | SQL Master | 2 Comments   

This was the question from SSP forums, I’m trying to rebuild few fragmented indexes on a table that is updated on regular basis. The “dbcc showcontig” gave this result: Table: 'Confidential' (999999999); index ID: 5, database ID: 5 LEAF level scan performed. Read More...

Filed under: performance, sql server, security, table, dbcc, fragmentation, index, defrag, showcontig

Table fragmentation, Index contention and locking issues to resolve
31 July 07 07:31 AM | SQL Master | 2 Comments   

Yet another important factors that every DBA needs to concerned about table & index fragmentation within their SQL Server environment. Refer to the a rticle about DetectTableFragmentation in both 2000 and 2005 version. Fragmentation occurs due to Read More...

Filed under: performance, sql server, blocking, profiler, table, fragmentation, process, trace, locking, loss

How to detect a table fragmentation?
29 May 07 06:02 PM | SQL Master | 2 Comments   

In SQL 2000 version days you could take help of DBCC SHOWCONTIG statement, but this is deprecated in SQL Server 2005, so how to go about it. You can take help DMVs & DMFs in this case, DMV - Dynamic Management View and DMF - Dynamic Management Function, Read More...

Filed under: performance, troubleshoot, table, dbcc, fragmentation