The most recent content from our members.
Can anyone help me with query to fetch CPU peak % (last 2 hours) for any specified database node either from DPA reporting database or are any APIs available to fetch this information.
SolarWinds advises in their documentation that LA can handle 1000 Events processed per second, 3.6 million per hour and up to 90 million per day. However, as far as I can see, there is no way natively in SolarWinds to see how many events, syslogs, traps, etc, you are receiving per second/hour/day. This makes it difficult…
This should be a simple metric on everyone's Dashboard by default, especially as a manager. I have not yet been able to figure i tout: I'd like to show a list of each agent's name and how many tickets each agent marked "Resolved" in the last day - or how many other days I pick from the filter. Sample: In the last day:…
Hi All, I'm trying to monitor SQL Managed Instances I found the following https://thwack.solarwinds.com/product-forums/server-application-monitor-sam/f/forum/91848/how-can-i-monitoring-backups-jobs-in-azure-cloud so it looks to be possible using API polling. I…
Description The query below will provide detailed metric values for any metric in the instance, e.g. the metrics shown on the Resources tab in DPA> Query DECLARE @DBID varchar(100), @MetricName varchar(50), @SQL varchar(1000); -- change the instance name here, matches the name shown in the Home page SELECT @DBID = ID FROM…
It would be great to use the API call response not only for getting the values but also the "Display Name" of that value to have a dynamic display name.
It would be very useful to be able to select more than one node/interface/volume/group/etc. at a time and drag a metric over to the workspace. For example: - Select four nodes from the palette - All of these nodes share the Response Time category - I grab the Average Response Time metric and move it to the workspace,…
I have been assigned a task to monitor the database of our company. We have around 25 SQL servers and I am currently looking for a tool to monitor the best. The major KPI's that we want to monitor are 1- CPU Wise Most Expensive Queries 2- Queries Having Most Physical Reads 3- Long Running Stored Procedures and Scripts 4-…
I have noticed that many of the labels and for metrics in charts are cut off on the right side. If you need to add the same metric from another server, or add a different metric from the same entity, it can be time consuming to find and re-add the correct entities back into the Metric Palette. It would be awesome if there…
Description This custom metric will collec the current free space for TempDB as a percentage. Metric Definition To create the custom metric, click on Options > Custom Resource Metrics and configure the metric similar to this: Database Versions: <no limitations> Display Name: TempDB Free Space (%) Description: <add your own…
It looks like you're new here. Sign in or register to get started.