% Processor Process(w3wp) The ADS runs within its own w2wp process, and it will Time be obvious which w2wp process this is as it will be getting the bulk of the CPU time. Avg. Disk PhysicalDisk(_Total) Watch for excessive disk writing due to logging. Queue Length % Processor Process(ReportingServicesService) Reports are handled by SQL Server Reporting Time Services. If an excessive number of reports are being run, or reports are very complex, then the CPU and Private Bytes for this process will be high. Private Bytes Process(w3wp) Access Services caches the results of queries in memory, until the user’s session expires (the timeout for which is configurable). If a large amount of data is being processed through the ADS, then memory consumption for the ADS’ w3wp will rise. Private Bytes Process(ReportingSrevicesService) Reports are handled by SQL Server Reporting Services. If an excessive number of reports are being run, or reports are very complex, then the CPU and Private Bytes for this process will be high. SQL Server The following table shows performance counters and processes to monitor for database servers in your farm. Performance Apply to object Notes counter % Processor Processor(_Total) Shows the percentage of elapsed time that this thread used the time processor to execute instructions. Process(sqlservr) % Processor Average values greater than 80 percent indicate that processor Time capacity on the database server is insufficient. Private Bytes Process(sqlservr) Shows the average amount of memory being consumed by SQL Server PhysicalDisk(_Total) Avg. Disk Shows the average disk queue length – database requests waiting Queue Length to be committed to disk. This is often a good indicator that the instance of SQL Server is becoming overloaded, and that possibly additional disk spindles would help to distribute the load.
% Processor Time Process(w3wp) The ADS runs within its own w2wp process, and it will be obvious which w2wp process this is as it will be getting the bulk of the CPU time. Avg. Disk Queue Length PhysicalDisk(_Total) Watch for excessive disk writing due to logging. % Processor Time Process(ReportingServicesService) Reports are handled by SQL Server Reporting Services. If an excessive number of reports are being run, or reports are very complex, then the CPU and Private Bytes for this process will be high. Private Bytes Process(w3wp) Access Services caches the results of queries in memory, until the user’s session expires (the timeout for which is configurable). If a large amount of data is being processed through the ADS, then memory consumption for the ADS’ w3wp will rise. Private Bytes Process(ReportingSrevicesService) Reports are handled by SQL Server Reporting Services. If an excessive number of reports are being run, or reports are very complex, then the CPU and Private Bytes for this process will be high. SQL Server The following table shows performance counters and processes to monitor for database servers in your farm. Performance counter Apply to object Notes % Processor time Processor(_Total) Shows the percentage of elapsed time that this thread used the processor to execute instructions. % Processor Time Process(sqlservr) Average values greater than 80 percent indicate that processor capacity on the database server is insufficient. Private Bytes Process(sqlservr) Shows the average amount of memory being consumed by SQL Server Avg. Disk Queue Length PhysicalDisk(_Total) Shows the average disk queue length – database requests waiting to be committed to disk. This is often a good indicator that the instance of SQL Server is becoming overloaded, and that possibly additional disk spindles would help to distribute the load.