Comments
-
Absolutely - do you have a favorite query to get the statistical value for estimated data loss? (I've seen a few out there online)
-
You can define two reports (one for each instance) and compare them over/under. That is one way. The other would be to define a group, putting both instances in question within that group, then click on the high level group. That will provide *some* combined views for you that may get you closer to what you are asking for.…
-
In order to use the license(s) available in your customer portal, yes, you will have to upgrade to 9.0. If you'd like to continue using 8.3, it's still supported and you can get extension keys from customerservice@solarwinds.com. For upgrades you have two options (in-place and out-of-place). Either way, a new set of bits…
-
Index scan = full table scan. Here's a good explanation from Pinal: https://blog.sqlauthority.com/2007/03/30/sql-server-index-seek-vs-index-scan-table-scan/
-
Unfortunately, right now, that is a feature request. We support email and SNMP traps. If you have an application that can receive an SNMP trap and convert to SMS, you could use it to send notifications...
-
Dianne, can you submit a support case for this one? This will involve editing some of our config files and getting into the details of how we collect resource metrics.
-
I added a custom alert out there for just this use case: Custom Alert - AG Data Loss Alert See if that does what you want or perhaps even customize it to your needs. HTH!
-
You can try using the reporting in DPA to create something like in this description: DPA Report on Stored Proc Impacts Just substitute in the string name for the SP name and it should find it in the SQL text. Just make sure it is unique enough so it won't pull in a lot of noise...
-
You can increase the detail kept by adjusting an option. On the homepage, select the action dropdown for the instance you want to keep more detail data for and click advanced options. If you are on 9.0, then you can click on the DB instance options tab and select support options (checkbox). Scroll down until you see…
-
Caveat - we are not an auditing tool and will not capture everything. We do sampling, so can exclude/miss inactive connections/very fast and infrequently running SQL. However, this may get you close. Let me know how it goes. Run this against the repository. You can pretty it up, use a cursor or TSQL to wrap some additional…
-
First of all, glad you asked! Understanding what you are seeing is key to successfully using DPA. So, let's jump in. The reason you can have more wait time than hours in a day is due to concurrency. Let's say you have 10 sessions that accumulate 10 minutes of wait time each all in the same hour, you would have 100 minutes…
-
If you have the query, you can create the custom metric. However, you need the query pulling the right info first from say SSMS.
-
It can monitor the following currently: Amazon RDS * Amazon RDS for Oracle * Amazon RDS for SQL Server * Amazon RDS for MySQL or Aurora However, if you are talking about the repository, you can see that we're more limited for RDS deployments (MySQL/Aurora): Supported database versions: DATABASEEDITIONVERSIONMicrosoft SQL…
-
Do you mind posting some screenshots so we can see what you are referring to?
-
Michael, currently DPA does not support monitoring SSAS. There's a different architecture in play (cubes) that we haven't tackled yet. If the underlying data for the cubes is coming from a SQL Server database, we can monitor that, but I'm guessing you'd like specific information more related to the SSAS engine... What kind…
-
Not sure about this one. We're querying directly against sys.dm_exec_query_stats for this data. Could it possibly be running in multiple databases within the same instance? Have you checked the job logic to make sure there isn't a loop or conditional statement causing it to run multiple times? I'm just wondering why SQL…
-
You are exactly correct. It's the aggregate for the top 15 X within the timeframe and context you are viewing in the UI. If you have fewer than 15 databases, that will represent all waits observed for your instance during our quick poll.
-
Can you tell us what platform the monitored instance is? Oracle, SQL, Sybase, DB2, MySQL?
-
Are you looking for something like this: Custom Alert - Fragmentation You can implement this as a custom alert and not use the canned one. That way you can edit the where clause and exclude ones that you know/expect high fragmentation.
-
You may have to do this manually or set up a job schedule to send it/ftp it. All logs are located in <dpa_install>\iwc\tomcat\logs They can be large if you have any threaddumps in there (*.hprof files). Otherwise, manageable. You can also go in through the UI, go to Options -> Support Tab -> Select "All Log Files…
-
Hany, do you mind opening a support ticket on this one? You can access support via your customer portal. Thanks!
-
There is an option in DPA (from home screen for the instance you want to change, select the action drop down and choose advanced options). way and look for CLEAN_DAYS_OF_DETAIL option. This will allow you to show 45 days of detail in your trend screen. The caveat to this is that your repo will likely grow an additional 50%…
-
At this time, Redshift is not officially supported. I have not tested, but I do not believe monitoring will work.
-
I believe what you are seeing is the compilation of the function. That is not the same as DDL. This is just how it's displayed when we query SQL DMVs. When it ages out of plan cache, a recompilation is forced. There are other reasons this occurs, which can be discussed as needed. Let me know if we need to go deeper into…
-
There are a LOT of variables that come into play on this one. Number of pollers and targets on the Orion side (now being branded as Solarwinds Core IT), number of instances monitored by DPA, activity/load of monitored instances, number of modules on the Orion side, resources on the SQL Server database server, performance…
-
Within any of the dimensions (tabs) at the top of the trends or timeslice views, we always rank them by highest wait time attributed. Meaning the top machines in your list are associated with queries experiencing the highest wait time. You can click on any of the machines in the list and see exactly what queries are coming…
-
Mark, there is a built in alert (alerts -> manage alerts tab -> administrative). Click the dropdown and select Database Instance Availability and walk through the set up. That should notify you that monitoring has gone down.
-
Couple of questions: * What version of DPA are you running? * How many instances are you monitoring? * Any recent upgrades or changes in the environment? * What are your retention settings set to for CLEAN_DAYS_OF_DETAIL? Go to Options -> Advanced Options (under Administration) -> Systems Options tab -> make sure support…
-
I have a feeling that this could get a bit more involved than just a quick click here kind of thing. 8 ) Would you mind opening a ticket for support to help you out? They can do a screen share and walk you through what we have available for reporting, how to group them, and how to schedule them. My only advice would be to…
-
For single metric alerts, we are expecting just one output (a numeric). For multi numeric alerts, you can have output as 1 alphanumeric and 1 numeric output in that order. In your case, we're trying to parse 2 outputs where we're only expecting 1. Try switching to multi numeric alert and you can have your first output be…
