Browse by Tags

• analysis
• benchmarking
• best practice
• best practices
• blocking
• buffer
• cache
• dmv
• FAQ
• fragmentation
• hardware
• index
• log
• maintenance plan
• monitoring
• msdn
• perfmon
• performance
• performance monitoring
• ratio
• rebuild
• sysmon
• table variable
• tablesample
• temp tables
• update statistics
• workfiles
• worktables

SQL Server Performance issues with Fragmentation and heavy usage of TEMPDB?
15 May 08 01:59 AM | SQL Master | 2 Comments   

Whenever a performance issue occurs on the SQL Server database best option for diagnosing and troubleshooting common problems by using publicly available tools such as Profiler, System Monitor (Perfmon), and Dynamic Management Views (DMVs) in SQL Server Read More...

Filed under: performance, sql server, dmv, tempdb, monitoring, performance monitoring, benchmarking, best practices

SQL Server 2005 PERFMON counter spikes in Transactions/sec and Buffer Cache Hit ratio, what does it say?
14 March 08 02:16 AM | SQL Master | 3 Comments   

Recently I was involved in one of the Performance Audit exercise at a client's place where they complain about Server CPU is always HIGH and what they have observed is even the physical disk where TEMPDB is located has been used extensively, as they can Read More...

Filed under: performance, sql server, cache, dmv, perfmon, buffer, sysmon, tempdb, monitoring, temp tables, workfiles, worktables, ratio

SQL server Temporary Tables, Table Variables and Recompiles - interesting scenario
17 January 08 01:23 AM | SQL Master | 2 Comments   

Usage of Temporary tables or variables is a common scenario in SQL Server world, since SQL Server 2005 usage of TEMPDB references to the blog posts here: http://sqlserver-qa.net/blogs/tools/archive/2007/04/05/sql-server-index-optimization-best-practices.aspx Read More...

Filed under: tempdb, best practice, FAQ, monitoring, maintenance plan, benchmarking, table variable, temp tables, performance, sql server, blocking, msdn, tablesample

Update statistics causing negative performance
17 August 07 06:11 PM | SQL Master | 2 Comments   

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

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

DMVs to provide state of TEMPDB during a performance tuning analysis
14 August 07 06:55 AM | SQL Master | 5 Comments   

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

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