SQL Server Performance

Perfmon Setting

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by dineshasanka, Jun 13, 2007.

  1. dineshasanka Moderator

    I have setup all the nessary counters on one server from perfmon.

    I need to do the same setting at some other server. How can I do this




    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  2. satya Moderator

    Simple, save that counter logs which is saved as .HTM.
    Copy that file to the server where you want these settings and Choose "New Log settings from...".. rest is yours.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  3. dineshasanka Moderator

    great thanks. small issue is still conter is pointing to the source server. Doesn't matter I can do a find replace

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  4. satya Moderator

    [<img src='/community/emoticons/emotion-1.gif' alt=':)' />] Tip: you can either open that HTML and use FIND/REPLACE with desired servername.<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</i></font id="size1"></font id="teal"></center>
  5. dineshasanka Moderator

    yeap , that is exactly what it did

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/

Share This Page