Folgende Parameter sind unter anderem für eine grundlegende Performance Baseline mittels Performance Monitor interessant.
== OS Performance Counters ==
=== IPv4 ===
* Fragment Re-assembly Failures
* Segments Sent/sec
* Segments/sec
== SQL Performance Counters ==
Hier fehlen noch Counter, falls AlwaysOn oder Replikation aktiv ist.
=== SQLAgent:Jobs(*) ===
* Active jobs
=== SQLServer:Access Methods ===
* Full Scans/sec
* Index Searches/sec
* Range Scans/sec
* Table Lock Escalations/sec
* Workfiles Created/sec
* Worktables Created/sec
* Worktables From Cache Ratio
=== SQLServer:Batch Resp Statistics ===
Für "CPU Time:Requests", "CPU Time:Total(ms)", "Elapsed Time:Requests" und Elapsed Time:Total(ms) alle Zeitbereich der Batches auswählen.
Beispiel : Batches >=000001ms&<000002ms
=== SQLServer:Buffer Manager ===
* Buffer cache hit ratio
* Page life expectancy
* Page lookups/sec
* Page reads/sec
* Page writes/sec
=== SQLServer:Buffer Node(000) ===
Falls NUMA aktiv ist, sollten alle Nodes erfasst werden.
* Database pages
* Local node page lookups/sec
* Page life expectancy
* Remote node page lookups/sec
=== SQLServer:Databases(_Total) ===
* Log Flush Write Time (ms)
* Transactions/sec
=== SQLServer:Exec Statistics(*) ===
* Distributed Query
* DTC calls
* OLEDB calls
=== SQLServer:General Statistics ===
* Logins/sec
* Logouts/sec
* User Connections
=== SQLServer:Latches ===
* Average Latch Wait Time (ms)
* Latch Waits/sec
=== SQLServer:Locks(_Total) ===
* Lock Requests/sec
* Lock Wait Time (ms)
* Number of Deadlocks/sec
=== SQLServer:Memory Manager ===
* Stolen Server Memory (KB)
* Target Server Memory (KB)
* Total Server Memory (KB)
=== SQLServer:Memory Node(000) ===
Für jede Numa Node
* Stolen Server Memory (KB)
* Target Server Memory (KB)
* Total Server Memory (KB)
=== SQLServer:Plan Cache(_Total) ===
* Cache Hit Ratio
=== SQLServer:SQL Errors(_Total) ===
* Errors/sec
=== SQLServer:SQL Statistics ===
* Batch Requests/sec
* SQL Compilations/sec
* SQL Re-Compilations/sec
=== SQLServer:Transactions ===
* Free Space in tempdb (KB)
* Transactions
* Version Store Size (KB)
=== SQLServer:Wait Statistics(X) ===
Für "Average wait time (ms)" und "Waits in progress"
* Lock waits
* Log buffer waits
* Log write waits
* Memory grant queue waits
* Network IO waits
* Non-Page latch waits
* Page IO latch waits
* Page latch waits
* Thread-safe memory objects waits
* Transaction ownership waits
* Wait for the worker
* Workspace synchronization waits
Änderungen – Software Entwicklung Projekte
Änderungen
2.305 Byte hinzugefügt,
08:29, 22. Jun. 2015