Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Perfmon question

Posted on 2016-08-19
1
Medium Priority
?
118 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 2000 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

926 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