Browse by Tags

• benchmarking
• best practice
• blocking
• buffer
• cache
• dmv
• FAQ
• maintenance plan
• monitoring
• msdn
• perfmon
• performance
• ratio
• sysmon
• table variable
• tablesample
• tempdb
• workfiles
• worktables

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: performance, sql server, blocking, msdn, tablesample, tempdb, best practice, FAQ, monitoring, maintenance plan, benchmarking, table variable, temp tables