Browse by Tags

• 2000
• 2005
• 64 bit
• awe
• benchmarking
• best practice
• best practices
• buffer
• buffers
• cache
• memory
• package
• paging out
• perfmon
• performance
• performance monitoring
• public
• ratio
• security
• server state
• sql server
• sysmon
• temp tables
• tempdb
• users
• verison
• view
• windows
• worker threads
• 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 error: messages are appearing when the working set of SQL Server 2005 process reaches 50 percent of the memory that is committed to the process.
07 March 08 03:54 AM | SQL Master | 2 Comments   

Have you seen the above message within the SQL Server error logs? If not then no need to worry and make sure to continue your performance monitoring tasks. So when to be concerned! It is evident that SQL Server 2005 component handles memory differently Read More...

Filed under: performance, sql server, dmv, memory, windows, awe, monitoring, worker threads, 2005, 2000, paging out, 64 bit, verison, buffers

SQL Server 2005: Deny Server-Level Dynamic Management Views to public group
21 December 07 06:47 AM | SQL Master | 2 Comments   

As you are aware DMV - Dynamic management views are very good to provide server-level information and some of them with detailed information on the execution environment of the database engine. Just to introduce about DMVs, there are two types of dynamic Read More...

Filed under: performance, sql server, security, package, dmv, users, view, best practice, monitoring, public, server state