Browse by Tags

• agent
• blocking
• dmv
• fragmentation
• index
• locking
• loss
• performance
• profiler
• query
• sp_who
• spid
• statiscs age
• statistics
• table
• timeout
• trace

SQL Server 2005 methods to find table INDEX or Statistics age for better performance
09 January 08 01:55 AM | SQL Master | 4 Comments   

Recently we have had problems on one of the database that is used on 24/7 basis where a ETL process to import and export millions of rows on few tables has been taking longer time to finish. Further the SELECT queires on reports are timed-out and smaller Read More...

Filed under: performance, sql server, query, process, agent, statistics, index, timeout, statiscs age

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

Troubleshoot a process (SPID) using tools & TSQL queries
31 May 07 08:50 AM | SQL Master | 2 Comments   

First thing a DBA would follow to troubleshoot a query is to look at the process (SPID) ID for that query and with the help of Enterprise Manager tool looking at the Current Activity option under management pane will give you list of processes that are Read More...

Filed under: performance, sql server, dmv, spid, sp_who, process