gnorris

Further to the above I question if the "Minimum Size of index to Retrieve" actually works. I received (pun intended) and warning alert for an index on one of our SQL 2012 servers. I investigated and found that the index space is 0.031MB (well below 1024 KB) at table level, Further, there does not appear to be a storage…

bump.. please send the link to this to all your SQL buddies.. even those that do not "yet" use Solarwinds.. We really need this functionality.

I found it. - this is WRONG.. this is looking at the TABLE size not the index size.. Dear SAM please fix. please replace table size with "Number of Pages" for the index. then we can ignore indexes less than out nominated value.. Yes we would also like to ignore nominated Tables. ​

Bump for February 2018 There are many volunteers that will assist to make this happen.. Just ask us..

I had our Solarwinds database on an AG but found that its high level of activity was affecting the performance on both nodes. All transactions have to be applied to both/all replicas so there is a load to 1. apply a trans and 2. replicate it. Further, as the level of transactions is high the log grows to a monster in AG. I…

As a DPA user and Whovian - why can't I se tomorrow's question?

I find that it is not an enable/disable problem as much as most monitors are TOO SENSITIVE.. Ergo when we apply a new application and configure it to be monitored ALTERS GO CRAZY giving the impression that the application is faulty. If we had the option to activate an alert where we feel it could be an issue then this…

Hi There.. I did want to say that I really support the DPA. DPA provides great in-depth information in real time and convenient drill downs into queries and plans. The graphics are appropriate and provide long term comparison making new issues stand out. Thank you

I would like the ability to activate a mute from a SQL Server Agent job. (yes a PowerShell script would be lovely) Currently the alerts go silly because during the Database Check process all responses are slow/stopped and alarms go off and emails sent. Likewise for other maintenance tasks that are variously timed and…

Still an issue Susie? We had to do this for a server migration and have a solution if you are interested.. I will have to go dig up the alert details etc if it will help.

Just a thought. Having configured and been monitoring 20 AGs in Solarwinds for 6 months now I think all that is needed is to include HADR items in the "Virtual server" that Solarwinds already shows. For example, in the SAM "AppInsight for SQL" instance page there are details on Application, Databases, AppStack Environment…

Friday Bump! B U M P !

I is interesting that we are each on our own in this monitoring situation - even from Microsoft. I went to failover a AG Group the other day to do some maintenance on one node and the failover FAILED. The failure was due to a database that had fallen out of synch on the secondary. I now have to examine the primary AG…

I tried to do the survey and it asked for contact details.??? I am logged into thwack - you know my details. I won't fill out forms of such detail repeatedly. Sorry I do want to help but my time is precious.

I don't know if I have deleted anything because it is not there to see/know! Considering the need for compliance with regulatory and corporate requirement that data be retained for a minimum period we would benefit from the knowledge that "deleted" items are still recorded but in muted mode. I propose that SW consider NOT…

Can we PLEASE get a flag in the AppInsight for SQL monitor to indicate that the App is actually mounted in an availability group. What this would do is direct collect the database names from the availability group and not the server. This would relate only activity on the databases in the group and not every database on…

Actually - What I see as needed here is the ability to nominate how many (MIN) pages in an index before alerting. For example out of the box SolarWinds alerts at all indexes that are fragmented. For some databases they are always going to be fragmented because of the nature of their purpose (monitoring database for…

Selectable statistics collection phase. We have hundreds of databases and to collect data for a longer historical period across the board would be a huge undertaking storage and network wise. The idea has merit though as I too noticed that it is difficult to make decisions on just 24 hrs of data. Considering what is…

Support did a remote connect and identified that the "renamed" availability groups caused mismatches in the auto-matching process and that each pass re-set those that were not assigned. A solution will be found. Only occurred where there was "re-naming" so I will call this resolved. Thank you SW local Support.

Yes we are in demo mode. The some servers were "renamed" in solarwinds to be more appropriate. Ergo they differ to DPA server names. The mapping held ok for a week. It is just the last couple of days that the mapping has dropped out. I would have thought that the mapping was stored in a database so why dropping off? It is…

The example above is taken from the SQL Error log. As I point out - the issue is determining how to determine an error.. The DBCC CHECKDB process outputs a log entry regardless of the outcome - good or bad. So, the only way to determine an error is to scrape the output for where it does not have "Found 0 errors"

Here is a sample log entry for a DBCC check. I've tried writing a scan for results but it is very dynamic and not simple to do with SQL query. DBCC CHECKDB (DemoDatabase) WITH all_errormsgs, no_infomsgs, data_purity executed by domain\svc_SQL_AGNT found 0 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 1…

You can try here for information on TempDB log full. https://www.sqlservercentral.com/Formums/Topic1776300-2799-1.asp I hope you have room to grow the file or extend the disk.

Can we have the comments in Date Descending mode/option on all forums please? Having to scroll through years old information is confusing and frustrating.

Hi Can you clarify what it is that you are after Amarnath? the AppInsight for SQL does all you ask for.. What I am after is another AppInsight for DEVSQL, I want to set much broader settings so much less alerts. Currently I spend most of my day changing settings to calm Solarwinds from DEV machines going CRITICAL because…