public SqlConnectionStatistics ReadData()
{
var dataProvider = new PerfCounterValueProvider();
var workerInstanceName = GetWorkerInstanceName(ProcessId, PerfCounterCategory.SqlServerDataProvider);
NumberOfActiveConnectionPools = Convert.ToInt32(
dataProvider.GetValue(CounterCategory, AdoNetCounter.NumberOfActiveConnectionPools.GetDescription(), workerInstanceName));
NumberOfInactiveConnectionPools = Convert.ToInt32(
dataProvider.GetValue(CounterCategory, AdoNetCounter.NumberOfInactiveConnectionPools.GetDescription(), workerInstanceName));
NumberOfPooledConnections = Convert.ToInt32(
dataProvider.GetValue(CounterCategory, AdoNetCounter.NumberOfPooledConnections.GetDescription(), workerInstanceName));
NumberOfNonPooledConnections = Convert.ToInt32(
dataProvider.GetValue(CounterCategory, AdoNetCounter.NumberOfNonPooledConnections.GetDescription(), workerInstanceName));
NumberOfActiveConnections = Convert.ToInt32(
dataProvider.GetValue(CounterCategory, AdoNetCounter.NumberOfActiveConnections.GetDescription(), workerInstanceName));
NumberOfFreeConnections = Convert.ToInt32(
dataProvider.GetValue(CounterCategory, AdoNetCounter.NumberOfFreeConnections.GetDescription(), workerInstanceName));
NumberOfReclaimedConnections = Convert.ToInt32(
dataProvider.GetValue(CounterCategory, AdoNetCounter.NumberOfReclaimedConnections.GetDescription(), workerInstanceName));
SoftConnectsPerSecond = Convert.ToInt32(
dataProvider.GetValue(CounterCategory, AdoNetCounter.SoftConnectsPerSecond.GetDescription(), workerInstanceName));
SoftDisconnectsPerSecond = Convert.ToInt32(
dataProvider.GetValue(CounterCategory, AdoNetCounter.SoftDisconnectsPerSecond.GetDescription(), workerInstanceName));
return(this);
}
/// <summary>
/// Reads data from performance counters
/// </summary>
/// <returns>Returns statistics for web application.</returns>
public ApplicationStatistics ReadData()
{
var dataProvider = new PerfCounterValueProvider();
RequestsPerSecond = Convert.ToInt32(
dataProvider.GetValue(PerfCounterCategory.AspNetApplications, AspNetAppCounter.RequestsPerSecond.GetDescription(), WorkerInstanceName));
TotalRequests = Convert.ToInt32(
dataProvider.GetValue(PerfCounterCategory.AspNetApplications, AspNetAppCounter.TotalRequests.GetDescription(), WorkerInstanceName));
return(this);
}
