Browse by Tags

• blocking
• databases
• dmv
• monitor
• poor
• sql server
• tsql

SQL Server 2005: Slow running queries - Blocking and Index problems
24 September 07 07:19 AM | SQL Master | 2 Comments   

As a DBA you must be aware that slow or long running queries can contribute to excessive resource consumption and be the consequence of blocked queries. No database application is exception to this behaviour, so the queries that also run slowly because Read More...

Filed under: sql server, dmv, blocking, indexes, blog, tsql, poor

SQL Server 2005 how to find a rarely used index?
18 May 07 03:31 AM | SQL Master | 1 Comments   

For a SQL Server database having an index is always beneficial and from performance point of view too. But how about the clustered index which is occupying space on the database that is not used by any of the queries in the database. The Query Optimizer Read More...

Filed under: sql server, blocking, indexes, perfmance, blog, monitor, databases