The most recent content from our members.
We are SAM App insight to monitor SQL database. we need to report for database monthly availability, how can this possible ? .
Hi, I have dashboard of type Summary. I administer SQL Servers. I have group as 'SQL-DEV' which contains 20 dev sql servers. I want to add report on SQL Errors from all servers in that group to the main page (INFO, WARN , ERROR - not decided yet) with paging , limiting to 20 rows. All that info is contained in each SQL…
Hello all, I have been working on a script to assign AppInsight for SQL to nodes using the API. There was a great starter script on the GitHub but I'm running into a strange issue. When running the script I'm getting it to fully execute but it will only execute with a result of -1 regardless of setting the duplication flag…
Hi Folks, I need some help and suggestions in creating a specific Email notification that is sent to my email address only for any alert triggered by a single Application Template called 'AppInsight for SQL' to monitor a few SQL servers in my company. What is the most effective way to create a dedicated alerting system for…
Dear Thwack Buddies, Do we have any leverage to alert on SQL Events / Error logs that are being captured by Appinsight template..? I have checked the same & couldn't find any. Your help would be much appreciated. Thanks in advance. -Solaiy.
I've tried the following but I an extremely helpful error message that says 'Invoke-SwisVerb : Unable to create application' Invoke-SwisVerb -EntityName 'Orion.APM.SqlServerApplication' -Verb 'CreateApplication' -Arguments @($nodeid,$applicationtemplateid,$credentialsetid,1) -SwisConnection $swis When I tried to supply an…
Yesterday, we had a patching cycle in our environment where MS KB 5022289 was installed on our MS SQL Servers. Since then, all of our Databases have been unable to be polled correctly which leads them to be in the Applications with Problems section of our SolarWinds. In the KB Article, it mentions the following: This…
In my shop we have used AppInsight for SQL on our Solarwinds DBs for quite some time. Using credentials that I'll call MYDOMAIN\GeneralServiceAccount. We use the general account for a number of different tasks; I wanted to create a special account for our DB monitoring in order to reduce the fault domain for password…
The "Log Bytes Flushed/sec" component of an AppInsight for SQL monitor is down on some of the databases on 1 of my SQL 2012 instances. The description for that component specifically says, "Note: This is not available in SQL 2012.", so it shouldn't even be looking for those counters on SQL 2012 instances. So, I have a…
Hello, We have some database monitored with AppInsight for SQL and some of them are in unknown status with a message like Unable to establish SQL connection, check credentials. Login failed for user 'xxxxx'. i'm looking to create a report on all the database with this kind of message. Do you know where i can find this…
It looks like you're new here. Sign in or register to get started.