Browse by Tags

SQL Server 2005: Slow running queries - Blocking and Index problems

Published 24 September 7 9:19 AM | SSQA.net

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...

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

SQL Server 2005 how to find a rarely used index?

Published 18 May 7 5:31 AM | SSQA.net

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...

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