Browse by Tags

• best practice
• blocking
• blog
• dba
• index plan
• maintenance plan
• measures
• missing
• object
• performance
• performance monitoring
• poor
• query
• sql server
• sys.dm_db_index_physical_stats
• tsql

SQL Server 2005 DMV - how it can help to consider whether index is useful or not?
04 February 08 07:06 AM | SQL Master | 4 Comments   

When it comes to performance, for a DBA indexes are the first one to come to mind in order to fine tune the tasks on the database. In this series we have already covered this huge topic of indexing and how best you can make use of Dynamic Management Views Read More...

Filed under: performance, sql server, dmv, indexes, dba, performance monitoring, index plan

SQL Server Query Performance - think about page split and fragmentation, measures to reduce the behaviour and best use of dm_db_index_physical_stats DMV
14 January 08 01:22 AM | SQL Master | 2 Comments   

It is an universal truth in the database field that due to the fragmentation and page split the performance will be affected even for a simple [ SELECT <ColumnName> from.... ] type of query. So what you need to check or take action in terms of DBA Read More...

Filed under: performance, sql server, dmv, indexes, dba, best practice, maintenance plan, performance monitoring, sys.dm_db_index_physical_stats, measures

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 get a list of missing indexes and identify useful indexes
25 June 07 05:43 AM | SQL Master | 1 Comments   

It is evident that well-designed indexes will help a lot in attaining performance for a poorly performing queries, this can also reduce disk I/O operations by consuming lesser resources on the server. Maily indexes are helpful during SELECT queries and Read More...

Filed under: performance, sql server, dmv, indexes, missing

Get a blocking list for the objects & indexes using DMV
13 June 07 07:44 AM | SQL Master | 6 Comments   

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

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