1. Shawn Davis
  2. PowerServer
  3. Friday, 28 April 2023 14:43 PM UTC

Hello,

I've been playing with the PS Server Management Console and noted this under SQL performance:

  1. CacheName:LB_KFxxxx, Test Sql:select top 1 * from sysobjects, Time Consuming(ms):22, Expect time-consuming(ms):30
  2. CacheName:LB_Rexxx, Test Sql:select top 1 * from sysobjects, Time Consuming(ms):11, Expect time-consuming(ms):30
  3. CacheName:LB_Maxxx, Test Sql:select top 1 * from sysobjects, Time Consuming(ms):10, Expect time-consuming(ms):30
  4. 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.

mike S Accepted Answer Pending Moderation
  1. Friday, 28 April 2023 18:35 PM UTC
  2. PowerServer
  3. # 1

i wouldn't use that as a sql performance tool.  you need database specific tools at the very least

Comment
  1. Shawn Davis
  2. Sunday, 30 April 2023 22:06 PM UTC
I'm not trying to use as SQL Server performance tool, just trying understand what it's saying.
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.