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.

Right click to bring up Add Counters Menu.

Reference : Pinal Dave (http://blog.SQLAuthority.com)

9 thoughts on “SQL SERVER – Introduction to Performance Monitor – How to Use Perfmon

  1. Pingback: SQL SERVER - Introduction to Three Important Performance Counters Journey to SQL Authority with Pinal Dave

  2. 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

    Like

  3. 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

    Like

  4. 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

    Like

  5. 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

    Like

  6. 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

    Like

  7. Pingback: SQL SERVER – Weekly Series – Memory Lane – #016 « SQL Server Journey with SQL Authority

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s