The most recent content from our members.
Ideally, database queries use the fewest possible resources: time, memory, bandwidth, etc. Lower resource consumption maps to better query performance. To find relevant data in a table, a database query relies on lookup operations, and a table index can help a query efficiently find the table values it needs. With an…
One of my favorite consulting questions to ask when dealing with a scalability problem is, “If you could change the system design with the knowledge you have today, what would/wouldn’t you change and why?” Sometimes it’s best to ask this question on a one-on-one basis with different developers, DBAs, report writers, and…
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…
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…
As an accidental DBA, I'm having trouble determining how to handle maintenance on our Orion DB. When using the built in DB maintenance plan, the maintenance jobs inevitably end up running longer and longer due to HUGE amounts of data being dumped in a few tables daily. Eventually, the jobs run for days on end. The issue is…
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.
It looks like you're new here. Sign in or register to get started.