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…
I want to list all MSSQL Indexes which are unused from the last system restart and compile them for a cleanup. Could you please suggest if we could query DPA database to get the details.
Hi, As of right now, it appears that there's some kind of max rowcount threshold for automatic Index Analysis. Large tables don't seem to have their fragmentation analyzed by SQL Sentry. I completely understand the rationale behind having such a threshold. However, what I don't understand is why isn't this threshold…
Hello - We are evaluating our SolarWinds performance, specifically with node summary pages loading a bit slow, and one of our DBA's raised this question. They found a fair amount of commonly hit queries that have no indexing. Estimated ‘Improvement Proposed Index 99.97 CREATE INDEX <Name of Missing Index> ON…
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?
Page Life Expectancy (PLE) is a metric often used to determine the health of the SQL Server buffer cache. A low PLE value indicates pages are not staying in cache very long and could indicate a variety of issues. My experience is that many people alert on a low PLE value, but then do not have the data to understand what…
As databases and applications evolve, some indexes may no longer be needed. Since indexes affect performance when rows are Inserted, Updated or deleted; Identifying unused indexes and removing them would boost performance. Another benefit would be memory and disk storage savings.
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…
I find that when a certain report is displayed in the "Custom List of Reports" resource, the resource will not display correctly. When I click on the error details link, the resulting screen displays the "Index is outside the bounds of the array" message. Removing the report enables the List resource to display correctly…
It looks like you're new here. Sign in or register to get started.