jaminsql ✭✭✭✭✭

I do have a support case open for this issue. case # 1015993 I have emailed in the case a few times and called the number that is listed and haven't heard back. Please do call in to the support line Phone: 866.530.8040, Option 3 for this case if you still need help.

davidl‌, This doesn't look like a script from DPA as it looks like a stored procedure in tempdb and that isn't ours. I think spaceman‌ is right and this is from redgate. Searching that on Google landed on their forum. Redgate forums • View topic - Description of columns for table : [dbo.RG_AllObjects_v3]. Do feel free to…

@dlotzen, This looks like we are having some error with the UTL_CON package that is run on the registration of DPA for Oracle. If you click back from that screen and hit back to screen 3 there is a option to manually run the package from a link see if you can click that and follow the instructions and then if needed please…

This is always a bit of a tough question and really the best we can ever do is guide customers on it some. One thing I would say is you posted the products you have but, not what the license size or each is and this matters very much. All the hardware guides we have are based on license size as this is the start of a guide…

Oracle Standard can be monitored in DPA with a Category 2 license. Oracle Enterprise requires a Catagory 1 license. DPA is also licensed per Oracle instance. If you have a Category 1 License that you can add to the registered instance you should be able to allocate the license in the license allocation page in DPA. Here is…

I had a case the other day here where we were not able to get the login to connect on to the repository on an AG group from one node and could from the other. In that case the login was a windows authentication account and from one node it was working to login and from the other it would not without adding a JDBC property…

This was posted in Database Performance analyzer's area but, here you simply say you are migrating Solarwinds. Are you migrating DPA's database or the database for the primary Orion product? Orion migration guide is here. Migration Guide - SolarWinds Worldwide, LLC. Help and Support with a video on the process here.…

You might be able to do a custom report for now. If you know the hash values you are after using these custom reports. Changing the query some to group by more then one hash value. Note the top one would be for a SQL server repository and the second an Oracle repository. Just a thought for getting the data on this from DPA…

Thanks for posting this to help others.

OK, so bad news on this one as of right now there isn't a way to change the subject line. This would be a great feature request. Database Performance Analyzer Feature Requests

mheydman, The change for this was actually made in DPA 11.0 see the release notes here. DPA 11.0.387 Release Notes - SolarWinds Worldwide, LLC. Help and Support this was a change made for security. " 929798 Cross-site request forgery protection was added." Cross Site Request Forgery (CSRF) is a security feature that has…

Mark, Good questions as always. A few notes that might help some on the discussion of this item. 1) Why the different chart types? The charts are some less consistent if you have on "show baselines" above them and it looks like you do have that selected in your screen shots. Some of the charts change if you select it…

Greg, The keys in the customer portal are tied to an install of DPA. If you want to activate only a few of the licenses granted with an activation key, you can click Specify Amount instead of selecting All Available. So say for example if your key is for 10 instances you can use 3 on test and leave 7 for production. If the…

Is the polling method WMI? We get better data via WMI. I think the issue here is that IE has a separate WMI counter from where we are polling the data. If you see this thread https://thwack.solarwinds.com/message/218321#218321 aLTeReGo​ says that we get this data from " hrSWInstalled "1.3.6.1.2.1.25.6" OID from the…

klbrydon​, I did a fast search internally and found the case you mention. It looks like support asked if you know a case number from when had the issue before and for some logs on the current issue and then we didn't hear back so it was closed out. You can always reply to a case for 30 days to reopen it. Looking more at…

Very possible. Given the structure of DPA's repository it some times needs to be either T SQL or PL/SQL to replace some table names dynamically. Is your DPA repository Oracle, SQL server, MySQL?

">bpeasland have you looked at this one? Custom Report - Top SQL by Any Metric - Oracle This is pulling from the summary tables and you can select the metric you are interested in If you need something more you can also enter a case and we can see if we can help.

timodb‌, Please do open a support case and we can help out with reports. We do that as best we can while working other cases to help with these. If you are interested in filtering out some items in the trend view you might look at upgrading to 9.1 as we added an exclude from charts option that is really helpful to filter…

Mark, I looked some also and I think this is 120 seconds I am basing this on the file. ./iwc/tomcat/webapps/iwc/WEB-INF/classes/properties/iwc-config.properties I am asking questions on this however as this file is outside the normal ignite_config folder that doesn't get over written on upgrades so I think a change here…

What wait types do you see in the details section of the blockers tab?

manu0417, I know this thread is a little old now but, I wondered if you saw the reply from mandevil about finding these names in the XML. Also the custom metric name is in the GUI if you to to custom metrics and look in the upper corner of the metric it is displayed. As System ID: <name> You can then find this in the…

Are you looking to register the servers in your inventory for monitoring in DPA? There is the mass register feature here. Register multiple database instances - SolarWinds Worldwide, LLC. Help and Support 

ltxd, Can you check and make sure that this isn't just a licence issue ? The keys for performance and the VM option are separate. So it is possible and I have seen it before that perhaps there is an unused key in your Customer Portal that needs to be applied. If this is the case the VM icon on the home screen for these…

Please make sure that the key is being entered in the correct field for Category 1 or Category 2 If you were not able to get this to work still it maybe that we need to investigate the key or the version installed for compatibility. Email CustomerService@solarwinds.com and describe the issue for a ticket and perhaps…

solarmarcs You also entered a case for this with us in support. I am happy to do a meeting with you to resolve the issue through the case but, the error indicates only a connection issue between DPA and the repository database server. You need to either edit the file in the error or work to resolve the connection issue to…

It sounds like you were able to get this running in the end then but, that DPA was installing and pointing to the other version of Java. I am not sure if I followed if you still need help here or not? Are you still seeing the Out of memory errors? Check the system.log file in tomcat/logs to see what your start up…

This can be done. click on Options > Database Query Tool (support tab) and run the following SQL statements: -- grab the ID for the instance and use in the UPDATE statement select * from cond -- Set the Display name to the alias update cond set name='<New Display Name>' where ID = <ID of instance to change> restart DPA…

Custom metrics can be locked by a password that isn't any of the above and also isn't tied to a set role. When you install by default on the settings administration tab you would have seen this item. You can see here that there is a file in this path DPA_INSTALL_DIR/iwc/tomcat/ignite_config/iwc/security the password is set…

Jason, I think the version for SQL server 2005 may be different. Here’s the 2008 / 12 / 14 version. SELECT * FROM (SELECT object_name(i.id) tablename,i.name, stats_date(i.id,i.indid) statsdate, * i.rowcnt, * i.rowmodctr, * s.no_recompute, * sp.rows_sampled FROM sys.sysindexes i with (NOLOCK) LEFT OUTER JOIN sys.stats s…

mhenry I think I know the answer to this but, to be sure of my answer can you clarify a few things? 1) What is the monitored platform you are seeing this on in DPA? (SQL Server, Oracle, MySQL, Sybase, DB2) 2) I think you mean you see blocking in the current "super tab" in the real-time sessions blocking sub-tab compared to…