The most recent content from our members.
Hi, we use DPA 2025.2 with some multi database SQL Server. On one of them we get an error 422, if we open the Tuning section in DPA. The index advisor is empty and in iwc.log this: ERROR (2025-06-26T14:57:02,930+0200) [https-jsse-nio-443-exec-2-rest-229] RestExceptionHandler:371 - RestResponse{data=null,…
Additional Alert Notifications SolarWinds is thrilled to unveil our latest integrations for SQL Sentry and Database Performance Analyzer (DPA) with ServiceNow® and PagerDuty®. This much-requested enhancement promises to extend your alert notifications, making your IT operations more efficient and responsive than ever…
I'm new to SolarWind and I have a question in Tuning Advisor. Does this mean it advise me to create another non-cluster index ? The table already contain cluster index on columns OrderNo and TestCode. And non-cluster index on columns ReceivedDate, HN and OrderDate. When I press Show index DDL. This query message display…
DPA 2024.2 Release SolarWinds proudly announces the general availability of Database Performance Analyzer (DPA) 2024.2! You can download the latest version of DPA from your customer portal. This release includes PostgreSQL workload analysis by bringing the much loved and very powerful DPA existing features for SQL Server…
Version: 2022.3.7963In the home page, there is a red alert on tuning(Critical Tuning advisor detected), click it , there is not critical issues today, there was a critical issue several days ago,how can I do the settings , and not to show red alert if there is no critical issue today?Thanks.
There are a lot of performance guides on how to setup IIS and its configurations, however I'd like to understand how people configure IIS on their Additional Web Servers (AWS) in their SolarWinds environments. https://docs.microsoft.com/en-us/windows-server/administration/performance-tuning/role/web-server/tuning-iis-10…
I've been using DPA to tune my SolarWinds. I've been annoyed by WRITE LOG as the chronic #2 wait time. All SQL volumes were already on all flash storage and being bound by the application there wasn't much else I could do to tune performance. After researching this type of wait I read an article about a SQL option called…
When adatole posted his The Ultimate CPU Alert we all cheered. His alert successfully paired CPU utilization and CPU queue length to accurately measure true load on a Windows server. His alert successfully unlocked the mystery of CPU utilization to a whole generation of Thwacksters. Scores of administrators implemented…
As promised in The Ultimate CPU Alert - Reloaded! this post details the steps required to modify The Ultimate CPU Alert ... for Linux! As a recap, as our environment grew we started to notice database performance issues. We invested in new hardware to get us from RAID5 to RAID10 on SSDs and, while performance definitely…
DESCRIPTION This custom report will provide key statistics that may help in the SQL statement tuning process. To use this report, run it from SQL*Plus while connected to the Ignite repository database. SQL*PLUS SCRIPT accept table_name prompt 'Enter table_name: ' set pagesize 999 set linesize 132 set verify off column…
It looks like you're new here. Sign in or register to get started.