Perf Baseline Vergleich - DEV01

Instanz: DEV01 | Example_Before -> Example_After
Quelle: www.powershelldba.de | sqmSQLTool v1.9.26.1

Vergleich

BaselineA:Example_Before (2026-07-19T18:43:51.5346091+02:00)
BaselineB:Example_After (2026-07-19T18:43:55.8393076+02:00)

Wait Stats - Zunahme B gegenueber A (10)

WaitTypeDeltaWaitSecDeltaWaitingTasksAvgWaitMsDelta
SOS_WORK_DISPATCHER96661454,77
HADR_FILESTREAM_IOMGR_IOCOMPLETION4,69509,56
SQLTRACE_INCREMENTAL_FLUSH_SLEEP414006
MEMORY_ALLOCATION_EXT0,13831060
PREEMPTIVE_OS_AUTHENTICATIONOPS060,17
PREEMPTIVE_OS_CLOSEHANDLE020,5
SOS_SCHEDULER_YIELD03250
PREEMPTIVE_OS_QUERYREGISTRY0100,1
MSQL_XP0350,91
ASYNC_NETWORK_IO032,33

Perf Counter - Veraenderungen (8)

CounterValueAValueBDelta
Buffer cache hit ratio base []25321056-1476
Buffer cache hit ratio []25321056-1476
Index Searches/sec []1026140510262319914
Batch Requests/sec []401594019132
Full Scans/sec []815018152120
SQL Compilations/sec []287002871515
Page life expectancy [000]4118404118444
Page life expectancy []4118404118444