How to run Profiler from another server in 7.0

  • zxmgh

    SSC Eights!

    Points: 911

    Hi, All:

    I plan to run Profiler to monitor the SQL transactions of a SQL Server 7.0 server, but I try to minimize the performance interference, so I kicked off the Profiler on another SQL Server 7.0 server (we don't have SQL 2000), but I found that even though I choose to monitor the server I want, it actually monitor the local server. I never had this kind of problem in SQL 2000, is it a limitation of SQL Server 7.0, if so, is there a workaround?

    Thanks a lot!

    John

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 715889

    Just tried it here using one SQL 7 server to profile another. You need to be sure when you create the trace that you change the server name on the first tab.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

    The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

    http://www.dkranch.net

  • zxmgh

    SSC Eights!

    Points: 911

    Correct me if you think I did something wrong here:

    1. In the menu, go File -> New -> Trace...

    2. The "Trace Properties" windows appears, clicke "General" tag page.

    3. In the middle of the "General" tag page, there is a section:

    "A trace allows you to record events generated by a SQL Server. Select the SQL Server to run trace on."

    I choose "<New server>"

    4. Input the server information I wants to monitor

    5. In "Data Columns" tag, add "Server Name" column, so I know I am monitoring the correct server.

    6. Accept other default options, click OK, then the trace runs automatically

    I saw the local server name in the "Server Name" column, and I can easily judge that the transactions I got are applications run on the local server.

    Are you sure both your servers are SQL SERVER 7.0?

    Thanks

    John

  • zxmgh

    SSC Eights!

    Points: 911

    OK, here are what I found out.

    1. Even I choose the remote server as the "default server" in the Tools -> Options, it still doesn't work.

    2. I tried to pick off the trace on a PC which only has Tools installed, no database, I successfully get the transactions from the server I want. What's going on?! Is this a bug?

    John

  • zxmgh

    SSC Eights!

    Points: 911

    Can anyone answer this question? Sorry but it is very urgent, because of license problem, I can't install the tool itself on a PC. I am waiting online. Thanks a lot!

  • David Burrows

    SSC Guru

    Points: 64521

    What SP are you on?

    If you are on SP3 and have registered more than one SQL Server then refer to

    http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q284/3/51.ASP&NoWebContent=1

    Far away is close at hand in the images of elsewhere.
    Anon.

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply