Browse by Tags

All Tags » perfmon   (RSS)
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...
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...
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...
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...
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...
Stored procedures performance issues
08 May 07 03:57 AM | SQL Master | 0 Comments   
Every now and then I tend to see lot of questions such as "We have a web application which interacts with SQL Server through Stored Procs. Every so often it seems the response time for an individual Stored Proc will go from a few seconds to a few minutes. Read More...
Using PERFMON to get memory counters, what you need to check?
08 May 07 02:17 AM | SQL Master | 1 Comments   
Refer to AWE if you have enabled the AWE in thsi case. Another piece of advice is if this is not a dedicated SQL Server then make sure you have monitoring MemToLeave information too, as it manage the transaction log requirements. Refer to pages/sec counter Read More...