Browse by Tags

• alerts
• analysis
• buffer
• cache
• counters
• databases
• dba
• dmv
• microsoft
• monitoring
• new feature
• perfmon
• performance
• performance monitoring
• profiler
• ratio
• recompile
• resource governor
• server
• sql server
• stored procedure
• temp tables
• tempdb
• tools
• tsql
• tuning
• utilization
• 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: PERFMON counters to identify server utilization data
18 June 08 05:21 AM | satyaskj | 2 Comments   

Recently I have been involved to carry over an assesment of server utilization on the SQL estate farm (nearly 150+) instances, as it stands it is not an easy job to obtain the results when you have no influence on accessing required information on a shared Read More...

Filed under: sql server, perfmon, sysmon, tools, utilization, counters

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: worktables, ratio, performance, sql server, cache, dmv, perfmon, buffer, sysmon, tempdb, monitoring, temp tables, workfiles

How to Analyze the PERFMON (SYSMON) data?
20 August 07 11:26 AM | SQL Master | 2 Comments   

As you may aware the PERFMON (SYSMON) utility provides much information to analyze on the systems resource usage, I support and suggest to make use of this tool as much as you can with a default templates within our environment. You may be aware the data Read More...

Filed under: tuning, performance, sql server, perfmon, databases, sysmon, tsql, analysis

SQL Server 2005 high CPU occurrence - why it is?
18 June 07 07:33 AM | SQL Master | 2 Comments   

If a particular query is performing poorly the first thing you would check is relevant indexes, even though having associated indexes against those tables may not help any better to the performance. The next phase you observe is high CPU count from the Read More...

Filed under: performance, profiler, sysmon, recompile, stored procedure

SYSMON (PERFMON) - how to move set of counter logs to another server?
13 June 07 06:45 AM | SQL Master | 1 Comments   

SYSMON (Perfmon) is a good tool for measuring performance or assess the system resources usage of a server or set of Windows servers. Using this GUI tool you can view the behavior of objects, such as processors, memory, cache, threads, and processes. Read More...

Filed under: sql server, perfmon, databases, sysmon, alerts

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