Browse by Tags

• buffer
• cache
• dba
• microsoft
• monitoring
• new feature
• performance
• performance monitoring
• ratio
• resource governor
• server
• sql server
• sysmon
• temp tables
• tempdb
• workfiles
• worktables

SQL Server - PERFMON counters and Resource Governor - what you can do in a performance issue situation?
17 November 08 12:41 AM | SQL Master | 2 Comments   

PERFMON and Resource Governor - two great tools in hand for a DBA to monitor/resolve the performance problems, agreee! Back in olden days you may remember about SQLDiag and PSSDiag, the utility used as a general purpose diagnostics collection utility Read More...

Filed under: performance, sql server, dmv, perfmon, dba, sysmon, performance monitoring, new feature, resource governor

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

Get SYSMON counters using a TSQL query aka DMVs.
31 May 07 08:26 AM | SQL Master | 1 Comments   

SYSMON aka PERFMON is a best tool to find out the system resources usage on a Windows server, similarly SQL Server 2005 has list of such useful DMVs to get you more information on many of the SQL Server-related objects, instances and counters by using Read More...

Filed under: sql server, microsoft, server, dmv, perfmon, sysmon