SQL Server Performance

How to correlate a SQL 2005 Profiler.....

Discussion in 'Performance-Related Article Discussions' started by Luis Martin, Apr 19, 2007.

  1. Luis Martin Moderator

    Before start, I was consulting with Brad about my problem and he suggest me to post it.

    I was working with:

    http://www.sql-server-performance.com/bm_correlate_trace_performance.asp.

    I have one server with 2000 (SP4) and 2005 (SP2). My notebook have SQL 2005 tools with SP2, also 2000 tools with SP4.

    Doing what Brad wrote, using 2005 Profiler with 2000 or 2005 server, the option "Import Performance Data" is not available. The option is there but in different color, so I can't reach it.

    Any idea would help.




    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.



  2. satya Moderator

    Have you tried accessing against SQL 2005 instance/

    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. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  3. Luis Martin Moderator

    Yes and with 2005 instance work fine.

    My mistake. I was thinking that this feature belong to Profiler 2005 and not to SQL Server version.



    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.



  4. Luis Martin Moderator

    Finally I find the problem.

    In any trace with Profiler 2005 (2000 or 2005 server) the columns starttime and endtime must be there.



    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.



  5. Luis Martin Moderator

  6. satya Moderator

    Which article you need to refer, have to suggested the Brad's article?

    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. Luis Martin Moderator

Share This Page