https://ecker-software.de/index.php?action=history&feed=atom&title=MSSQL_Performance_Data_Collection 2026-04-11T03:14:18Z Versionsgeschichte dieser Seite in Software Entwicklung Projekte MediaWiki 1.27.1 https://ecker-software.de/index.php?title=MSSQL_Performance_Data_Collection&diff=154&oldid=prev 2015-09-14T09:58:16Z

<p>‎<span dir="auto"><span class="autocomment">LogicalDisk(_Total)</span></span></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;' lang='de'> <td colspan='2' style="background-color: white; color:black; text-align: center;">← Nächstältere Version</td> <td colspan='2' style="background-color: white; color:black; text-align: center;">Version vom 14. September 2015, 09:58 Uhr</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l110" >Zeile 110:</td> <td colspan="2" class="diff-lineno">Zeile 110:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>* \LogicalDisk(_Total)\Free Megabytes</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>* \LogicalDisk(_Total)\Free Megabytes</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div> </div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>=== For each logical disk LogicalDisk(X) === <del class="diffchange diffchange-inline"> #</del></div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>=== For each logical disk LogicalDisk(X) ===</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>* \LogicalDisk(LogDisk1..n)\Avg. Disk sec/Read</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>* \LogicalDisk(LogDisk1..n)\Avg. Disk sec/Read</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>* \LogicalDisk(LogDisk1..n)\Avg. Disk sec/Transfer</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>* \LogicalDisk(LogDisk1..n)\Avg. Disk sec/Transfer</div></td></tr> <tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l121" >Zeile 121:</td> <td colspan="2" class="diff-lineno">Zeile 121:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>* \LogicalDisk(LogDisk1..n)\Disk Writes/sec</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>* \LogicalDisk(LogDisk1..n)\Disk Writes/sec</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>* \LogicalDisk(LogDisk1..n)\Free Megabytes</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>* \LogicalDisk(LogDisk1..n)\Free Megabytes</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> </del></div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>&#160;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>=== Memory ===</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>=== Memory ===</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>* \Memory\Available MBytes</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>* \Memory\Available MBytes</div></td></tr> </table>

David https://ecker-software.de/index.php?title=MSSQL_Performance_Data_Collection&diff=153&oldid=prev 2015-09-14T09:57:53Z

<p>Die Seite wurde neu angelegt: „== SQL Counter for each SQL Server Instance == Sammeln dieser Daten sollte periodisch automatisch erfolgen um eine einfache Baseline zu erhalten. Mit dieser e…“</p> <p><b>Neue Seite</b></p><div>== SQL Counter for each SQL Server Instance ==<br /> <br /> Sammeln dieser Daten sollte periodisch automatisch erfolgen um eine einfache Baseline zu erhalten. Mit dieser einfachen Baseline können Problemstellen dann gezielter untersucht werden.<br /> <br /> === SQLAgent:Jobs === <br /> * \SQLAgent:Jobs(_Total)\Active jobs<br /> <br /> === SQLServer:Access === <br /> * \SQLServer:Access Methods\Full Scans/sec<br /> * \SQLServer:Access Methods\Index Searches/sec<br /> * \SQLServer:Access Methods\Range Scans/sec<br /> * \SQLServer:Access Methods\Table Lock Escalations/sec<br /> * \SQLServer:Access Methods\Workfiles Created/sec<br /> * \SQLServer:Access Methods\Worktables Created/sec<br /> <br /> === SQLServer:Buffer === <br /> * \SQLServer:Buffer Manager\Buffer cache hit ratio<br /> * \SQLServer:Buffer Manager\Page life expectancy<br /> * \SQLServer:Buffer Manager\Page lookups/sec<br /> * \SQLServer:Buffer Manager\Page reads/sec<br /> * \SQLServer:Buffer Manager\Page writes/sec<br /> * \SQLServer:Buffer Manager\Target pages<br /> <br /> === SQLServer:Databases === <br /> * \SQLServer:Databases(_Total)\Log Flush Write Time (ms)<br /> * \SQLServer:Databases(_Total)\Transactions/sec<br /> <br /> === SQLServer:General Statistics === <br /> * \SQLServer:General Statistics\Logins/sec<br /> * \SQLServer:General Statistics\Logouts/sec<br /> * \SQLServer:General Statistics\User Connections<br /> <br /> === SQLServer:Latches === <br /> * \SQLServer:Latches\Average Latch Wait Time (ms)<br /> * \SQLServer:Latches\Latch Waits/sec<br /> <br /> === SQLServer:Locks === <br /> * \SQLServer:Locks(_Total)\Lock Requests/sec<br /> * \SQLServer:Locks(_Total)\Lock Wait Time (ms)<br /> * \SQLServer:Locks(_Total)\Number of Deadlocks/sec<br /> <br /> === SQLServer:Memory === <br /> * \SQLServer:Memory Manager\Stolen Server Memory (KB)<br /> * \SQLServer:Memory Manager\Target Server Memory (KB)<br /> * \SQLServer:Memory Manager\Total Server Memory (KB)<br /> <br /> === SQLServer:Plan Cache === <br /> * \SQLServer:Plan Cache(_Total)\Cache Hit Ratio<br /> <br /> === SQLServer:Databases === <br /> * \SQLServer:SQL Errors(_Total)\Errors/sec<br /> <br /> === SQLServer:SQL Statistics === <br /> * \SQLServer:SQL Statistics\Batch Requests/sec<br /> * \SQLServer:SQL Statistics\SQL Compilations/sec<br /> * \SQLServer:SQL Statistics\SQL Re-Compilations/sec<br /> <br /> === SQLServer:Transactions === <br /> * \SQLServer:Transactions\Free Space in tempdb (KB)<br /> * \SQLServer:Transactions\Transactions<br /> * \SQLServer:Transactions\Version Store Size (KB)<br /> <br /> === SQLServer:Wait Statistics(Average wait time (ms)) === <br /> * \SQLServer:Wait Statistics(Average wait time (ms))\Lock waits<br /> * \SQLServer:Wait Statistics(Average wait time (ms))\Log buffer waits<br /> * \SQLServer:Wait Statistics(Average wait time (ms))\Log write waits<br /> * \SQLServer:Wait Statistics(Average wait time (ms))\Memory grant queue waits<br /> * \SQLServer:Wait Statistics(Average wait time (ms))\Network IO waits<br /> * \SQLServer:Wait Statistics(Average wait time (ms))\Non-Page latch waits<br /> * \SQLServer:Wait Statistics(Average wait time (ms))\Page IO latch waits<br /> * \SQLServer:Wait Statistics(Average wait time (ms))\Page latch waits<br /> * \SQLServer:Wait Statistics(Average wait time (ms))\Thread-safe memory objects waits<br /> * \SQLServer:Wait Statistics(Average wait time (ms))\Transaction ownership waits<br /> * \SQLServer:Wait Statistics(Average wait time (ms))\Wait for the worker<br /> * \SQLServer:Wait Statistics(Average wait time (ms))\Workspace synchronization waits<br /> <br /> === SQLServer:Wait Statistics(Waits in progress) === <br /> * \SQLServer:Wait Statistics(Waits in progress)\Lock waits<br /> * \SQLServer:Wait Statistics(Waits in progress)\Log buffer waits<br /> * \SQLServer:Wait Statistics(Waits in progress)\Log write waits<br /> * \SQLServer:Wait Statistics(Waits in progress)\Memory grant queue waits<br /> * \SQLServer:Wait Statistics(Waits in progress)\Network IO waits<br /> * \SQLServer:Wait Statistics(Waits in progress)\Non-Page latch waits<br /> * \SQLServer:Wait Statistics(Waits in progress)\Page IO latch waits<br /> * \SQLServer:Wait Statistics(Waits in progress)\Page latch waits<br /> * \SQLServer:Wait Statistics(Waits in progress)\Thread-safe memory objects waits<br /> * \SQLServer:Wait Statistics(Waits in progress)\Transaction ownership waits<br /> * \SQLServer:Wait Statistics(Waits in progress)\Wait for the worker<br /> * \SQLServer:Wait Statistics(Waits in progress)\Workspace synchronization waits<br /> <br /> === Foreach Buffer Node SQLServer:Buffer Node(x) === <br /> * \SQLServer:Buffer Node(000)\Remote node page lookups/sec<br /> * \SQLServer:Buffer Node(001)\Remote node page lookups/sec<br /> * ...<br /> * \SQLServer:Buffer Node(n)\Remote node page lookups/sec<br /> <br /> <br /> == System Counter ==<br /> <br /> === LogicalDisk(_Total) ===<br /> * \LogicalDisk(_Total)\Avg. Disk sec/Read<br /> * \LogicalDisk(_Total)\Avg. Disk sec/Transfer<br /> * \LogicalDisk(_Total)\Avg. Disk sec/Write<br /> * \LogicalDisk(_Total)\Current Disk Queue Length<br /> * \LogicalDisk(_Total)\Disk Read Bytes/sec<br /> * \LogicalDisk(_Total)\Disk Reads/sec<br /> * \LogicalDisk(_Total)\Disk Transfers/sec<br /> * \LogicalDisk(_Total)\Disk Write Bytes/sec<br /> * \LogicalDisk(_Total)\Disk Writes/sec<br /> * \LogicalDisk(_Total)\Free Megabytes<br /> <br /> === For each logical disk LogicalDisk(X) === #<br /> * \LogicalDisk(LogDisk1..n)\Avg. Disk sec/Read<br /> * \LogicalDisk(LogDisk1..n)\Avg. Disk sec/Transfer<br /> * \LogicalDisk(LogDisk1..n)\Avg. Disk sec/Write<br /> * \LogicalDisk(LogDisk1..n)\Current Disk Queue Length<br /> * \LogicalDisk(LogDisk1..n)\Disk Read Bytes/sec<br /> * \LogicalDisk(LogDisk1..n)\Disk Reads/sec<br /> * \LogicalDisk(LogDisk1..n)\Disk Transfers/sec<br /> * \LogicalDisk(LogDisk1..n)\Disk Write Bytes/sec<br /> * \LogicalDisk(LogDisk1..n)\Disk Writes/sec<br /> * \LogicalDisk(LogDisk1..n)\Free Megabytes<br /> <br /> === Memory ===<br /> * \Memory\Available MBytes<br /> * \Memory\Cache Faults/sec<br /> * \Memory\Page Faults/sec<br /> * \Memory\Page Reads/sec<br /> * \Memory\Page Writes/sec<br /> * \Memory\Pages Input/sec<br /> * \Memory\Pages Output/sec<br /> * \Memory\Pages/sec<br /> <br /> === For each used network interface === <br /> * \Network Interface(Microsoft Hyper-V Network Adapter)\Bytes Received/sec<br /> * \Network Interface(Microsoft Hyper-V Network Adapter)\Bytes Sent/sec<br /> * \Network Interface(Microsoft Hyper-V Network Adapter)\Bytes Total/sec<br /> * \Network Interface(Microsoft Hyper-V Network Adapter)\Packets Outbound Errors<br /> * \Network Interface(Microsoft Hyper-V Network Adapter)\Packets Received Errors<br /> * \Network Interface(Microsoft Hyper-V Network Adapter)\Packets/sec<br /> <br /> === For each sql server process ===<br /> * \Process(sqlservr)\% Privileged Time<br /> * \Process(sqlservr)\% Processor Time<br /> <br /> === Processor(_Total) === <br /> * Processor(_Total)\% Privileged Time<br /> * Processor(_Total)\% Processor Time<br /> <br /> === For each CPU core Processor(X)=== <br /> * \Processor(0)\% Privileged Time<br /> * \Processor(0)\% Processor Time<br /> * \Processor(1)\% Privileged Time<br /> * \Processor(1)\% Processor Time<br /> * \Processor(n)\% Privileged Time<br /> * \Processor(n)\% Processor Time<br /> <br /> === System === <br /> * \System\Context Switches/sec</div>

David