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); }