The most recent content from our members.
Hi, I'm attempting to use a SQL Server User Experience monitor against an Azure SQL Managed Instance. I've added the managed instance as an external node, with a dynamic IP but it seems when i create the template, it always tries to run the query against the Ip not the dns name, which i believe is why it then fails? e.g i…
We are working on configuring SQL Availability Group Health Monitoring using a PowerShell Script Monitor in SAM. Initially, the solution found here on THWACK was sufficient. However, we ran into an issue where we have multiple AGs running on a single instance, and each node is primary on a different AG. We need to be able…
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.
Is there any way to extract report for Database availability via Appinsight for SQL. I can get it for the individual database instance from report charts but for consolidated table reports I need help. Please highlight if anyone can help here
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…
Hi, I'm currently setting up Azure SQL DB monitor, and I'm looking for any input of best practices here. I believe there are two ways to monitor the DB metrics: * SAM powershell based monitor: https://documentation.solarwinds.com/en/success_center/sam/content/sam-api-poller-microsoft-azure-sql-database.htm * SAM API…
Hi there, First of all I'm new to this forum and kind of new to Solarwinds in general so bear with me please. When having a look at some of our monitored SQL Server instances I've been searching for two key default settings that I thought I would find in SAM for SQL Server, MAXDOP and Cost Threshold for Parallelism. Since…
Hey all, Ive got an app insight template that is green for eveything but Job Agent. I get the error..... No valid data was received. The SELECT permission was denied on the object 'syssessions', database 'msdb', schema 'dbo'. Invalid object name '#job_results'. Anyone get any Ideas?
Hello fellow THWACK users I am trying to setup an email alert in SAM - Appinsight for SQL when the database status changes from online to restoring or offline I cannot locate this in the Add new alert wizard 2. Trigger Condition Trigger condition is simple condition or set of multiple nested conditions which must be met…
It looks like you're new here. Sign in or register to get started.