ProActive DBA projects

Question

ProActive DBA projects

Siva Ramasamy

SSCarpal Tunnel

Points: 4026
More actions
September 19, 2018 at 3:59 pm

#379196

Hello All,
Thank you for looking into my question. I am managing SQL Server 2017 Enterprise instances on VMware ESX with a three node Always On replica for HA and DR.
What would you experts recommend on any proactive DBA projects that I can work on?
Thanks
September 27, 2018 at 6:09 pm

This was removed by the editor as SPAM

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398694 More actions · Answer 1

First, and most important, backups and backup testing.
Create a DR plan
Test the DR plan
Monitoring for availability, performance, behavior
Statistics maintenance
Get your databases into source control
Automate a provisioning mechanism for getting your databases from production to non-production environments after cleansing the data in support of GDPR/HIPAA/SOX/FERPA/CPP/SHIELD/whatever comes next
Change the cost threshold for parallelism on all the servers

Get all that set up and working and then I'll come up with a ton more.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Siva Ramasamy SSCarpal Tunnel Points: 4026 More actions · Answer 2

Thank you Grant.

I have some of them implemented already. But you have given me a handful list of projects to work on.

Travis Halsell SSC Eights! Points: 896 More actions · Answer 3

I like this topic.

I might throw out there in addition to index / stats maintenance that you need to be checking for corruption regularly as well! Also, a plan for when corruption strikes... get that on paper. Data loss plan as well. Are you logshipping? Do you know how to restore your logs quickly in the event that someone or something oops'd an entire table?

I think we should keep this running 🙂 maybe some of us will come across something we aren't doing but should be doing. Perhaps it will even be consolidated into an entire article.

Siva Ramasamy SSCarpal Tunnel Points: 4026 More actions · Answer 4

Thank you Travis. I am doing Index, Stats and DBCC using Ola Hallengreen's scripts.
I have also come up with a few projects on my own.
1. Security Auditing
2. Read-only routing
3. Database Maintenance Portal.

Travis Halsell SSC Eights! Points: 896 More actions · Answer 5

Siva Ramasamy - Tuesday, September 25, 2018 11:02 AM
Thank you Travis. I am doing Index, Stats and DBCC using Ola Hallengreen's scripts.
I have also come up with a few projects on my own.
1. Security Auditing
2. Read-only routing
3. Database Maintenance Portal.

I would be interested to hear how you plan on doing your security auditing as well as what the database maintenance portal entails.