The most recent content from our members.
I am happy to announce the General Availability of Database Performance Analyzer (DPA) 12.0. This release focuses on analysis with two major features: Query Performance Analyzer (QPA) and Table Tuning Advisor. We have also improved our integration with the Orion Platform by adding blocking, deadlocks, and wait time status…
To kick off the Q3 systems releases, I am happy to announce Generally Availability of Database Performance Analyzer version 12.0. This release focuses on analysis with two major features: Query Performance Analyzer (QPA) and the Table Tuning Advisor. We've also improved our integration with Orion Platform by adding…
Create alerts based on DPA recommendations. Example: If a DPA recommendation shows a 75% or greater performance increase if "X" is completed, then alert someone. Such as adding an index or defragmentation.
By Omar Rafik, SolarWinds Senior Manager, Federal Sales Engineering Here’s an interesting article by my colleague Brandon Shopp about choosing a database tool to help improve application performance and support advanced troubleshooting. Given the importance of databases to application performance, I’m surprised this topic…
I was checking today my DPA portal and I found that DPA is recommending 3 nonclustered indexes on my FACT table. My confusion is that all FACT tables in this project have columnstore indexes on them. Does DPA support columnstore indexes? Is it really saying a rowstore index would be better than a columnstore? The query is…
It looks like you're new here. Sign in or register to get started.