New Profiler Trace - but there are no Events listed in the UI

Question

New Profiler Trace - but there are no Events listed in the UI

Alex-815008

Mr or Mrs. 500

Points: 510
More actions
September 1, 2010 at 4:56 am

#223292

Within SQL Server Profiler I click on File | Templates | New Template.
The "Select Server Type" drop down defaults to "Microsoft SQL Server 10.50"
When I click on the "Events Selection" tab, I get no events; i.e. I see the white grid box and it has just one column header called "Events" but no other columns and no rows at all ... just a plain white box.
"Show all events" and "Show all columns" are both ticked (tried ticking/unticking - makes no difference).
Going back to the "General" tab, if I change the server type to "Microsoft SQL Server 2008" and then click on the "Events Selection" tab then I get a long list of events.
I've checked the files in C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Profiler\TraceDefinitions after reading a post on another site that came back as a result of a google search. In here I have:-
C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Profiler\TraceDefinitions>
dir /b
1033
Microsoft Analysis Services TraceDefinition 10.0.0.xml
Microsoft Analysis Services TraceDefinition 9.0.0.xml
Microsoft Data Transformation Services TraceDefinition 10.0.0.xml
Microsoft Data Transformation Services TraceDefinition 9.0.0.xml
Microsoft SQL Server TraceDefinition 10.0.0.xml
Microsoft SQL Server TraceDefinition 10.50.1600.xml
Microsoft SQL Server TraceDefinition 7.0.0.xml
Microsoft SQL Server TraceDefinition 8.0.0.xml
Microsoft SQL Server TraceDefinition 9.0.0.xml
Microsoft SQL Server TraceDescriptions 10.0.0.xsd
Microsoft SQL Server TraceDescriptions 9.0.0.xsd
Perf Counters Correlation Engine TraceDefinition 10.0.0.xml
Perf Counters Correlation Engine TraceDefinition 9.0.0.xml
ProfilerSpecialEvents.XML.profiler
ProfilerSpecialEvents.XML.profiler.legacy
TraceXMLSchema.xsd
Profiler version info:-
SQL Server Profiler10.0.1600.22
Microsoft Data Access Components (MDAC)6.1.7600.16385
Microsoft MSXML3.0 4.0 5.0 6.0
Microsoft Internet Explorer8.0.7600.16385
Microsoft .NET Framework2.0.50727.4952
Operating System6.1.7600

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

tpaulsen SSC Enthusiast Points: 195 More actions · Answer 1

Somehow you are trying to use SQL 2008 profiler to run a profile against SQL 2008 R2. If you upgrade your Profiler to R2, you will be able to see events for a SQL 2008 R2 database. SQL 10.0.xxxx is 2008 and SQL 10.50.xxxx is 2008 R2.

Alex-815008 Mr or Mrs. 500 Points: 510 More actions · Answer 2

Awesome! I have just run the upgrade on my box and now Profiler is R2 and it all works perfectly!

Amazingly, we were actually able to use profiler (2008) against a 2008 R2 database with no problems ... it was just creating the templates that was weird. And even then, I created templates but they were not listed anywhere (i.e. I could see that the template was being applied if I had previously elected for that template to be the default).

Anyway, it all works well now.

sgirard 10189 SSC Journeyman Points: 79 More actions · Answer 3

Hi,

Can you please tell me where I can get the upgrade ?

Thanks