Browse by Tags

• blocking
• locking
• loss
• performance
• profiler
• sql server
• table
• trace

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