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.
Huh, and here I thought it was kill the user, not the process. Guess I have some apologizing to do!! 😯🇩🇪🇦🇩 😵
You make me laugh!
I'm going to take a look at this.
Alert Cleared.htmlHello, I would like to share the HTML template details we have prepared so that Solarwinds alarms can become more meaningful. It can list alarm object details and connected device details separately in HTML template. Except for object and device details, you can easily add custom property information…
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…