Get the latest news about SolarWinds Database Performance Analyzer (DPA)
Is it possible to configure MS SQL DPA to monitor only one database in instance? Thanks
We want to monitor a client of ours with DPA but they have a very particular architecture. They have a single DB instance with multiple databases, and we only own one of the databases. We would need DPA to be able to monitor that one DB and only that DB without being able to touch the other DBs in the same instance for the…
I want to add critical for selective jobs under 'SQL Server Job Failure' alert type. How can I do that ?
Not seeing excessive CPU utilization and have allocated the max that SQL 2017 will allow for RAM and he'll have plenty of overhead for the OS. For instance I'm seeing a lot of wait time sourced from CPU/RAM this morning yet CPU utilization peaked at 51% and as averaging 26%. I'm not a database administrator so perhaps I'm…
Hello DPA. I was planning on updating the version of DPA that we run until one of the DBAs pointed out this feature below. So at this point it looks like I will have to remain on 12.1.6 until at some point we can update all of the SQL that is dropped from support. Which I can say will be probably years at this point. If I…
Hi Team, We are seeing huge amount of growth in following tables which store execution plan and query text, I would like to check following things: * Can I check if purging is working\not working? * Any way to control the size of the these tables? * Implement compression for these tables? Table…
I'm positive I'm not the first to ask this, but I spent about 20 minutes looking for the answer must have lost my ability to search today... Can someone point me to instructions on how to filter DPA dashboards by username that's running the SQL? I don't want to exclude stuff from the normal view, I just want to be able to…
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…
Hi, I need an alert that sends a message when the actual tempdb usage is 80%. Our tempdb is pre-sized but I need to know when it close to filling up.
I dont see the above metrics being tracked in DPA for my SQL Server 2005 instance. Does DPA track those metrics?
It looks like you're new here. Sign in or register to get started.