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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.