Hello,
I've been playing with the PS Server Management Console and noted this under SQL performance:
- CacheName:LB_KFxxxx, Test Sql:select top 1 * from sysobjects, Time Consuming(ms):22, Expect time-consuming(ms):30
- CacheName:LB_Rexxx, Test Sql:select top 1 * from sysobjects, Time Consuming(ms):11, Expect time-consuming(ms):30
- CacheName:LB_Maxxx, Test Sql:select top 1 * from sysobjects, Time Consuming(ms):10, Expect time-consuming(ms):30
- CacheName:LB_Koxxx, Test Sql:select top 1 * from sysobjects, Time Consuming(ms):12, Expect time-consuming(ms):30
So, it's saying these tests took bewteen 10 and 22 ms. It seems to be saying this is too slow?
The expect time-consuming is saying that if the connection is slow it would take 30? So what would be a "normaol/good" speed?
Right now the 2 server are not on the same LAN. They are ec2 servers communicating through public IPs.
Thanks.