Parent, SQL Exec Stats, Copyright 2006-2018 Elemental Inc. All rights reserved.
Read Me, Intro, Main, General, Databases, File IO, Tables, Indexes, ExecStats, StoredProcs, DistStats, IxOpStats, Appendix

update in progress 2015-Feb

General Information

General system information is displayed in the grid to right of the Connection tab. The information includes @@VERSION, xp_msver, and dm_os_sys_info.

xp_msver

sys.configurations,

SysConfigures

sys.dm_os_sys_info,

DmOsSysInfo

The view sys.dm_os_sys_mem, and sys.dm_os_process_memory are only available for SQL Server 2008.

DmOsSysMem

The top 50 sys.dm_wait_stats are displayed:

DmOsWaitStats

OS Perf Ctrs

The tab OS Perf Ctrs collects the point in time OS Performance Counters. Hopefully I can add regular sampling to display key performance counters over a period.

OSPerfCtrs

 

 

Prev        Next