Options
All
  • Public
  • Public/Protected
  • All
Menu

Namespace SqlStatistics

Performance statistics for the SQL.

Properties

averageActiveSessions

averageActiveSessions: number

Average Active Sessions represent the average active sessions at a point in time. It is the number of sessions that are either working or waiting. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

changeInAverageActiveSessionsInPct

changeInAverageActiveSessionsInPct: number

Percent change in Average Active Sessions based on linear regression Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

changeInCpuTimeInPct

changeInCpuTimeInPct: number

Percent change in CPU Time based on linear regression Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

changeInExecutionsPerHourInPct

changeInExecutionsPerHourInPct: number

Percent change in Executions per hour based on linear regression Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

changeInInefficiencyInPct

changeInInefficiencyInPct: number

Percent change in Inefficiency based on linear regression Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

changeInInefficientWaitTimeInPct

changeInInefficientWaitTimeInPct: number

Percent change in Inefficient Wait Time based on linear regression Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

changeInIoTimeInPct

changeInIoTimeInPct: number

Percent change in IO Time based on linear regression Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

changeInResponseTimeInPct

changeInResponseTimeInPct: number

Percent change in Response Time based on linear regression Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

cpuTimeInSec

cpuTimeInSec: number

CPU Time in seconds Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

databaseTimeInSec

databaseTimeInSec: number

Database Time in seconds Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

databaseTimePct

databaseTimePct: number

Percentage of Database Time Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

executionsCount

executionsCount: number

Total number of executions Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

executionsPerHour

executionsPerHour: number

Number of executions per hour Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

inefficiencyInPct

inefficiencyInPct: number

Percentage of Inefficiency. It is calculated by Total Database Time divided by Total Wait Time Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

inefficientWaitTimeInSec

inefficientWaitTimeInSec: number

Inefficient Wait Time in seconds Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

ioTimeInSec

ioTimeInSec: number

I/O Time in seconds Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

planCount

planCount: number

Number of SQL execution plans used by the SQL Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

responseTimeInSec

responseTimeInSec: number

Response time is the average elaspsed time per execution. It is the ratio of Total Database Time to the number of executions Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

variability

variability: number

Variability is the ratio of the standard deviation in response time to the mean of response time of the SQL Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Functions

getDeserializedJsonObj

getJsonObj