August 9, 2024 at 11:20 pm
This was removed by the editor as SPAM
August 9, 2024 at 11:21 pm
This was removed by the editor as SPAM
August 10, 2024 at 12:00 am
Comments posted to this topic are about the item Getting and keeping fit
August 12, 2024 at 2:11 pm
Where I work, our DBA team developed a "system outlier" report that's similar to Brent Ozar's sp_blitz.
It's a powershell script on a daily schedule that polls each server, running 100+ queries looking for things like failed jobs and logins, DDL operations, non-default server or database settings, disk space below threshold, error in mssql log, etc. that deviate from a baseline and have not been added to an exception list. The results are posted to email and a Slack channel making it easy to review.
The configuration table where SQL statements for each outlier are defined also incudes a URL linking to an issue specific Confluence page, where we document how to resolve the issue.
It's a game changer.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply