Post reply

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

  • 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 Profiler 10.0.1600.22

    Microsoft Data Access Components (MDAC) 6.1.7600.16385

    Microsoft MSXML 3.0 4.0 5.0 6.0

    Microsoft Internet Explorer 8.0.7600.16385

    Microsoft .NET Framework 2.0.50727.4952

    Operating System 6.1.7600

  • September 1, 2010 at 10:57 am

    #1215162

    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.

  • September 2, 2010 at 6:59 am

    #1215564

    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.

  • September 30, 2010 at 8:32 am

    #1229660

    Hi,

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

    Thanks

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

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