jaminsql ✭✭✭✭✭

CONO_#DBID# is a table with the O/S user name on an Oracle monitored instance and is the Database name in SQL server. Just wanted to mention this as this page has both Oracle and SQL examples.

ashrecksiedler This is interesting actually I had seen an example where something like this was done with the built-in alert "Total Blocking Wait Time." Different values were needed for some times of the day so two copies of the alert were made with blackouts for the alert done on whatever one had the incorrect amount of…

It shouldn't if you run into issue with the config wizard changing the site bindings on any times you need to do a repair. Check the skip site bindings there is a good thread on this item here https://thwack.solarwinds.com/thread/55783

I have turned in this issue internal and marked the thread. find the content referenced here please.http://www.solarwinds.com/netperfmon/solarwinds/wwhelp/wwhimpl/js/html/wwhelp.htm#context=SolarWinds&file=OrionCoreAGEna… …

re.harmsen I might be a bit late in reply now. the release notes were not out right away now that we are GA you can find that here. DPA 11.1 Release Notes - SolarWinds Worldwide, LLC. Help and Support 

Vote for the feature request We for sure watch the features with the most votes. 

seanfoic I just looked as I wasn't positive but, the table you list was added in DPA 11.1 not in 11.0 so you will, in fact, need to upgrade

Mark, I know you just had a case for this issue. I think this alert was created before some edits to the quick poll where we are filtering out more items. When you say the notification text doesn't match what do you mean there? I know the alert as drafted my not match the blockers tab in DPA. Also please review the new…

The main reason you might get this is a schema mismatch. This line is the issue but, there maybe others. "SELECT @VMID=vmid FROM cond WHERE id = #DBID#;" If your repository database is in SQL server DPA's default schema maybe set to ignte for all the table names. If you are running this report in something like SQL server…

Added some items to the above to get the SQL text and user name. IF (SELECT COUNT(*) FROM SYS.OBJECTS WHERE NAME LIKE 'TopSQLforProgram2') = 1 DROP PROC TopSQLforProgram2 GO -- TopSQLforProgram2 PROC -- -- PARMS '@FROM_DATE', '@TO_DATE', '@DBNAME' , '@PROGRAMNAME' -- EXAMPLE: -- -- EXEC TopSQLforProgram2 '2008-12-13…

DPA has basically two star schema's the one you are looking in with CONSW_ in the center is the detail data. The long term storage data has CON_SAMPLE_SUM_ in the center. summary data for CONSS_ is in the table CON_SQL_SUM_ and summary data for Events would be CON_EVENT_SUM_ here is a good example on the joins from thwack.…

hmgdba​ I sent a reply on the question you did here USER for Custom Resource Metric Configuration? 

There isn't an option in the interface for this but, I would point you as a starter to this thwack post Custom Report - SQL Plan Analyzer this was written on a SQL server repository and does a search Clustered Index Scans, Table Scans and any other physical operator. This might help you with what tables to go to even if…

tjk15​, The table is CON_EVENTS. The table does have a DBID column and you would want to make sure that you fill this in with the ID of the monitored instance you want to insert the annotation on. This would be the ID from the COND table. "SELECT ID, NAME FROM COND;" will give you the ID of your registered monitored…

The setting for delete is on the same page you mention with a delete button. The only think I can think of looking at it local is that the user that is listed as (Repository Owner) does not have that option. You can edit the user that is in use for that item with this articles steps Change the DPA repository password -…

Eric, Can you open a support case for this one and send on some logs? This isn't something I have seen. You might also try clearing the chart cache options -> support tab -> clear chart cache. I still think a support ticket is a good idea on this one though. Thanks, Jamin Walters | DPA Support Technician

tjk15​, Currently The button for annotations should appear only if the user has the 'Manage Monitoring' permission. You can turn in a feature request to allow this to be changed for DPA users and permissions. There are a number of request around user permissions but, I don't see this one out there at the moment. Database…

I think you are looking for an item that is really already there as a canned alert. If you click alerts -> Manage Alerts tab -> Select the radio button for "wait time" -> pull the drop down Alert type: to "Total SQL Wait time for a Single SQL" Then fill in your servers and in the SQL Hash you can do a search the hash, text…

There is not one for deadlocks built in to DPA. This is a custom alert for SQL server by mandevil Custom Alert - Deadlocks There is also a custom metric so you can just have a chart displaying deadlocks. Custom Metric - Deadlocks

I have not seen anything like what you say here so far in support cases. There are some system settings in the advanced configuration of DPAIM that can be done in Orion. They are changed in the advanced configuration pages that are in a hidden URL of Orions web console. Https://Orion…

I think we got a support case on this one from you as well. We see this error for a few reasons. On any of them if is best to start looking at the logs directory. In this case we had Java out of memory errors so we looked at increasing the max java heap size as we were using the default of 512 and monitoring a number of…

garymazzone‌, Reading through here. Are you saying you get alerts from DPA and not from the SQL Agent job ? Are all the settings for database mail working ? Seems like if the email from DPA is working and the notifications from msdb.dbo.sp_send_dmail are not that could be a good thing to check. Also you said this was a…

You are hitting an item that was a common issue due to some metrics that used WMI calls in older versions of DPA. Please read through this and if you have more questions open a support case. DPA monitor stops on SQL server with max connections exceeded - SolarWinds Worldwide, LLC. Help and Support

DPA ranks and shows the statements that are the highest wait. (biggest concern from a end user perspective). If the procedure you are wanting to monitor isn't in the list it may be that DPA captured it but, it isn't as high of a wait time and is therefore way down the list. The other thing to note here is DPA stores the…

">mbrethou bring up an excellent point. I sent an email to the product managers for DPA and to DanielleH‌to add MySQL to the content exchange categories. For the deadlock alert I think we should also be able to help there given some time. DPA has a rather extensible way of adding custom alerts and metrics. Let me get the…

When you say you have a report are you talking some customer SQL ? Care to post what you are using or some code ? We can help is we can see an example better.

There isn't a way to do this in reports currently though it has made it to the What We Are Working On for DPA (Updated June 9, 2015)‌Page. "Reporting on Resource Metrics". The closest thing I could suggest for now is going under the trends view drilling into a time you want to see resources for and click the resources tab…

The Database instance availability alert that is built in has some added parameters to it that are not very obvious that you can try changing. They are found in the options menu and described in this article.Success Center Most the time the issue is not that it give false positives but, that it doesn't go off as much as a…

skenow​, To remove any of the instances and the data from them in DPA you would go to options -> monitor setup tab -> "unregister" this is under the database instances section.

These cases were both solved by the following. We are adding a KB with the steps but, posting here for anyone landing on the thread. There is an advanced option that by default disables blocking information for Oracle RAC systems from being collected. To Turn this on, go to: Options->Administration->Advanced Options->DB…