The most recent content from our members.
All SQL Servers under monitoring show: ------ Node is Up. AppInsight for SQL: Application 'MSSQLSERVER' has state: Unknown. ------ AppInsight for SQL - I don't know how to solve it((( Did you come across with that problem before? I provided all required permissions. USE master;GRANT VIEW SERVER STATE TO…
Can monitoring the busy SQL Server production workloads with multiple SolarWinds products lead to harm or even database corruption, resulting in downtime or at least performance effects? I have these products available under my current licensing scheme and would like to know if combining these products to monitor the SQL…
We have hundreds of SQL Servers monitored by DPA. However, metrics and thresholds fort problem conditions vary based on the App that SQL Server is associated with. We'd like to maintain multiple monitoring and alerting templates and associate them with specific server groups. In the same way Idera sql DM allows this…
My requirement is to list all newly introduced statements on my DB or Instance level, It will help to work on new query-wise review cost, plan, and execution count.
Hello, Anyone know how to change the SQL collation without losing any data?
Hi All, I'm getting many below error message even SQL Server is up and running. I don't find any errors in SQL Server Error log and in Event Viewer. Can anyone Help me out. Monitor for database [InstanceName] failed in job [QuickPollJob] due to [The query has timed out.]. Will attempt to retry every [60] seconds... Thanks
The other day, I logged into our SW SAM (6.3) instance, and found that about 30 SQLServer databases were alerting critically about their "Total Size" property. These databases ranged in size from 6MB to 300GB, and there is about 400Gb of free space on the volume on which they are stored. All of them were green on their…
Doing some integration work and ran into this. I ran this query – “SELECT * FROM AlertActive a INNER JOIN AlertObjects b ON a.AlertObjectID = b.AlertObjectID JOIN AlertConfigurations c ON b.AlertID = c.AlertID” Took 2:33 seconds to execute and return 2700 rows. I then did a estimated execute plan and 97% of the resources…
I am working on some analytical reports to fetch information about the Alerts that are ticketed in the Solarwinds Help Desk using SQL Server Management Studio. However, I noticed that we don't get the severity for Orion alerts ticketed in the database form the SQL Server Management Studio, this is with regards to the…
In the hope of getting more realistic settings for some things vs. the defaults I've tried looking at some of the automatically calculated baselines. The AppInsight for SQL has been running on the server for months... for some reason when I try to set the thresholds automatically using the baseline calculation I've noticed…
It looks like you're new here. Sign in or register to get started.