Browse by Tags

Unused indexes on a database, its good and bad

Published 27 July 7 8:51 AM | SSQA.net

You may be aware that the indexes on a SQL Server database take up space, so in case of unused indexes its obvious that they waste storage. It is easy to find the indexes using SP_HELPINDEX statement against a table, so to identify the unused indexes...

Filed under: sql server, performance, indexes, security, query, unused indexes

Get a blocking list for the objects & indexes using DMV

Published 13 June 7 9:44 AM | SSQA.net

Yet another help from DMV I would like to share here, say on a SQL Instance you are getting low-level I/O and blocking intermittently. For the I/O issues using SYSMON (PERFMON) is ideal to get more information during the busy times and low-usage times...

Filed under: sql server, performance, indexes, dmv, query, object

Cached query plans and top stored procedures that are recompiled

Published 11 May 7 6:2 AM | SqlServer-QA.net (SSQA)

We all know that the cached query plans are good to go to attain the performance and no doubt that inefficient query plan will cause more distress to performance with an increased spike in CPU consumption. At the same occurrence of recompilation of a...

Filed under: sql server, package, indexes, query, perfmance, plan, cache