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.
