Rudy Rodarte . com

Information

This article was written on 15 Aug 2011, and is filled under SQL Blogs.

Current post is tagged

, , ,

Find your SQL Server Profiler Template Path

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

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

  • Gracias,
    Buen aporte

  • Hey, man! Haven’t seen you since SQL Sat Austin (and I can’t remember which year). Anyhow, this came in handy as heck today, so much appreciated!

  • Indeed. I should be at SQL Saturday San Antonio and SQL Saturday OKC this year. Hope to see you then!