The most recent content from our members.
What are DPA's capabilities for monitoring and troubleshooting when [tempdb] runs out of space? Can DPA... * Identify SPIDs/transactions consuming the most space in [tempdb]? * Identify related SQL statements of SPIDs/transactions? * Identify [tempdb] file space usage (size, allocated size, unallocated size, version store…
Background This blog initially started out as an examination of how SolarWinds uses Database Performance Analyzer (DPA) within our own production environment. It now includes not only how our DBA uses DPA, but how other business units within SolarWinds use it and why. It isn’t surprising to find people in IT operations and…
I wanted to know if it would be possible for DPA to have SQL text comparisons similar to how NCM has configuration comparisons when a configuration is changed within the network. NCM highlights the changes that were made, it would be nice and a cool feature to have if DBs could see the changes that were made within their…
When clicking on a query ID and custom naming it, the length allowed is only 30 characters. We are finding that the stored proc names are sometimes longer that this limit and it would be nice to be able to use up to 100 characters. A suggestion would then be that in places where it doesn't make sense to have more than 30…
Hi All. We are in test mode at the moment and all is looking good to impress the money people. However today I noticed that our links between Solarwinds and DPA seem to be falling off/dissolving. I assigned the links Monday and Wednesday there were all missing. I re-assigned and they dissolved again with the next page…
Hi folks, I'm not entirely sure what DPA can and cannot do, we are using it right now to monitor the performance of our SQL engine that our applications read/write data from, however we are starting to work with Analysis Services now. So my question to the community is, how can I monitor performance of our SQL Server…
In DPA, I cannot provide labels / names for plans. It would be beneficial to provide these for reporting / viewing purposes. Automatically linking the label from a SQL statement would be even better.
It looks like you're new here. Sign in or register to get started.