btuck · Principal Solutions Architect (Database)

Hey there @"selwonk11" ! I'd recommend opening a case with Support and they should be able to work with you to resolution.

Hey there @"Yasir150199" ! This screenshot looks like it's coming from the AppInsight for SQL feature in Server & Application Monitor (SAM). You might have more luck posting your question in that Server & Application Monitor (SAM) Forum. If you decide to explore SQL Sentry, it can definitely help you monitor the most…

[quote userid="304676" url="~/product-forums/sql-sentry/f/forum/100629/curious-memory-pressure-alert---sql-server-process-physical-memory-low/315718"]I believe it is triggered by the bit value in sys.dm_os_sys_memory, which is triggered by a signal from Windows.[/quote]Almost! The value is derived from…

Hey there @"alevybri" ! Changing the "Collect Trace Events" setting should be dynamic and not require a restart of the monitoring service(s). See my response to the main question for more information.

Hey there @"gflores1023" ! It looks like that documentation might be a little old...I'll get someone on it right away! I'd recommend deleting that row from the dbo.FeatureFlag table. It won't hurt anything to leave it, but it is no longer a flag that is used. The current method to switch from SQL Trace to Extended Events…

Hey there @"sooraj58" ! This scenario is fine if the resources allocated to host running SQL Server are sufficient, and a small(ish) number of targets are being watched. I wouldn't have both products on the same instance if you're watching, say, more than 50 targets. -BT

Hey there Greg! Good to hear from you again. Without going into the gory details around how SQL Sentry collects statements and matches them up, a "-1=RequestCompleted" event occurs when we see a SQL statement start, but we never see the "End" event for whatever reason. This is sometimes due to a long(er) running query or a…

Hey there @"gflores1023"! Jonathan Kehayias put together this great article that explains the differences. There are plenty of others out there, and the same generic reasons apply to the benefits of switching to XE for SQL Sentry. Since SQL Sentry now only supports SQL Server 2014 and higher, we no longer have to worry…

Hey there Greg! Thanks for your patience in getting back to you on this. This was a difficult one to track down and it took some work with the engineering team to get the last leg finished. In general, the Minimum Duration setting that you see in Top SQL Source is stored in…

You are correct that CU1 and later addresses the issue. The SQL Sentry documentation reflects that at documentation.solarwinds.com/.../sqlsentry_2023-3_system_requirements.htm.

Of course! Did this resolve your problem? Feel free to mark it as the answer if so.

Hey there @"zennifer"! In general, yes, you can host the SQL Sentry repository database, Monitoring Service, Portal, and Client all on the same host if you would like! For a smaller deployment of 10 targets, this should be fine as long as the host has sufficient resources. Take a look…

Hey there @"eaself"! On SQL Server 2022 RTM, FILESTREAM cannot be enabled on an instance that doesn't already have Always On Availability Groups enabled. SQL Sentry uses in-memory OLTP, which uses FILESTREAM, so it won't work out of the box. That said though, you can absolutely host a SQL Sentry repository on a SQL Server…

Hey there Rafael- If you're able to connect via SSMS from the same machine using the same credentials, then the issue is likely with the host discovery part of the connection tests. Can you try running Steps 2-9 from this post and see if you're able to connect via WMI?…

There was a hiccup in getting the release link updated on the page. 2023.2.7 should now be downloadable on there.

Hey there @"ghall_SSNC_Ezesoft"! Take a look at the Configured Actions List report that can be found at Reports > General > Configured Actions List. Anything not at the Global level has had some sort of change (override or disable) to it.

There is still plenty of love for Plan Explorer here at SolarWinds. While we haven't made as much progress as we would have liked with it recently, we are collecting feedback from the community on ways to enhance it and I'm hoping that we'll have some additions here in 2023.

Hey there @"gv6132" and @"kondrich"! Good news! The Plan Explorer add-in for SSMS 19.0.1 fix will be released here in a few weeks as part of the 2023.2 build. Keep an eye out for the release sometime in mid April.