SQL SERVER – Introduction to Performance Monitor – How to Use Perfmon

Yesterday I wrote about SQL SERVER – Introduction to Three Important Performance Counters. I received few questions about how to use Perfmon. Here is very brief introduction to Perfmon.

There are three ways to launch Perfmon.

1) Type “start perfmon” at the command prompt.

2) Go to Start | Programs | Administrative Tools | Performance Monitor.

3) Go to Start | Run | Perfmon.

Follow the images which explains how to use Perfmon and add different counters.

SQL SERVER - Introduction to Performance Monitor - How to Use Perfmon perfmon

SQL SERVER - Introduction to Performance Monitor - How to Use Perfmon perfmon1

Right click to bring up Add Counters Menu.

SQL SERVER - Introduction to Performance Monitor - How to Use Perfmon perfmon2

SQL SERVER - Introduction to Performance Monitor - How to Use Perfmon perfmon3

Reference : Pinal Dave (https://blog.sqlauthority.com)

Previous Post
SQL SERVER – Introduction to Three Important Performance Counters
Next Post
SQL SERVER – Index Reorganize or Index Rebuild

Related Posts

9 Comments. Leave new

  • HI Pinal,

    I am having problems with actually writing this to a database via a DSN using SQL Authentication to a SQL 2005 express. Testing the DSN I connect no problem, but when running the Perfmon, it says that the SQL login fails due to the fact that it’s “not associated with a trusted SQL Server connection”. This seems to be some kind of error and researching the net did not divvy up much. What’s your opinion?
    Thanks for the help

    Reply
  • I’m having the trusted issue as well. Not on all machines, can’t figure it out.

    Reply
  • In response to Jeff and Drikus I was wondering if they’d checked to see what account their Perfmon counters are running under. If it’s running as default then that might explain why they’re not writing to SQL. Try using a service account that has the necessary permissions to run Perfmon counters and write to the database and that should work

    Reply
  • Hi pinaldave,

    Is there any way to monitor a SQL server status using this performance counters through C++ or Java code.Plzz give me some idea regarding this.I want to monitor not only the sql server running on my system but also remote sql servers.

    I got some sample codes which is done using ASP.Net.But am not sure whether it is possible in C++/java..

    Thanks in Advance..

    Malar

    Reply
  • Hi Pinaldave,

    I want to create my own charts based on permonce.

    Please help me in determining which classes which i should use..

    thanks

    Sachin

    Reply
  • Hi,

    Thanks, it’s a very interesting arcticle and well written. I found a few, but yours is the best as it’s short and to the point!

    This greatly assisted me in monitoring a clients sql server as per their request, but they have one other request, strange as it seems, it makes perfect sense. They have a small network of 5 computers, one of which is a server running Windows Server 2003 and SQL Server 2008. Their network has a domain, but they have simple logins and passwords, as they are only used for processing data on the sql server.

    The problem is that even though everyone has their own sql login, and there is an activity log, we cannot stop people from logging in via windows authentication if they wish to do damage.

    Is there any way to have a performance monitor that reports (e.g. net send or email) anyone logging into sql server via windows authentication, failing that is there any way to disable windows authentication, or stop them from running scripts?

    Thanks

    Reply
  • Girijesh Pandey
    November 9, 2012 4:12 pm

    Nice post!!!

    Reply

Leave a Reply