sql-server-2008 - SQL Server 探查器 : Templates not showing/missing

Question

当我启动 SQL Server Profiler 并单击“运行”时，它显示“必须至少选择一个事件”。我发现这是由于模板为“空白”(并且没有其他选项)，并且我确信这里应该有一组默认值。

有人知道为什么他们会消失吗？以及如何让他们回来？

正在运行 Sql Server 2008。

谢谢

Answer 1

我已经设法解决了这个问题，我按照此链接的建议解决了它:

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

以下内容来自链接:

If you are connecting to a SQL server with the SQL profiler and none of your templates are showing up, compare the versions of the SQL profiler you are running and the version of SQL server that you’re connecting to; there is likely a version mismatch.

If this is the case, what’s likely happening here is that you’re connecting to a SQL 10.50 instance with a SQL 10.0 profiler and the profile templates for 10.50 aren’t present.

In the case of the profiler from SQL 2008 connecting to a SQL 2008 R2 instance, copy your 100 profile templates folder (default install is at C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Profiler\Templates\Microsoft SQL Server\100) into a new folder in the same location with the name “1050″ i.e. C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Profiler\Templates\Microsoft SQL Server\1050.

Then try to reconnect, and you’ll have access to the profile templates and everything will work fine.