vrkvvj · Senior Engineer · ✭✭✭✭✭

Well, not sure most probably a feature request. Though i doubt this will surface in near future as neighnor table is volatile in nature. I can think of a custom solution but that is high maintenance, not one time setup.

I think you can use copy components from other template option and create a new template with all the component monitors you need without creating them again. It is available in SAM 6.5

Do we have any thwack custom pollers/UnDP to monitor the same. We have a lot of devices with viptela routers which miss the data for forementioned parameters

yes, i came to know that the hard way. I am using the DPAIM for now. But the other suggestion is pretty good, to make use of another DPA instance. Thanks for that!

Wonderful, Thanks a lot. I know there is a table with metrics name but wasn't wise enough to look into it and was trying all hard in a roundabout manner.

Hi @"mandevil" yes, I understood. The string values can also be used if we try 'Custom SQL Alert - Single Alert Status Return' alert template. i also tried with 'Custom SQL Alert - Single Numeric Return' template via below code. Still results are not accurate and alert randomly. SELECT CASE WHEN COUNT(*) = 0 THEN 0 WHEN…

Update - Tried both ways, Status and Numeric return. no luck. Going with DPAIM

using above - I have created alert where the query calculates the total memory usage (disk reads + buffer gets) over the past hour and determines the memory usage percentage for each SQL query, including details like SQL text, database name, application name, and username. It then filters and lists all the queries…

let me test and know results by next week

ok, you want me to check for Custom SQL Alert - Single Alert Numeric Return type alert.that was my plan, but can test next week

This is what i have with me. Hope this helps Please find below table details/information. CONSW : It is the master table for referring sqlhash and planhashes and other stats. It stores only 30 days of data CONSPT : it stores the plan details of queries for SQL Server CONSS : stores the statistics of queries CONST stores…

Yes sir, please help to guide me 

i dont think so. DPA is not as flexible as its core platform. Only Contacts are eligible for mail notification and Contacts do not have variable information. Only i can think of with one alert is for about 6 groups as we have 6 notification levels. In latest DPA, we have Custom SQL Alert - Single Alert Status Return so…

Yes, this custom query looks super useful!

After digging more, i came up with below and works for me! DECLARE @monitorID INT; DECLARE @FROM_DATE DATETIME; DECLARE @TO_DATE DATETIME; DECLARE @SQL NVARCHAR(MAX); DECLARE @User NVARCHAR(100); DECLARE @Keyword NVARCHAR(100); DECLARE @ClientName NVARCHAR(100); -- Set the monitor ID and date range SET @monitorID = --id of…

Ok, I did a catchup with app team and they say as a batch the query runs for quite sometime. But as you said these doesn't seem to cause any issues.

Yes, I heard of that. However cannot use it where I work and want to see if DPA works for these scenarios 

As per application team, they do run the stored procedures in batches. Like in SQL script they do have 20-30 sps triggered at once. However when I check in Find SQL or run a report with keywords wouldn't find them in DPA. If ran separately those are visible 

Well, I am sure we do not have Sentry in our environment. I have raised a case, so lets see if they can provide any insights to it.

Hi @"mandevil" - thanks for your response. However, issue here is not pulling the report for top procedures. But to have DPA capture the SP's or individula SQL statements run from that Batch. Does it have to do anything with permissions?

Might be a lot late, anyways i would start as below SELECT --COUNT(*) AS 'Statistic', -- CASE WHEN THEN 0 END AS Statistic, 'HelloWorld' AS 'Message' FROM WHERE Hope this helps

even i am facing hung issues for poller checker tool. Is it still in use in 2020.xx versions?

Even after rebuilding the website you are facing same error, then try calling for them. They might try checking the error logs, db connection erros, subscription errors, or re-install the microsoft dot net required for your current SW version and try again rebuilding the website during the call. Mostly website should be up…

If you are asking that team has manually bring down a BGP, then automatically the status along with description goes down in Solarwinds. So I am afraid i do not have solution for that. If you ever found do let us know

pratikmehta003 - Yes it should work anyhow i haven't tested for interface but did for components in SAM module. You can test it by giving small values and alert yourself to confirm

Yes it should work

I haven't worked on it. But if I were to then i would suggest you to try below steps. * Use Custom properties for those selected interfaces and try to filter them out in topXX interfaces by percent utilization resource * If the topXX interfaces by percent utilization resource doesnt work out then try with custom table and…

Just now saw that you have created another question reg the same and tried rebuilding website along with support ticket open.

bharath08 Generally below parameters i have monitored earlier availability of the array/LUN free space of the thinLUN if you have VMAN module, go with datastore free space parameter(which will be very useful) Hope it helped.

Got the required output. Thank you xaturbatu