Browse by Tags

• blogs
• disk space
• disks
• dmv
• hardware
• indexes
• maintenance plan
• management
• measures
• microsoft
• optimization
• performance
• performance monitoring
• reindexing
• slow query
• sorting
• sql server
• sys.dm_db_index_physical_stats
• technet

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: How do I identify the queries that are worth tuning?
16 November 07 06:02 AM | SQL Master | 2 Comments   

Have you ever asked this question about how do I identify the queries that worth tuning? The simple answer it is neither easy or hard to obtain such information if you have managed your SQL Server by deploying industry best practices (wherever possible). Read More...

Filed under: performance, sql server, microsoft, management, dmv, dba, best practice, blogs, technet, slow query

Disk Space Requirements for Index DDL Operations
28 September 07 06:38 AM | SQL Master | 3 Comments   

Are you watching your disk space during the indexes operations where these database objects are stored? Recently I was stumped on a database that is only 5GB had reindexing process failure due to 10% of disk free space was available. For your information Read More...

Filed under: performance, sql server, indexes, optimization, dba, hardware, disks, best practice, reindexing, disk space, sorting