jaminsql ✭✭✭✭✭

Thanks for posting back so we had the answer.

Mark I see what you mean for sure. I am going to ask for a few others to look over the thread here and chime in on it.

The number of items to show in the charts is 15 by default. This is an item that can be changed in the options menu. Options -> Administration tab -> advanced options -> system options tab. Look for NUMBER_OF_ITEMS_IN_TIMESERIES_CHARTS . You can increase the number to a max of 100 (charts will take more time to render).…

Thanks for the mention. post was here for anyone looking. Re: Custom Table resource limited to 100 rows of data 

Update to the thread here for anyone that would like to do this feature. We did find a solution that worked to enable this ability for IFrames again but, it requires some changes to files in DPA that will would be overwritten on a DPA upgrade. In general, when there is an easy config file change or system option that will…

DPA does integrate with LDAP and AD user groups. The items in the Wizard that you are asking about here. * User: The domain user DPA uses to query the directory for users and groups * Password: The password of the domain user, preferably one that does not expire These are simply items you fill in to the wizard to give DPA…

igcalvo​, I had advised to re install because of this error we are seeing. If the repair option is not coming up for you I would un install and reinstall. I am also happy to help you with this on a meeting and see if we can get you resolved. The logs you sent do not have all the items I would normally see in them. This…

Good find. Just to provide a few more items for others that might read the thread on this one. Annotations will be created automatically for the following cases: * Listener Failover * Monitoring the listening and an AG role changes and the primary replica changed * Monitoring an instance and an AG role changes and the…

jsql Did you try the above item also from the GUI? Reading some on our internal page for this feature also turning off the advisor should remove a query from this section also. There is a note in the design documentw that reads. "Do not include queries that have their Advisor Analysis setting disabled by the user. (The SQL…

jsql​ DPA does have some system options that might help but, I am thinking we might still not have anything that is granular enough for your use case here. There are items that allow you to filter out by the database and also by the database and an operator. It would be nice if we also had one for table. These would be…

">slominskir So after looking into this one and looking at the logs the MySQL Version here was 5.6.8 and DPA for MySQL was tested a GA to support 5.6.10 Our documentation may need to have this update as it only read 5.6. I sent this on the the Product managers.

Eric, I really don't think this would this error would have anything to do with this being the last instance licensed. Please open a support ticket. -Jamin

Antonio, You can deploy a new database rather easy. In repo.properties set the value of repo.created=no save the file and restart the service Ignite PI if you are on a windows install. If Linux the same but, run ./shutdown.sh then ./startup.sh When DPA has the value set to no it will load the wizard for creating a new…

Something like this one? Custom Alert - Long Running Queries

Re: change name of server in alert messages Nicolas, Here is a KB that I think will help SolarWinds Knowledge Base :: DPA Email Overrides . "To Override Email Settings Edit the following file on the Ignite server machine, then uncomment and set the appropriate property: /iwc/tomcat/ignite_config/idc/system.properties" You…

Trying to help here some. CONU is database user CONO is O/S user for an Oracle instance and database name in SQL server instances. This may help you. -- grab the ID field for this and use as a suffix (_X below) for the tables SELECT id, name FROM cond; -- Main wait time table CONSW_X ---------- - XCUW - DB User - joins to…

Mark, This alert is pulling from sys.dm_xe_session_targets looking for when a deadlock happens but, is not saving the XML anywhere and there isn't a way to attach a file to the alert emails so I don't think that this is possible in DPA currently. Please add this idea as a feature request Database Performance Analyzer…

Kathy gave some great steps on this one but, it still has come up in a few support cases so I am adding some info here for anyone searching this item. There are two settings related to this that were added in 9.1. They are IO_STATS_POLL_ENABLED and IO_STATS_POLL_FILE_LIMIT The file limit is system wide setting in Options…

skenow​ you are correct if you check the box to remove objects from the server then DPA would try to connect to it for that process.

So there are some reports that are here on THWACK that have some of this now. Custom Report - Top SQL by Database User Custom Report - Top SQL for a Machine Custom Report - Top SQL by O/S User In General as a starter for you DPA has sort of two star schema on for detail data and one for Sum data. The detail data is where…

mheydman, After further testing on this item, it looks like I was incorrect on what changed this exactly though it did change in DPA 11.0. We made several security improvements The item that changed this in 11.0 was actually a change as a result of upgrading to Spring 4.x and is considered a security enhancement, mainly…

amehlman There isn't enough information to go on from only the screenshot. DPA has a separate Web console on that this page in your screen shot is "integrated" with via a web service call. The DPA version and instances sections seem to not load for any number of reasons. I have seen the same on support cases in the last…

Glad that helped. If you do want more help on this open a case or you can reach out here again also.

aiglee.castillo This isn't really possible in DPA at this time. Perhaps you can upvote the feature requests that sound like what you are asking for.

Re: What is the maximum allowed length of the name in the name/numeric value pairs for a Custom SQL Alert - Multiple Numeric Return? m60freeman​ Sorry I meant to update this before. Things got busy. I did some looking and want to confirm the location of the config and how this all works before adding details.

Might be the key was cut for the wrong version. DPA version 9.0 and 9.1 and greater keys were not compatible. So if the key was 9.0 and you're on anything above that version on the install that would be an issue. I have also seen a few cases with temp or eval keys just not working correct but, that has been rare.

Severi, Please just enter a support case. We can then read the full logs or join you on a call and get DPA running again.

m60freeman​, This was treated as a bug DPA-639. It was fixed in the DPA 11 builds that are now in RC. "Fixed an issue where the text poll for SQL Server was truncated to 8000 characters." Reading the notes it was fixed as follows. In the options menu there is new parameters. added a new parameter…

pholtquist The downloads for DPA and other Solarwinds products are in your customer portal https://customerportal.solarwinds.com/Downloads If you need past versions there is a drop-down menu to the left of the download button. It looks like at current you can still download back to DPA 9.1 so you should be able to just…

Sorry for the super tab wording if that was confusing. I guess that is some jargon we use here in support for the tabs in DPA. So I think there are a few issues with this one. One is what darichar has said as far as averages etc. The other is that the current tab in SQL server doesn't use exactly the same query as the…