December 25, 2010 at 3:18 am
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
December 25, 2010 at 4:18 am
i found i can do it with perfmon
still be intersting if it can done wite a sql job
January 5, 2011 at 1:57 am
Some extensive set of DMV's are present in below url to cover statistics of every part of hardware and sql server db, object level.
first create reporting tables for each dmv u like to trace.
you can write stored proc to load dmv result into reporting table
schedule the stored proc to run once in a hr.
hope this helps
January 7, 2011 at 12:21 am
interesting script
January 7, 2011 at 12:34 am
Roi,
Forgot to mention one point.
guess you know the fact that, most of the DMV statistics are cumulative, meaning you cant filter last 1 or 2 hr performance statistics from most of the dmv's.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply