Good to see more structured and technical content being shared. This will definitely help DBAs and data teams in real-world scenarios.
You’ve certainly sparked my interest! One of the most rewarding aspects of my role is the collaboration with our DBA—an incredible individual who truly makes a difference every day.
When I first started managing this environment nearly 15 years ago, we were battling over 3 hours of cumulative SQL wait time per day. We eventually had SolarWinds write an article about our journey because, with the help of DPA (Database Performance Analyzer) as our 'superhero,' we brought that wait time down to just 13 minutes.
I often joke that I’m 'dumber than a rock' when it comes to writing raw SQL, but you don’t have to be a rocket scientist to grasp the architecture of a healthy database. Attending a SWUG in Austin was a turning point for me; I got hooked on SQL Sentry (formerly SentryOne) and haven't looked back.
Today, our databases run with such precision that we can pinpoint a runaway query down to the specific end-user in real-time. We can kill the process, notify the user, and then sit down with them to find a more efficient path to the data they need. It’s no longer about reactive fire-fighting; it’s about proactive, professional stewardship of our community’s data.
Cisco ASR Devices.pollerCisco ASR Devices
SWQL is built on the framework of SQL and as such supports most of the standard clauses as part of a query. A very simple example query is: SELECT Caption, IPAddress, Vendor, ResponseTime FROM Orion.Nodes Dissecting this query is relatively straightforward: show some fields (Caption, IP address, Vendor, and Response Time)…
Active SSL Tunnels-ASA.UnDPThis poller *should* display the number of Active SSL VPN (Anyconnect) Tunnels currently connected to your box. However, I tried it with my 5520 running 8.0.4 and for some reason I get a OID Not Supported. Here's my post in the forum: *EDIT* This is confirmed working with at least Interm release…
HP ProCurve Switches Hardening check.xmlGeneral hardening for HP switches