Browse by Tags

All Tags » fragmentation   (RSS)
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...
Update statistics causing negative performance
17 August 07 06:11 PM | SQL Master | 2 Comments   
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 Read More...
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...
Index fragmentation and DBCC SHOWCONTIG in SQL Server 2005!
03 July 07 02:55 AM | SQL Master | 0 Comments   
In SQL Server 2005 Dynamic Management Views (DMV) & DM Functions (DMF) allows you the look inside the server to return the required information. It will also helps you to monitor the server instance health and performance to diagnose the problem. Read More...
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...