September 19, 2003 at 12:31 pm
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
September 19, 2003 at 2:31 pm
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
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 19, 2003 at 2:44 pm
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
September 19, 2003 at 3:02 pm
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
September 19, 2003 at 3:22 pm
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!
September 22, 2003 at 6:34 am
What SP are you on?
If you are on SP3 and have registered more than one SQL Server then refer to
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply