| Query slowness [message #313215] |
Fri, 11 April 2008 01:44  |
ap_karthi
Messages: 87
Registered: October 2007
Location: Bangalore
|
Member |
|
|
One Scenario :
1. Database in Remote place.
2. Five machines connected thro' router to DB.
3. Another 3 machines connected thro' router to DB.
4. Total 8 machines located in same place and connected to same DB.
5. Its taking more time to Query (3 machines) and another 5 machines are quite fine.
What could be the reason? Network guys are telling the network is fine.
|
|
|
|
| Re: Query slowness [message #313232 is a reply to message #313215] |
Fri, 11 April 2008 02:57  |
 |
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Don't trust network guy and activate trace in each session execute the same thing and see the network waits in the trace files.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
