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

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.

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.

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.

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.

Where is the article?.

I was trying to recommended in this posthttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=21371



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.

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.

Yes, this one:

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



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.