Browse by Tags

• blocking
• fragmentation
• locking
• loss
• package
• perfmon
• performance
• process
• stats
• 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

Stored procedures performance issues
08 May 07 03:57 AM | SQL Master | 0 Comments   

Every now and then I tend to see lot of questions such as "We have a web application which interacts with SQL Server through Stored Procs. Every so often it seems the response time for an individual Stored Proc will go from a few seconds to a few minutes. Read More...

Filed under: performance, sql server, stats, package, perfmon, profiler