SQL Server Performance

Using Performance Monitor to log data

Discussion in 'Performance Tuning for DBAs' started by silktaiji, Sep 6, 2005.

  1. silktaiji New Member

    I wanted to use Performance Monitor to log data and selected 8 counters that I wanted to monitor. I saved the log file as .csv in C:perfLogs. But, when I viewed the csv file, it only showed 6 counters recorded in the file. If I increased the counters to 10 or more, it still recorded only 6 counters.

    Does anyone know what may have caused this issue?

    Thanks,
    Ben
  2. Luis Martin Moderator

    Could you post what counters do you trace and what counters are in csv?.

    Never see something like your problem.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


    All postings are provided “AS IS” with no warranties for accuracy.



  3. brimba New Member

    Did you try to log data from other servers?
  4. satya Moderator

  5. silktaiji New Member

    These are what I tried to gather:

    MemoryAvailable Bytes
    MemoryPages/sec
    SQL Server Buffer: Buffer Cache Hit Ratio
    SQL Server General: User Connections
    PhysicalDisk(_Total)% Disk Time
    PhysicalDisk(_Total)Avg. Disk Queue Length
    Processor(_Total)% Processor Time
    SystemProcessor Queue Length

    But only 6 counters recorded in the csv file:

    MemoryAvailable Bytes
    MemoryPages/sec
    PhysicalDisk(_Total)% Disk Time
    PhysicalDisk(_Total)Avg. Disk Queue Length
    Processor(_Total)% Processor Time
    SystemProcessor Queue Length

    I ran this from my desktop (SQL Server client installed) connecting to the NT server where SQL Server 2000 Enterprise edition is running. But, I can get all counters recorded in the file if I run it directly on the server.
  6. deepakontheweb New Member

    I am not sure, but if you have both server and client in same domain then logon on client using same domain id that is being used for server logon.
    OR
    try to add your client network logon id on server's administrtor group.

    server: sql production server.
    client : your desktop where from you are running perfmon trace.

    I guess you at present you would not be able to get data for any SQL Server related counter, are you?

    Deepak Kumar

    --An eye for an eye and everyone shall be blind
  7. silktaiji New Member

    Yes. You are right. I cannot gather data for any SQL Server related counters.

    I'm a member of the server admin group, and I use the same logins (under AD domain) for NT and SQL Server (windows authentication login).
  8. Luis Martin Moderator

    But when you add counters you see all of them?


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


    All postings are provided “AS IS” with no warranties for accuracy.



  9. silktaiji New Member

    Yes. I see all of them.
  10. Luis Martin Moderator

    Can you try from other PC?. Just to find out if problems came from server or PC.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


    All postings are provided “AS IS” with no warranties for accuracy.



  11. satya Moderator

Share This Page