I was brushing up on some SQL Server Perfmon and Profiler stuff over on BrentOzar.com. What I wanted to do was save the SQL Server Profiler template I created in my dropbox, so I could have access to it from all of my machines. The only problem is, I couldn’t find the template anywhere. Only after I did some digging, did I find the file here:

C:\Users\YourUserName\AppData\Roaming\Microsoft\SQL Profiler\10.0\Templates\Microsoft SQL Server\100\

The built in templates are found here:

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

As always, the exact location(90,100,110, etc) changes, depending on your version of SQL Server. But this should get you in the correct folder.


Rudy Rodarte is a SQL Server Database professional based in Austin, TX. Over his career, Rudy has worked with SSRS, SSIS, performance tuning troubleshooting. When away from Keyboard, Rudy goes to Spurs and Baylor Bear sporting events.

More Posts - Website - Twitter