1 0 Generate a report detailing the status of local hardware resources, system response times, and processes on the local computer. Use this information to identify possible causes of performance issues. Membership in the local Administrators group, or equivalent, is the minimum required to run this Data Collector Set. Generate a report detailing the status of local hardware resources, system response times, and processes on the local computer. Use this information to identify possible causes of performance issues. Membership in the local Administrators group, or equivalent, is the minimum required to run this Data Collector Set. -1 CPU Memory Disk Network Performance D:\SQL_Trace\ SQLPerf D:\SQL_Trace\ D:\SQL_Trace -1 86400 0 7 1 0 SYSTEM O:BAG:DUD:AI(A;;FA;;;SY)(A;;FA;;;BA)(A;;FR;;;LU)(A;;0x1301ff;;;S-1-5-80-2661322625-712705077-2999183737-3043590567-590698655)(A;ID;FA;;;SY)(A;ID;FA;;;BA)(A;ID;0x1200ab;;;LU)(A;ID;FR;;;AU)(A;ID;FR;;;LS)(A;ID;FR;;;NS) 0 0 PAL_Microsoft_SQL_Server_2005_2008 SQLPAL 3 yyyyMMdd -1 0 0 D:\SQL_Trace\V700GV158_SQLPAL20120315.blg 15 0 3 \Cache\Dirty Pages \Cache\Lazy Write Flushes/sec \LogicalDisk(*)\% Free Space \LogicalDisk(*)\% Idle Time \LogicalDisk(*)\Avg. Disk Bytes/Read \LogicalDisk(*)\Avg. Disk Bytes/Write \LogicalDisk(*)\Avg. Disk Queue Length \LogicalDisk(*)\Avg. Disk sec/Read \LogicalDisk(*)\Avg. Disk sec/Write \LogicalDisk(*)\Current Disk Queue Length \LogicalDisk(*)\Disk Bytes/sec \LogicalDisk(*)\Disk Reads/sec \LogicalDisk(*)\Disk Transfers/sec \LogicalDisk(*)\Disk Writes/sec \LogicalDisk(*)\Free Megabytes \Memory\% Committed Bytes In Use \Memory\Available MBytes \Memory\Cache Bytes \Memory\Commit Limit \Memory\Committed Bytes \Memory\Free & Zero Page List Bytes \Memory\Free System Page Table Entries \Memory\Pages Input/sec \Memory\Pages Output/sec \Memory\Pages/sec \Memory\Pool Nonpaged Bytes \Memory\Pool Paged Bytes \Memory\System Cache Resident Bytes \Memory\Transition Pages RePurposed/sec \Network Inspection System\Average inspection latency (sec/bytes) \Network Interface(*)\Bytes Received/sec \Network Interface(*)\Bytes Sent/sec \Network Interface(*)\Bytes Total/sec \Network Interface(*)\Current Bandwidth \Network Interface(*)\Output Queue Length \Network Interface(*)\Packets Outbound Errors \Network Interface(*)\Packets Received/sec \Network Interface(*)\Packets Sent/sec \Network Interface(*)\Packets/sec \Paging File(*)\% Usage \PhysicalDisk(*)\Avg. Disk Queue Length \PhysicalDisk(*)\Avg. Disk sec/Read \PhysicalDisk(*)\Avg. Disk sec/Write \PhysicalDisk(*)\Current Disk Queue Length \PhysicalDisk(*)\Disk Bytes/sec \PhysicalDisk(*)\Disk Reads/sec \PhysicalDisk(*)\Disk Writes/sec \Process(_Total)\Handle Count \Process(_Total)\Private Bytes \Process(_Total)\Thread Count \Process(_Total)\Working Set \Process(sqlservr)\% Privileged Time \Processor Information(*)\% of Maximum Frequency \Processor Information(*)\Parking Status \Processor(*)\% DPC Time \Processor(*)\% Interrupt Time \Processor(*)\% Privileged Time \Processor(*)\% Processor Time \Processor(*)\% User Time \Processor(*)\DPC Rate \Server\Pool Nonpaged Failures \Server\Pool Paged Failures \SQLServer:Access Methods\Forwarded Records/sec \SQLServer:Access Methods\FreeSpace Scans/sec \SQLServer:Access Methods\Full Scans/sec \SQLServer:Access Methods\Index Searches/sec \SQLServer:Access Methods\Page Splits/sec \SQLServer:Access Methods\Scan Point Revalidations/sec \SQLServer:Access Methods\Workfiles Created/sec \SQLServer:Access Methods\Worktables Created/sec \SQLServer:Buffer Manager\Buffer cache hit ratio \SQLServer:Buffer Manager\Checkpoint pages/sec \SQLServer:Buffer Manager\Free pages \SQLServer:Buffer Manager\Lazy writes/sec \SQLServer:Buffer Manager\Page life expectancy \SQLServer:Buffer Manager\Page lookups/sec \SQLServer:Buffer Manager\Page reads/sec \SQLServer:Buffer Manager\Page writes/sec \SQLServer:General Statistics\Logins/sec \SQLServer:General Statistics\Logouts/sec \SQLServer:General Statistics\User Connections \SQLServer:Latches\Latch Waits/sec \SQLServer:Latches\Total Latch Wait Time (ms) \SQLServer:Locks(*)\Lock Requests/sec \SQLServer:Locks(*)\Lock Timeouts/sec \SQLServer:Locks(*)\Lock Wait Time (ms) \SQLServer:Locks(*)\Lock Waits/sec \SQLServer:Locks(*)\Number of Deadlocks/sec \SQLServer:Memory Manager\Memory Grants Pending \SQLServer:Memory Manager\Target Server Memory(KB) \SQLServer:Memory Manager\Total Server Memory (KB) \SQLServer:SQL Statistics\Batch Requests/sec \SQLServer:SQL Statistics\SQL Compilations/sec \SQLServer:SQL Statistics\SQL Re-Compilations/sec \System\Context Switches/sec \System\Processor Queue Length \System\System Calls/sec \Cache\Dirty Pages \Cache\Lazy Write Flushes/sec \LogicalDisk(*)\% Free Space \LogicalDisk(*)\% Idle Time \LogicalDisk(*)\Avg. Disk Bytes/Read \LogicalDisk(*)\Avg. Disk Bytes/Write \LogicalDisk(*)\Avg. Disk Queue Length \LogicalDisk(*)\Avg. Disk sec/Read \LogicalDisk(*)\Avg. Disk sec/Write \LogicalDisk(*)\Current Disk Queue Length \LogicalDisk(*)\Disk Bytes/sec \LogicalDisk(*)\Disk Reads/sec \LogicalDisk(*)\Disk Transfers/sec \LogicalDisk(*)\Disk Writes/sec \LogicalDisk(*)\Free Megabytes \Memory\% Committed Bytes In Use \Memory\Available MBytes \Memory\Cache Bytes \Memory\Commit Limit \Memory\Committed Bytes \Memory\Free & Zero Page List Bytes \Memory\Free System Page Table Entries \Memory\Pages Input/sec \Memory\Pages Output/sec \Memory\Pages/sec \Memory\Pool Nonpaged Bytes \Memory\Pool Paged Bytes \Memory\System Cache Resident Bytes \Memory\Transition Pages RePurposed/sec \Network Inspection System\Average inspection latency (sec/bytes) \Network Interface(*)\Bytes Received/sec \Network Interface(*)\Bytes Sent/sec \Network Interface(*)\Bytes Total/sec \Network Interface(*)\Current Bandwidth \Network Interface(*)\Output Queue Length \Network Interface(*)\Packets Outbound Errors \Network Interface(*)\Packets Received/sec \Network Interface(*)\Packets Sent/sec \Network Interface(*)\Packets/sec \Paging File(*)\% Usage \PhysicalDisk(*)\Avg. Disk Queue Length \PhysicalDisk(*)\Avg. Disk sec/Read \PhysicalDisk(*)\Avg. Disk sec/Write \PhysicalDisk(*)\Current Disk Queue Length \PhysicalDisk(*)\Disk Bytes/sec \PhysicalDisk(*)\Disk Reads/sec \PhysicalDisk(*)\Disk Writes/sec \Process(_Total)\Handle Count \Process(_Total)\Private Bytes \Process(_Total)\Thread Count \Process(_Total)\Working Set \Process(sqlservr)\% Privileged Time \Processor Information(*)\% of Maximum Frequency \Processor Information(*)\Parking Status \Processor(*)\% DPC Time \Processor(*)\% Interrupt Time \Processor(*)\% Privileged Time \Processor(*)\% Processor Time \Processor(*)\% User Time \Processor(*)\DPC Rate \Server\Pool Nonpaged Failures \Server\Pool Paged Failures \SQLServer:Access Methods\Forwarded Records/sec \SQLServer:Access Methods\FreeSpace Scans/sec \SQLServer:Access Methods\Full Scans/sec \SQLServer:Access Methods\Index Searches/sec \SQLServer:Access Methods\Page Splits/sec \SQLServer:Access Methods\Scan Point Revalidations/sec \SQLServer:Access Methods\Workfiles Created/sec \SQLServer:Access Methods\Worktables Created/sec \SQLServer:Buffer Manager\Buffer cache hit ratio \SQLServer:Buffer Manager\Checkpoint pages/sec \SQLServer:Buffer Manager\Free pages \SQLServer:Buffer Manager\Lazy writes/sec \SQLServer:Buffer Manager\Page life expectancy \SQLServer:Buffer Manager\Page lookups/sec \SQLServer:Buffer Manager\Page reads/sec \SQLServer:Buffer Manager\Page writes/sec \SQLServer:General Statistics\Logins/sec \SQLServer:General Statistics\Logouts/sec \SQLServer:General Statistics\User Connections \SQLServer:Latches\Latch Waits/sec \SQLServer:Latches\Total Latch Wait Time (ms) \SQLServer:Locks(*)\Lock Requests/sec \SQLServer:Locks(*)\Lock Timeouts/sec \SQLServer:Locks(*)\Lock Wait Time (ms) \SQLServer:Locks(*)\Lock Waits/sec \SQLServer:Locks(*)\Number of Deadlocks/sec \SQLServer:Memory Manager\Memory Grants Pending \SQLServer:Memory Manager\Target Server Memory(KB) \SQLServer:Memory Manager\Total Server Memory (KB) \SQLServer:SQL Statistics\Batch Requests/sec \SQLServer:SQL Statistics\SQL Compilations/sec \SQLServer:SQL Statistics\SQL Re-Compilations/sec \System\Context Switches/sec \System\Processor Queue Length \System\System Calls/sec 3/12/2012 127 -1 -1 200 1024 100 0 report.html report.xml 0 1 3 0 56 8 0 168 26