Browse by Tags

DBCC EXTENTINFO - unused pages in these extents (undocumented)

Published 4 September 7 7:45 AM | SSQA.net

When it comes to resolving table fragmentation, the basic checkout you perform is to run DBCC INDEXDEFRAG or even run DBCC DBREINDEX statements. As per the default configuraiton SQL Database Engine allocates a new extent to an allocation unit only when...

Filed under: sql server, performance, indexes, data, i/o, table, insert, allocation, fragmentation, deadlock, extent

Rebuild some fragmented indexes - problem with Extent Scan Fragmentation value

Published 24 August 7 6:24 AM | SSQA.net

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...

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

Update statistics causing negative performance

Published 17 August 7 8:11 PM | SSQA.net

Recently we have seen a negative performance for a query that is running against a 500GB size of database, where AUTO UPDATE STATISTICS is enabled and we perform weekly reindexing on this database. In addition to this I perform intermittent update statistics...

Filed under: sql server, performance, log, index, tempdb, best practice, update statistics, fragmentation

Table fragmentation, Index contention and locking issues to resolve

Published 31 July 7 9:31 AM | SSQA.net

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...

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