August 26, 2010 at 9:58 am
The default Server Activity - Performance Counters system collector captures the following perfmon counters every 60 seconds. I can only assume they are used in the Server Activity report.
Questions
- Does this seem rather excessive? as our Network admin guys said they will add considerable load on the DB server.
- Why measure LogicalDisk instead of physical disk?
thanks
Jag
\Memory \% Committed Bytes In Use
\Memory \Available Bytes
\Memory \Cache Bytes
\Memory \Cache Faults/sec
\Memory \Committed Bytes
\Memory \Free & Zero Page List Bytes
\Memory \Modified Page List Bytes
\Memory \Pages/sec
\Memory \Page Reads/sec
\Memory \Page Write/sec
\Memory \Page Faults/sec
\Memory \Pool Nonpaged Bytes
\Memory \Pool Paged Bytes
\Memory \Standby Cache Core Bytes
\Memory \Standby Cache Normal Priority Bytes
\Memory \Standby Cache Reserve Bytes
\Memory \Pool Paged Bytes
\Memory \Write Copies/sec
\Process(_Total) \*
\Process($(TARGETPROCESS)) \*
\Process(*) \Thread Count
\Process(*) \% Processor Time
\Process(*) \IO Read Bytes/sec
\Process(*) \IO Write Bytes/sec
\Process(*) \Private Bytes
\Process(*) \Working Set
\Processor(*) \% Processor Time
\Processor(*) \% User Time
\Processor(*) \% Privileged Time
\Server Work Queues(*) \Queue Length
\LogicalDisk(*) \% Disk Time
\LogicalDisk(*) \Avg. Disk Queue Length
\LogicalDisk(*) \Avg. Disk Read Queue Length
\LogicalDisk(*) \Avg. Disk Write Queue Length
\LogicalDisk(*) \Avg. Disk sec/Read
\LogicalDisk(*) \Avg. Disk sec/Write
\LogicalDisk(*) \Avg. Disk sec/Transfer
\LogicalDisk(*) \Disk Reads/sec
\LogicalDisk(*) \Disk Bytes/sec
\LogicalDisk(*) \Disk Writes/sec
\LogicalDisk(*) \Split IO/sec
\System \Processor Queue Length
\System \File Read Operations/sec
\System \File Write Operations/sec
\System \File Control Operations/sec
\System \File Read Bytes/sec
\System \File Write Bytes/sec
\System \File Control Bytes/sec
\Network Interface(*) \Bytes Total/sec
\Network Interface(*) \Output Queue Length
\$(INSTANCE):Buffer Manager \Stolen pages
\$(INSTANCE):Buffer Manager \Page life expectancy
\$(INSTANCE):Memory Manager \Memory Grants Outstanding
\$(INSTANCE):Memory Manager \Memory Grants Pending
\$(INSTANCE):Databases(_Total) \Transactions/sec
\$(INSTANCE):Databases(tempdb) \Transactions/sec
\$(INSTANCE):Databases(*) \Active Transactions
\$(INSTANCE):General Statistics \Logins/sec
\$(INSTANCE):General Statistics \Logouts/sec
\$(INSTANCE):General Statistics \User Connections
\$(INSTANCE):General Statistics \Logical Connections
\$(INSTANCE):General Statistics \Transactions
\$(INSTANCE):General Statistics \Processes blocked
\$(INSTANCE):General Statistics \Active Temp Tables
\$(INSTANCE):SQL Statistics \Batch Requests/sec
\$(INSTANCE):SQL Statistics \SQL Compilations/sec
\$(INSTANCE):SQL Statistics \SQL Re-Compilations/sec
\$(INSTANCE):SQL Statistics \SQL Attention rate
\$(INSTANCE):SQL Statistics \Auto-Param Attempts/sec
\$(INSTANCE):SQL Statistics \Failed Auto-Params/sec
\$(INSTANCE):Plan Cache(_Total) \Cache Hit Ratio
\$(INSTANCE):Plan Cache(Object Plans) \Cache Hit Ratio
\$(INSTANCE):Plan Cache(SQL Plans) \Cache Hit Ratio
\$(INSTANCE):Plan Cache(Temporary Tables & Table Variables) \Cache Hit Ratio
\$(INSTANCE):Transactions \Free Space in tempdb (KB)
\$(INSTANCE):Workload Group Stats(*) \Active requests
\$(INSTANCE):Workload Group Stats(*) \Blocked tasks
\$(INSTANCE):Workload Group Stats(*) \CPU usage %
August 26, 2010 at 1:53 pm
Anyone using Management Data Warehouse out there?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply