get the the cpu usage percentage and io usage

  • i would like to write a job thet occur every one hour

    the script will write the state of the server

    what is the cpu usage in percentage and what is the io usage

    i whant to write all the important details for later generate a chars of

    what was the cpu use in every houer and io usage for every hour

    and if there is more important paramter i whant to monitor them as well

  • i found i can do it with perfmon

    still be intersting if it can done wite a sql job

  • Please don't cross post. It just wastes people's time and fragments replies

    No replies to this thread please. Direct replies to http://qa.sqlservercentral.com/Forums/Topic1039194-360-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply