kjamil

AI and Automation is not a new baby is an adolescent, I think we need to listen, guide and support the technology to grow successfully, (i have learned expert system when I was in the college @1994)

I will agree all above suggestions are wonderful to have, but when it comes to the database monitoring and performance analysis there are lot of good free tools out there, I think ...deep analytics and AI to discern hidden patterns and performance issue will put SolarWinds Observability on front line.

I am not just learning about SW product but Greek language too

Keen to take a look @ Observability, But 0% wondering why no one is interested

Week 3 and Jun 20 question I think the index advisor should be named differently i.e. (missing index assessment helper) because is pulling missing index information the world advisor can push junior DBA to blindly create the suggested missing index without further assessment for consolidation which column should be in key…

I love the analogy of wait statistics and response time BUT it is very very frustrating when DPA detect and calculate wait but does not contribute/maps it to a query.

Mr Fixer

Thank you SW, https://www.statista.com/ fantastic research site not only to help quid my learning effort on highly demanding technology also is guiding me to what car I will buy next.

Hello July- Congratulation to the June winners, I keep trying 

Any idea when this product will be available in store please * Anker® PowerCore III (10,000 mAh) *

Thank you so much mandevil, please do and if you need any details let me know or liaise with our account manager @Richard Mahony and thank you again for reaching out

from performance perspective and especially if you going to be running the query many times, try not to use leading % in your where clause especially when you have lots of nodes 10X because you do not want to be reading all the table into the memory every time. you can use = 'Orion.Nodes' see the highlighted query below…

Never too late..... Unfortunately no ER diagram or data dictionary, however SolarWinds do provide SWQL by mean to manipulate data, see below there is a very useful namespace and take a note of summary column. head hear for more information https://github.com/solarwinds/OrionSDK/wiki

So the DPA is not the Advisor is a messenger, hahah

Thank you, I have checked see Image 2 above unfortunately idle blocker has no text, also I see that this (commit) query is a booker

Thank you, I have mentioned both the DPA and the monitored SQL version in the 1st line - Microsoft SQL Server 2019 (RTM-CU25) (KB5033688) - 15.0.4355.3 (X64) Jan 30 2024 17:02:22 Copyright (C) 2019 Microsoft Corporation Standard Edition (64-bit) on Windows Server 2022 Standard 10.0 <X64> (Build 20348: ) (Hypervisor) please…

Thank you, This is a third party application and I can see only the workload/queries that the DPA does capture or by digging into the plan cache or setting an extended event. I am assuming if what you have said (Look for other update/insert/delete/merge queries running at the same time as the commits, and that's what's…

Hello enjoy the wood you are not disconnected any more, Benefit of thwack.

SQL Sentry does allow to run a trace or you can use extended event and track the RPC_completed, sp_statment_completed and sql_batch_completed and use causality tracking to be able to group by and see all the steps.