The most recent content from our members.
Can someone please tell me which SQL Server wait types constitute "Memory/CPU" in DPA? It's always the largest portion of my waits and I'm not sure specifically what they are since other CPU waits like SOS_SCHEDULER_YIELD are broken out separately. I have my own job that collects data from sys,dm_os_wait_stats every 30…
Hello, We have been testing a NetApp SSD to compare performance from our Hitachi SAN. One of our "problem" databases is SolarWinds_NPM which has an enormous amount of WRITELOG waits. After migrating the server to SSD, the WRITELOGs went down significantly but the Memory/CPU waits went UP, almost by the same amount, almost…
I have noticed that there are sometimes HUGE differences for wait times given separate categories. This, for example is the total wait times for the various tabs for one of our servers on March 3: SQL Tab: 6:42:33 Waits Tab: 62:45:01 Programs Tab: 54:29:04 Databases Tab: 63:11:18 Machines Tab: 13:20:43 DB Users Tab:…
It looks like you're new here. Sign in or register to get started.