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…
Indexes play a critical role in SQL Server query performance. SQL Sentry Fragmentation Manager helps you make intelligent decisions about index management based on the table and index information collected. In this blog post, I’m going to discuss index fragmentation, several ways you can identify it, and why a more…
These indexes are fragmenting in my new Solarwinds install. I have tried rebuilding the indexes, within a few minutes they are back at 99% Any ideas about how to fix it?
The checkbox is not enabled by default. Is there any reason one would not want to enable this maintenance on a typical deployment? What's the implication by turning this on? Does this enable the action during the regular nightly maintenance job?
I have AppInsight for SQL Server monitoring one of our production DBs running SQL Server 2012. We have a major issue with index fragmentation on this server and I would like to get statistics for [i]all[/i] indexes, not just the top 10 for each DB. I tried changing the performance counter Top Indexes for Database to…
I love the Appinsight for SQL server. One of my biggest issues is with the fragmentation counters throwing my databases it warning or critical states. The problem is with very small indexes a high level of fragmentation is not always a problem and most of the time can not be resolved with a rebuild/reorganise. I would like…
Hey Guys I have been getting some pretty slow responses from SolarWinds and it was advised to install SAM AppInsight for SQL to see if there were Database issues. The below image shows some very high fragmentation and this is after I run the database maintenance wizard and after we run our own de-fragmentation.
Description This alert reviews fragmentation details for all objects in the SQL Server instance - the SQL statement used is listed at the bottom of this article. By default it only returns objects that are more than 30% fragmented, but that can be modified as needed by changing the SQL. The thresholds below in this alert…
It would be great if AppInsight for SQL could be configured to ignore small indexes for fragmentation. Indexes with only a few pages are likely to be fragmented and there is nothing you can do about it - nor is there any real performance impact due to their small size. I would love for you to be able to set a "Number of…
NPM and NCM tables on a dedicated SQL instance using Windows Server 2008 R2 Standard on a NPM 10.4 and NCM 7.1.1., are averaging over 90% fragmentation. Therefore, we've scheduled index rebuilds, and given we are using standard version, see that online rebuilds are not possible. Given that, wanted to see procedurally if…
It looks like you're new here. Sign in or register to get started.