Browse by Tags

• best practice
• blogs
• dba
• dmv
• index plan
• links
• maintenance plan
• measures
• msdn
• performance
• rebuild
• reorganize
• schedule
• schema
• sql server
• sys.dm_db_index_physical_stats

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 indexing - when to reorganize or rebuild?
21 January 08 03:30 AM | SQL Master | 4 Comments   

Re-organizing or rebuilding index would help the SQL optimizer to reduce the fragmentation for a better performance. In this case few users might have doubt that when to rebuild or reorganize (SQL Server 2005)? IN the series of Performance blog posts Read More...

Filed under: sql server, indexes, msdn, rebuild, schema, best practice, blogs, performance monitoring, reorganize, links, schedule

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