Comments
-
Options -> Administration -> Advanced Options DB Instance Options tab, select the instance you want to change polling on, check the support options checkbox Scroll down or search for QUICK_POLL_INTERVAL This option is in centiseconds. However, the dropdown will auto adjust the centiseconds once you choose the desired…
-
Good question. This may come down to an architectural issue within your specific environment, but generally speaking, we have to get a jdbc connection to the instance. So we need to be able to reach the listener (sometimes the admin interface is not being listened on). Since we are agentless, this would be a requirement.…
-
Capacity planning comes out of the box with SAM (an Orion module for servers and applications). However, you could create a custom metric in DPA to show overall storage usage. What databases are you monitoring (Oracle, SQL, other)? For top SQL, you can query the summary tables (it's going to be a LOT more performant than…
-
Currently the reports are rendered by a separate engine than the trend view. At this point, you are going to need to do a manual workaround. Let DPA choose the top 15 sql hashes and copy off the hash values in the report. Once you have the top 15, you can then edit the report definition to be user defined and paste back in…
-
99.99% of the time when we get this it is something with the environment in which DPA is trying to authenticate against. Just because the wizard succeeded, doesn't necessarily mean that things are configured correctly - just that syntactically, you got inputs correct. After you integrate with AD, are you able to search for…
-
What database platform is your repo on? Oracle or SQL Server?
-
What product are you using? If DPA, it would be a custom metric. Something like: SELECT cntr_value FROM sys.dm_os_performance_counters WHERE object_name LIKE '%:Databases%' AND counter_name = 'Data File(s) Size (KB)' AND instance_name = '_Total'; Or use whatever you are comfortable. I'd think you could just run this once…
-
Might you be referring to setting up custom alerts/metrics? 9.1 actually added some additional alert, none were removed. I'm not familiar with canned alerts/metrics that you describe, so wondering if someone in your shop set them up as custom? Take a look here and see if this is the content you were looking for... Database…
-
The best bet with DPA is to drill into a day. Set the interval you are viewing to 1 day. Click on the bar. Go to the DB user tab, click on the user you want to research, then click on the objects tab. This will set your context to a timeframe, to a specific user, and then to see what objects they reference. This may not be…
-
Hi Fabian and welcome to the DPA family! We do have an alert group functionality, but it is not currently connected to grouping on the home page (does not carry through). What you can do though is define a group of instances within the alert group tab - it will run the list of alerts you define against the instances you…
-
Do you mean you don't want to set up another SQL Server instance for the DPA repo or ? Not sure what you are asking, but in general, the reason we don't recommend registering the instance holding the repo for monitoring is that's where we do our heavy lifting. You can certainly do so, but you will see a lot of activity of…
