Get the latest news about SolarWinds Database Performance Analyzer (DPA)
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?
For installation of a DPA data repository in an MSSQL server, can it use an already existing login that is dbo in an already existing db For registering an instance of a MSSQL server to be monitored, can I run an .sql file outside of DPA to do the setup? I found this web page which is somewhat related: * Success Center -…
I would like to know and suggest the opcion to add the graphics or other information and send it by mail in AUTOMATIC way or using the SCHEDULLER as a task scheduled at night to send by mail. I found a manually opcion , but i would like to send in Automatic opcionthe information like a picture that a i attach
Hi, I want to create a alert when the PLE < 300seconds. Which values should I use for calculation and percentage?
It looks like you're new here. Sign in or register to get started.