SQL Server Performance

7.0 Profiler Shows Only Local Server

Discussion in 'General DBA Questions' started by pdouglas, Jul 22, 2004.

  1. pdouglas New Member


    I was recently assigned to work on a system already in-place at my company. Nobody here has been using the SQL Server Profiler tool. I tried to use it and experienced this:

    I can use all of the tools except Profiler with remote servers - EM, QA, and Performance Monitor all allow me to query/monitor any of the three DB servers on our network. However, Profiler does not. I can select from the list of registered servers just fine, but no matter where I try this from, the trace only shows activity for the server on the same machine. It seems to be fine in all other aspects.

    We are running SQL Server 7.0 SP3, on NT Server 4.0 SP6.


Share This Page