SQL Server Profiler New Templates Failing

Source of info: http://www.mattbutton.com/2011/06/01/sql-profiler-templates-missing/

Upon trying to create a trace template in SQL Server Profiler, I was able to name the trace but there were no events to choose from in the “Events Selection” tab, even when the “Show All Events” box was checked.  If I clicked the “Column Filters” button the entire Profiler application would close itself without displaying any error message… just… gone.

The problem here was that I was running Microsoft SQL Server Management Studio 10.0.5500.0 against a SQL Server 10.50.2500.0 instance.  It just cannot seem to figure out what to do, so it does what any logical program would do.  It disappears.

The fix is to make a new folder called 1050 so that you have a path like this:

C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Profiler\Templates\Microsoft SQL Server\1050 

In the 1050 folder you can place your Profiler trace templates (tdf) files.  You can copy them from the “100” folder and they work just fine in the “1050” folder.

It does not appear that you can edit or create new templates directly into “Microsoft SQL Server 10.50” format, but if you create them in “Microsoft SQL Server 2008” format then you can move them into the 1050 folder (referenced above) to be used on 10.50 instances.

To create a new Microsoft SQL Server 2008 template, within SQL Server Profiles, go to:

File ->Templates ->New

At “Select Server Type”, choose “Microsoft SQL Server 2008”.

This site uses Akismet to reduce spam. Learn how your comment data is processed.