Browse by Tags

SQL Server 2005 methods to find table INDEX or Statistics age for better performance

Published 9 January 8 2:55 AM | SSQA.net

Recently we have had problems on one of the database that is used on 24/7 basis where a ETL process to import and export millions of rows on few tables has been taking longer time to finish. Further the SELECT queires on reports are timed-out and smaller...

Filed under: sql server, performance, query, index, process, agent, statistics, timeout, statiscs age

Considering Parallel plans and forcing plans for better performance

Published 23 October 7 8:55 AM | SSQA.net

Parameterizing T-SQL queries are a well-known task such as database programming and best practice in some tasks. It allows query plan reuse and eliminates the need of recompilation for multiple invocations of the same query that simply has different parameter...

Filed under: sql server, performance, optimization, cache, index, cpu, partition, guide, parallel execution, force

Rebuild some fragmented indexes - problem with Extent Scan Fragmentation value

Published 24 August 7 6:24 AM | SSQA.net

This was the question from SSP forums, I’m trying to rebuild few fragmented indexes on a table that is updated on regular basis. The “dbcc showcontig” gave this result: Table: 'Confidential' (999999999); index ID: 5, database ID: 5 LEAF level...

Filed under: sql server, performance, security, dbcc, index, table, fragmentation, showcontig, defrag

Update statistics causing negative performance

Published 17 August 7 8:11 PM | SSQA.net

Recently we have seen a negative performance for a query that is running against a 500GB size of database, where AUTO UPDATE STATISTICS is enabled and we perform weekly reindexing on this database. In addition to this I perform intermittent update statistics...

Filed under: sql server, performance, log, index, tempdb, best practice, update statistics, fragmentation

DMVs to provide state of TEMPDB during a performance tuning analysis

Published 14 August 7 8:55 AM | SSQA.net

TEMPDB - though the name sounds like temporary database, it most important for any user database! Coming to performance tuning exercise or analysis you would go through Task Manager initially to see how system's memory & processor are coping up...

Filed under: sql server, performance, analysis, index, rebuild, tempdb, hardware