SQL Profiler Templates Missing - additional repair steps?
I have the issue where SQL Profiler Templates are not being found, I am using an install of SQL Server Profiler 10.0.1600.22, and I am connecting to 2008 R2 remotely.
So I am aware of the "fix" whereby you can copy the templates folder from 100 to 1050 in the same directory. ie. http://www.mattbutton.com/2011/06/01/sql-profiler-templates-missing/
But this is still not showing my templates in SQL Server Profiler.
What additional steps can I take to restore the default templates?
Do I need to copy the templates from the Machine SQL Server is installed on to my computer?
The folder "trick" only works if you have the higher version installed and you are trying to connect to a lower one. Profiler v.110 will not look for v.120 folder, just like version 100 (SQL Server 2008) will not look for anything above itself (it has no way of knowing that there might be a template or two in the future 1050 folder).
Once you've installed the 2008 R2 version, everything falls in place.
The image attached is showing you how the valid situation should look like - version in the file path is the highest one:
- Is there a way to filter a SQL Profiler trace?
- SQL Profiler CPU / duration units
- Running SQL Profiler in the background
- EF Core query is extremely slow. How do I improve it?
- Why is Azure Data Studio Profiler not capturing stored procedures with large input data?
- SQL Server Profiler deprecation - Replacement?
- SQL Server Profiler - Why are some calls RPC:Completed and Some Calls SQL:BatchCompleted
- What does "exec sp_reset_connection" mean in Sql Server Profiler?
- What is "Audit Logout" in SQL Server Profiler?
- SQL Server Profiler - how do I find which database is being connected?
- Data disappearing from SQL Server Database
- SQL Server Profiler - How to filter trace to only display events from one database?
- How to customize the SQL Server connection ApplicationName property in Nhibernate for profiling
- How to profile Entity Framework activity against SQL Server?
- SQL Server Profiler: How to inspect/understand the duration for the Audit Logout event in more detail?
- SQL Server Profiler Not Like Filter
- SSMS - How to Provide/Edit/Send In "RequestParameters" With a MDX Query
- filetable_updates table in SQL Server Profiler
- Why does SQL Server Profiler trace skip records?
- Unable to read trace definition file Microsoft Analysis Services TraceDefinition 12.0.5553 when running SQL Server profiler
- Is there a Microsoft SQL Profiler equivalent for Oracle
- How to dump an output from SQL Server Profiler 2008 to a CSV-like file
- How to use SQL Server Profiler with an Azure SQL Server with AAD integrated security where AAD user is different from logged in desktop account?
- SQL Server profiler shows stored procedure being called but is not actually executed
- SQL Server Profiler vs COALESCE (SP:STMTCOMPLETED)
- Is there a way in SQL profiler to filter by 'TextData' filter with OR conditions for multiple text criteria?
- Show only queries made by EF in SQL Profiler
- How initial startup for NHibernate Profiler
- SQL Server Profiler trace different result on different system for same query
- SQL Server: Event does not reference any tables (Tuning Advisor warning)