The most recent content from our members.
Greetings All. Background: SW HCO Self-Hosted 2024.4.1 DPA configured and appears to work as expected. One SQL instance monitored with AppInsight for SQL and DPA. I have recently un-registered my DPA server and re-registered with DPAIM. Displays seem to work fine, except... Top fragmented indexes (Clustered and…
Greetings All. I'm confused about something. Working on setting up / modifying some monitoring for a SQL server, using AppInsight for SQL. Looking at this document for requirements: https://documentation.solarwinds.com/en/success_center/sam/content/sam-appinsight-for-sql-requirements-and-permissions-sw1273.htm About a…
Something I ran into when we added our Orion SQL instance to SAM: The "AppInsight for SQL: Alert me when my database file is running low on space" alert fired on the file "SolarWindsFlowStorage_NTAFLOWMEMORYSTORAGE" in the "SolarWindsFlowStorage" database. That file is a "FILESTREAM Data" file, and thus the file…
SolarWinds version: Hybrid Cloud Observability Advanced Enterprise Scale: 2024.1.0 We need to monitor multiple instances of SQL Server, but the monitoring result is not the same, below I list my instances to monitor, could you tell me if there is any restriction with the following versions:…
Hello all, I am setting up AppInsights for SQL and had a question. I only want to monitor the application database in the instance. I'd like to exclude the standard DBs like master and there is another DB that is used by a 3rd party. Is there a way to exclude DBs from monitoring with the AppInsights template?
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.
This is the yearly question about MSSQL Always On AG's and the lack of ability to monitor them sufficiently. How can they be monitored in SAM? I end up with 51 unknown applications. I have 150 SQL Db servers with a mix of standalone, clustered and Always On. I have AG Db's with dozens of availability groups that I am not…
Hi AppInsight for SQL currently give us what SQL version and Product level we are currently on. Product version can be either "RTM" or "SP2" etc. From SQL 2017 and forward there are no Service Packs released but updates use CU-Packs instead. They are listed with SELECT SERVERPROPERTY('ProductUpdateLevel') and can…
The overall status of the secondary AppInsight for SQL is always showing an Unknown Status. Update the AppInsight SQL template to support Always-On to identifying databases that are in a secondary condition as a valid status.
Hi All, I've been looking for good explanation on how to count the AppInsight component usage, and best practices on how/when to use them. AppInsight for SQL is nice with all the metrics that we can get out of it, the problem is the AppInsight component count will scale up with the number of databases in the assigned…
It looks like you're new here. Sign in or register to get started.