Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Application server statistics, also has D, H, W, and M summary levels.

Column NameColumn Description
SPRS_PWII_INSTANCE_IDThe instance ID.
SPRS_TIMESTAMPThe time of the host samples, aligned to five minutes.
SPRS_RECEIVED_TIMESTAMPThe received timestamp.
SPRS_MINUTES_COUNT_SUMThe minutes count.
SPRS_PWHG_IDThe hour group in the PW.
SPRS_APPSVR_KEYThe sampled application server ID.
SPRS_HOST_KEYThe host machine ID, on which the application server is installed.
SPRS_RECORD_COUNT_SUMTotal number of samples made to the application server in the specified time.
SPRS_USERS_AVGAverage number of connected users.
SPRS_SESSION_COUNT_AVGAverage sessions number.
SPRS_ACTIVE_USER_COUNT_AVGAverage number of active users in five minutes.
SPRS_ROLL_AREA_TOTAL_AVGTotal size of roll area, in KB.
SPRS_ROLL_AREA_IN_USE_AVGAverage size of used roll area, in KB.
SPRS_EXTEND_MEMORY_TOTAL_AVG
SPRS_EXTEND_MEMORY_IN_USE
SPRS_SELECT_SINGLE_COUNT_AVG
SPRS_SELECT_COUNT_AVG
SPRS_SCREEN_HIT_RATIO_AVG
SPRS_SELECT_HIT_RATIO_AVG
SPRS_PROGRAM_HIT_RATIO_AVG
SPRS_SCREEN_HIT_RATIO_AVG







Scroll Ignore
scroll-pdftrue
scroll-officetrue
scroll-chmtrue
scroll-docbooktrue
scroll-eclipsehelptrue
scroll-epubtrue
scroll-htmltrue
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/precise/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse