如何配置Perfmon(在Windows Server 2008上运行)直接登录到在另一台PC上运行的SQL Server 2003? [英] How do you configure Perfmon (running on Windows Server 2008) to log directly to a SQL Server 2003 running on a different PC?

问题描述

我有一台在Server 2008 OS上运行的Server PC.
我正在尝试将Perfmon设置为直接登录到SQL 2003 Server. SQL Server不是在本地运行，而是在单独的PC上.
我已经在Server 2008框中配置了ODBC DSN(我选择了SQL Server).
配置性能计数器日志时，如何选择SQL数据库作为发送性能文件的位置?

I have a Server PC running on Server 2008 OS.
I am trying to set up Perfmon to log directly to a SQL 2003 Server. The SQL server is NOT running locally -- it's on a separate PC.
I have already configured an ODBC DSN (I selected SQL Server) on the Server 2008 box. 
When configuring performance counter logs, how do I choose the SQL Database as the location to send the perfmon files?

推荐答案

创建用户定义的数据收集器集.

Create your User Definded Data collector set.

创建完成后，便会深入到数据收集器

Once you have created it drill down to the data collector

右键单击数据收集器，然后选择属性

Right click on the data collector and select properties

您会看到数据收集器的属性页面.

You see the properties page fo r the data collector.

在效果计数器"标签上.将日志格式切换为SQL.然后选择数据源名称.

On the Performance Counter tab.  Switch the log format to SQL.  Then select the Data source name.

Bruce Adamczak

Bruce Adamczak

 

这篇关于如何配置Perfmon(在Windows Server 2008上运行)直接登录到在另一台PC上运行的SQL Server 2003?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！