Class SqlStatistics

[Required(ErrorMessage = "AverageActiveSessions is required.")]
[JsonProperty(PropertyName = "averageActiveSessions")]
public double AverageActiveSessions { get; set; }

Property Value

Type	Description
double	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.

Remarks

Required

ChangeInAverageActiveSessionsInPct

Declaration

[Required(ErrorMessage = "ChangeInAverageActiveSessionsInPct is required.")]
[JsonProperty(PropertyName = "changeInAverageActiveSessionsInPct")]
public double ChangeInAverageActiveSessionsInPct { get; set; }

Property Value

Type	Description
double	Percent change in Average Active Sessions based on linear regression

Remarks

Required

ChangeInCpuTimeInPct

Declaration

[Required(ErrorMessage = "ChangeInCpuTimeInPct is required.")]
[JsonProperty(PropertyName = "changeInCpuTimeInPct")]
public double ChangeInCpuTimeInPct { get; set; }

Property Value

Type	Description
double	Percent change in CPU Time based on linear regression

Remarks

Required

ChangeInExecutionsPerHourInPct

Declaration

[Required(ErrorMessage = "ChangeInExecutionsPerHourInPct is required.")]
[JsonProperty(PropertyName = "changeInExecutionsPerHourInPct")]
public double ChangeInExecutionsPerHourInPct { get; set; }

Property Value

Type	Description
double	Percent change in Executions per hour based on linear regression

Remarks

Required

ChangeInInefficiencyInPct

Declaration

[Required(ErrorMessage = "ChangeInInefficiencyInPct is required.")]
[JsonProperty(PropertyName = "changeInInefficiencyInPct")]
public double ChangeInInefficiencyInPct { get; set; }

Property Value

Type	Description
double	Percent change in Inefficiency based on linear regression

Remarks

Required

ChangeInInefficientWaitTimeInPct

Declaration

[Required(ErrorMessage = "ChangeInInefficientWaitTimeInPct is required.")]
[JsonProperty(PropertyName = "changeInInefficientWaitTimeInPct")]
public double ChangeInInefficientWaitTimeInPct { get; set; }

Property Value

Type	Description
double	Percent change in Inefficient Wait Time based on linear regression

Remarks

Required

ChangeInIoTimeInPct

Declaration

[Required(ErrorMessage = "ChangeInIoTimeInPct is required.")]
[JsonProperty(PropertyName = "changeInIoTimeInPct")]
public double ChangeInIoTimeInPct { get; set; }

Property Value

Type	Description
double	Percent change in IO Time based on linear regression

Remarks

Required

ChangeInResponseTimeInPct

Declaration

[Required(ErrorMessage = "ChangeInResponseTimeInPct is required.")]
[JsonProperty(PropertyName = "changeInResponseTimeInPct")]
public double ChangeInResponseTimeInPct { get; set; }

Property Value

Type	Description
double	Percent change in Response Time based on linear regression

Remarks

Required

CpuTimeInSec

Declaration

[Required(ErrorMessage = "CpuTimeInSec is required.")]
[JsonProperty(PropertyName = "cpuTimeInSec")]
public double CpuTimeInSec { get; set; }

Property Value

Type	Description
double	CPU Time in seconds

Remarks

Required

DatabaseTimeInSec

Declaration

[Required(ErrorMessage = "DatabaseTimeInSec is required.")]
[JsonProperty(PropertyName = "databaseTimeInSec")]
public double DatabaseTimeInSec { get; set; }

Property Value

Type	Description
double	Database Time in seconds

Remarks

Required

DatabaseTimePct

Declaration

[Required(ErrorMessage = "DatabaseTimePct is required.")]
[JsonProperty(PropertyName = "databaseTimePct")]
public double DatabaseTimePct { get; set; }

Property Value

Type	Description
double	Percentage of Database Time

Remarks

Required

ExecutionsCount

Declaration

[Required(ErrorMessage = "ExecutionsCount is required.")]
[JsonProperty(PropertyName = "executionsCount")]
public long? ExecutionsCount { get; set; }

Property Value

Type	Description
long?	Total number of executions

Remarks

Required

ExecutionsPerHour

Declaration

[Required(ErrorMessage = "ExecutionsPerHour is required.")]
[JsonProperty(PropertyName = "executionsPerHour")]
public double ExecutionsPerHour { get; set; }

Property Value

Type	Description
double	Number of executions per hour

Remarks

Required

InefficiencyInPct

Declaration

[Required(ErrorMessage = "InefficiencyInPct is required.")]
[JsonProperty(PropertyName = "inefficiencyInPct")]
public double InefficiencyInPct { get; set; }

Property Value

Type	Description
double	Percentage of Inefficiency. It is calculated by Total Database Time divided by Total Wait Time

Remarks

Required

InefficientWaitTimeInSec

Declaration

[Required(ErrorMessage = "InefficientWaitTimeInSec is required.")]
[JsonProperty(PropertyName = "inefficientWaitTimeInSec")]
public double InefficientWaitTimeInSec { get; set; }

Property Value

Type	Description
double	Inefficient Wait Time in seconds

Remarks

Required

IoTimeInSec

Declaration

[Required(ErrorMessage = "IoTimeInSec is required.")]
[JsonProperty(PropertyName = "ioTimeInSec")]
public double IoTimeInSec { get; set; }

Property Value

Type	Description
double	I/O Time in seconds

Remarks

Required

PlanCount

Declaration

[Required(ErrorMessage = "PlanCount is required.")]
[JsonProperty(PropertyName = "planCount")]
public long? PlanCount { get; set; }

Property Value

Type	Description
long?	Number of SQL execution plans used by the SQL

Remarks

Required

ResponseTimeInSec

Declaration

[Required(ErrorMessage = "ResponseTimeInSec is required.")]
[JsonProperty(PropertyName = "responseTimeInSec")]
public double ResponseTimeInSec { get; set; }

Property Value

Type	Description
double	Response time is the average elaspsed time per execution. It is the ratio of Total Database Time to the number of executions

Remarks

Required

Variability

Declaration

[Required(ErrorMessage = "Variability is required.")]
[JsonProperty(PropertyName = "variability")]
public double Variability { get; set; }

Property Value

Type	Description
double	Variability is the ratio of the standard deviation in response time to the mean of response time of the SQL

Remarks

Required