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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy