SQL Server Performance

Windows and Memory Query

Discussion in 'SQL Server 2005 General DBA Questions' started by Trev256, Aug 21, 2008.

  1. Trev256 New Member

    1) Does anyone know how to check the windows diagnostic info if winmsd isn't working on Windows 2003? What is the best diagnositc tool for Windows 2003? I'm trying to check the pagefile and CPU.
    2) Also, I noticed the physical memory is 2096588 KB and dynamic memory is set from 0 MB to 2147483647 MB - why are the maximum numbers different?
    Thanks
  2. ghemant Moderator

    Hi,
    1. You can use PerfMon to have CPU, PageFile & Memory counters
    2. Can you please elaborate this!!! Are you facing any memory performance problem!!

Share This Page