SQL Server Performance Forum – Threads Archive

Import Performance Data…

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

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.

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

Have you read my post [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] Just make sure to collect the data for the same period of time and in this case have you collected the PERFMON trace. Also confirm you have relevant privileges on this server. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided AS IS with no rights for the sake of 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.</center>

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

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.

Check the following… too…
http://www.sqlskills.com/blogs/kimb…tegrationAndABitMoreWithManagementStudio.aspx
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

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.

ok thanks all for help it must have been the fact that i was not using a SAVED trace file. [<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />]

[<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. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided AS IS with no rights for the sake of 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.</center>

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.

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.

]]>