Re: remote query
From: Hari (hari_prasad_k_at_hotmail.com)
Date: 05/04/04
- Next message: Ronald James: "alerting for severity levels and not through SQL Alerts"
- Previous message: Michael, Cheng [MSFT]: "RE: SQL Agent Jobs Hang in Executing State"
- In reply to: Ricardo De Val Borges: "remote query"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 4 May 2004 08:38:01 +0530
Hi,
Did you meant tuning the "Query" in remote server (linked server). If is the
case then the tuning remains the same as local server query tuning. Connect
to the remote machine using Query analyzer . How to do that:-
1. Using client network utility create an alias name for the remote server
using the ip and port number
2. Connect to remote server using query analyzer selecting the Alias
created, user name and password
3. Open the query and execute using "Execution Plan'
4. Check query is using the indexes
5. Check query is written in optimized way
Thanks
Hari
MCDBA
"Ricardo De Val Borges" <rdeval@pop.com.br> wrote in message
news:#4kwFxTMEHA.3380@TK2MSFTNGP11.phx.gbl...
> Hi ,
>
> Somebody know how to optimize a remote query??
>
>
- Next message: Ronald James: "alerting for severity levels and not through SQL Alerts"
- Previous message: Michael, Cheng [MSFT]: "RE: SQL Agent Jobs Hang in Executing State"
- In reply to: Ricardo De Val Borges: "remote query"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
