Solved

Perfmon question

Posted on 2016-08-19
1
61 Views
Last Modified: 2016-08-19
Just tried perfmon for the first time.

I used a basic collector set template and a bunch of xml files were created.  
I then opened the xml files with performance counter.  it seems to be operational.

there are a ton of counters that were in the graph.
can anyone tell me what counters to add to a customized collector set that will show me the basic metrics I need to pinpoint most server related issues.... There are just a lot of counters in the provided templates.
I'd obviously like to know....   proc, ram, disk io... and identify if these are not up to the task of the  apps running on the server.
bonus... can I pinpoint the application that is spiking server resource usage with a collector set?

extra bonus bonus.... I'd also like some recommended performance counters for a sql server and web server.
0
Comment
Question by:jamesmetcalf74
1 Comment
 
LVL 37

Accepted Solution

by:
bbao earned 500 total points
ID: 41762664
here you go:

How to monitor Web server performance by using counter logs in System Monitor in IIS
https://support.microsoft.com/en-us/kb/313064

Top 10 SQL Server Counters for Monitoring SQL Server Performance
http://www.databasejournal.com/features/mssql/article.php/3932406/Top-10-SQL-Server-Counters-for-Monitoring-SQL-Server-Performance.htm
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
OfficeMate Freezes on login or does not load after login credentials are input.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question