The most recent content from our members.
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've been using DPA to tune my SolarWinds. I've been annoyed by WRITE LOG as the chronic #2 wait time. All SQL volumes were already on all flash storage and being bound by the application there wasn't much else I could do to tune performance. After researching this type of wait I read an article about a SQL option called…
Hi, We've started using DPA on one of our clients sites and it's helped us a lot by highlighting some issues with some problem queries, we've now hit a bit of a roadblock because the top SQL Statements is now being listed as "/* Commit */" and i have no idea what that means or where it's coming from. When this happens the…
It looks like you're new here. Sign in or register to get started.