Comments
-
Good idea. The advise table would be CONSPA_X where X is the number from COND of the monitored instance. I didn't find an alert but, there are two reports here on THWACK that might give you a start on a draft. Custom Report - Top Plan Advice Top 20 Advice SQL
-
There is a purging job called the cleaner service that runs nightly. This removes data in the detail tables that is older then the CLEAN_DAYS_OF_DETAIL setting that gcp mentioned. The table CONDPRM should have a LR_CLEAN date for each monitored instance. Do open a case and send the logs to support.
-
It could be that the plan hash didn't change so DPA is not gathering the plan text. If you clear the plan text from the database it should force the new plan text to be recollected. select id, name from cond; -- note the id for the instance name in question select PLAN_HASH_VALUE,PIECE,QUERY_PLAN_XML from conspt_<id from…
-
DPA doesn't install a default SQL express. It could be you pointed the DPA installer to an existing SQL express instance. Out of the box DPA only asks for a database type to connect to either SQL Server, Oracle or MySQL. It does not install any of them, however. Just wanted to clear that up for others that might see the…
-
12 minutes seems odd. DPA should pull the time from the Application server local time or from a property in the system.properties file. Can you perhaps check the server time or try following this article to set the time zone ? Time zones in DPA - SolarWinds Worldwide, LLC. Help and Support
-
Idle blocking comes up rather often. Look over this thread here on thwack also. Why do I see an "idle blocker" as a head blocker? How can I find the cause? Other ideas here are as mandevil says in that thread "drill into Ignite to see when the blocking had started and see what that session had been running just prior to…
-
go to options -> instance monitor tab and do update connection info for this server and just update it to point to the new server IP address This would leave the information all in the same place in the GUI and you can have the license applied as it was. The name displayed in DPA may be the same for this instance, so if…
-
rottengeek, Really good questions. I haven't heard of that issue before. Are you saying you unregister the instance in DPA and don't see system_health track deadlocks after that is done?
-
This would be a question better posted for follow up on another forum on THWACK like this one Application & Server This is the section of THWACK for Database Performance Analyzer. That said the best bet is to make sure your MIB database is up to date and if the MIB you are searching for is still not there you can submit…
-
For anyone finding this in Orion Core version 2016.1.0 these settings were moved to the database and the setting listed above is no longer in web.config. You can find the value in the WebSettings table as ReportingTableViewMaxRowCount
-
You need the steps in this KB to set the email to the other port. DPA email overrides - SolarWinds Worldwide, LLC. Help and Support Though mandevilis also correct you can turn off HTTP traffic if you wish.
-
The mail settings for from should work provided the "From" address is a valid email format. It looks like you are using [Relay-DoNotReply] and DPA is filling in dpa@solarwinds.com because we expect an address in a valid format. something@domain.com for example.
-
mmuller, Most the time if there is data published for any SWQL Studio items or even how to query data in the Orion tables it is done on the Orion SDK wiki Home · solarwinds/OrionSDK Wiki · GitHub Most of what is found there will tell you how to get to data that is in Orion with the SDK and SolarWinds Information Service…
-
You can find the query_plan_hash in the repository. So if you run "Select name, ID from COND;" on the repository and find the ID of the monitored instance. Then use this value on as a replacement for the xx in the table CONSPH_XX example: "Select * from CONSPH_27 where PLAN_HASH_VALUE = 4468022644"
-
The reply to can be changed. On default mail server the from cannot. I would suggest if you can to change to a company mail server. This is found in Options-> Administration tab -> "Configure Mail server"
-
rottengeek, Did you recently upgrade DPA ? I had seen the video prompt come back after upgrade. On the custom chart displays this could also be from the upgrade. I think you mean you had custom metrics that are not displaying for you in DPA now. Some of the things needed for Custom metrics would be in the DPA repository…
-
">james@wi, You can find steps in this article SolarWinds Knowledge Base :: Moving SQL Server Data Warehouse Repositories. The screen shots do need an update but, the steps are the same. Take a backup of the ignite database -> restore it on the new server -> shut down the ignite PI service -> edit the repo.properties file…
-
This looks like some of the tables are not there for this monitored instance. It would perhaps be best to enter a support case on this one. If the schema isn't correct however you maybe able to have DPA correct the missing tables. go to options -> support tab -> Database query tool Run select ID, NAME, MONDBVERSION from…
-
martian monster, Good question. There is a whole blog that could be done on DPA LDAP and config I think. DPA had LDAP integration before it had the wizard that allows for it now. In the old days (pre 10.2) you had to edit a file manually that is in the folder path DPA home\iwc\tomcat\ignite_config\idc\system.properties…
-
It would have to be a custom alert. There is one here you could use as a starter Job Failure. Looking history so sys.jobhistory perhaps alter the SQL to only return if a count of jobs with run status = 0 is > 3 I didn't try it really but, looking to point you in the right direction.
