Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rajkumarrai_bis
Yak Posting Veteran
78 Posts |
 Posted - 2007-11-09 : 10:33:01
|
| I am running a trace and one of the columns is start timeI want to import corresponding performance log data in the profilerIt is a new feature in 2005however this option is disabled in the profilerthis option is atFile -> Import performance DataPlease advice on how to enable this optionthanks in advance |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
rajkumarrai_bis
Yak Posting Veteran
78 Posts |
Posted - 2007-12-18 : 02:12:36
|
| I am sorry for being so late.my apologiesactually following option remains disabledSQL Profiler -> File -> Import performance Datathat's the problemmay be i am missing some settingplease help |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-12-18 : 03:43:08
|
| you have to import the trace file first.then the perfmon log files._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
Hariarul
Posting Yak Master
160 Posts |
Posted - 2007-12-18 : 06:00:39
|
| This link would be really good to refer.http://decipherinfosys.wordpress.com/2007/02/22/profiler-and-perfmon-co-relation-in-sql-server-2005/ |
|
|
|
rajkumarrai_bis
Yak Posting Veteran
78 Posts |
Posted - 2007-12-22 : 06:02:06
|
| thanks to all of you for your helpIt is working nowI was missing following point"cannot open up the co-relation with perfmon till you save a profiler trace and then load it back up"This really is a great feature |
|
|
|
|
|
|
How to import performance log data in profiler