ciulei

Can I vote 3 times?

Before joining a team focused on enterprise monitoring and alerting, I was a DBA (junior level). The experience has been invaluable in my new role. From troubleshooting performance problems (thanks DPA!) on a new SolarWinds database server, to evaluating query performance (thanks SSMS!) of custom SQL alerts in SolarWinds,…

Ideally, we'd have a central management console, but I'd settle for some effective queries. 

It's been a while since I broke out the ol' Performance Monitor... Let the distraction commence! Over a 10 minute (non-maintenance) window today, we averaged 2300 writes/sec and saw a maximum around 29000 writes/sec. Three zeroes on that 29; some pretty stout IOPS right there. Average write latency was almost nothing, and…

...and needs to work on an instance generating 3500+ transactions per sec on the DB.

I believe I have located the data in the DB, but didn't have time to figure out the SWQL equivalent. Would be great if someone from SolarWinds confirmed. SELECT nd.Caption ,n.DisplayName AS ThresholdName ,s.Name AS StatName ,Warning ,Critical ,InstanceId ,ThresholdOperator FROM thresholds t inner join ThresholdsNames n on…

In theory, your method should improve efficiency (and it does in the original example), but in Josh's second example above, the plan SQL Server is using to execute that query is more efficient in its original form. I even tried using BETWEEN with both date computations and the original is still the best option. As our…

Here are some visuals on the improvements, as seen in DPA (we made the change at 10:30am ET, May 1): TOP SQL WAITS TOP WAITS TOP SQL - 10am Hour Pay attention to the scale of the blocked session graphs below. Blocked Sessions - Pre-Change (weekday previous) Blocked Sessions - Post-Change (weekday following) TOP Blockers -…

Thanks for the feedback, all.

Yep, I was given the wrong password. Details strike again.