SQL Server Performance

Import Performance Data...

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by rotsey, May 10, 2007.

  1. rotsey New Member

    Hi,

    I am using SQL Profiler for SQL 2005.

    I have opened a trace file and i want to import a performance data
    file but the "Import Performance Data..." menu option is disabled.

    Any one know why??

    I googled but not a single reference found.

    I cannot even find a reference to the profiler from the help menu.

    rotsey
  2. satya Moderator

    How can you do this?
    Well, things are easier than you would think: just collect your data in SQL Profiler and in System Monitor how you usually do.

    Just make sure to collect the data for the same period of time.
    Then, open your trace in SQL Server Profiler and, always from SQL server Profiler, open the counter data you've retrieved with System Monitor (File - Import Performance Data).



    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. rotsey New Member

    hey satya did you read my post

    the Import Performance Data menu option in SQL Profiler is DISABLED DISABLED DISABLED DISABLED DISABLED.

    any further help would be appreciated.

    rotsey

  4. satya Moderator

    Have you read my post [<img src='/community/emoticons/emotion-1.gif' alt=':)' />] <b>Just make sure to collect the data for the same period of time</b> and in this case have you collected the PERFMON trace.<br /><br />Also confirm you have relevant privileges on this server.<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. rotsey New Member

    Satya

    What I have have done is ran a sql profiler trace on the same server as the tool.

    Also at the same time about 1 minute later started a performance monitor log also on the
    same server.

    Then I stopped both.

    Then I opened the trace file in SQL Profiler.

    Then I went to the file menu but the "Import Performance Data" was disabled.

    Is that the correct procedure??

    rotsey

  6. satya Moderator

    Have you saved both the traces?

    If you want to correlate Perf Mon events with Profiler you will need to do this from SAVED Profiler Traces and PerfMon logs. Real-time analysis is not supported. Ensure you that you have run these on the same machine & make sure that the machines are in sync in terms of time.


    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.
  7. MohammedU New Member

  8. Luis Martin Moderator

    The problem is this:

    1) After run perform you have to save data in a file.
    2) Close perform. Open again. Load the trace.
    3) The starttime and endtime columns must be in the trace.
    4) The monitor log must be saved binary.






    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


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



  9. rotsey New Member

    ok thanks all for help<br /><br />it must have been the fact that i was not using a SAVED trace file.<br />[<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br />
  10. satya Moderator

    [<img src='/community/emoticons/emotion-1.gif' alt=':)' />] see that is what I've bolded above, the trace must be at same time and no realtime is alowed.<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>
  11. Luis Martin Moderator

    To me this one:
    2) Close perform. Open again. Load the trace.

    is a bug.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


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



  12. satya Moderator

    I believe to open up the saved trace you have to perfom in that way.

    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.

Share This Page