Sql Server dba duties/checks list

Question

Sql Server dba duties/checks list

Juanita

SSCertifiable

Points: 5300
More actions
November 15, 2004 at 10:35 am

#163075

HI,
I'm constructing a daily duties/check list and I wanted to see what suggestions I can get from all of you on what should be checked on daily/weekly/monthly basis. Things from performance, indexes, space usage, etc.
THANKS SO MUCH !
Juanita

Viewing 13 posts - 1 through 12 (of 12 total)

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

Francis Apel SSC Eights! Points: 918 More actions · Answer 1

I'll check my files and get back to you on this. Just a suggestion: this would make an interesting article once you are done.

Francis
-----------------
SQLRanger.com

sa24 SSCrazy Eights Points: 8027 More actions · Answer 2

Below are some of the responsibility

Full/Tran Backups

Space Requirement

Fragmentation

Security Audit

We have scripts which generate reports for all the above duties. We check backups and space reqt. daily, fragmentation weekly, and audit every fifteen days. But i think it will largely depend on your environment. If you have lot of activities going on against your database, you might want to view your fragmentation more oftenly. We have huge data loads over the weekend and after which we re-index our databases. Over the week we don't have much activities and we check our fragmentation before the loads to make sure that if we need to re-visit our re-indexing strategy.

Juanita SSCertifiable Points: 5300 More actions · Answer 3

Thank you very much. Can i ask what utility you use to do the re-index, delete then recreate or just fix in place?

thanks,

Juanita

barsuk SSChampion Points: 12280 More actions · Answer 4

In addition you can/should monitor:

Logshipping (if any);

Replication (if any);

SQL Server logs;

Events Logs;

Failed Jobs;

Space Issues.........

I have over 15 items in my checklist, but as it was mentioned above, it largely depends on your environments

Juanita SSCertifiable Points: 5300 More actions · Answer 5

Thank you for the input. I was wondering how often DBA's reboot their sql server boxes? Should this be done on a regular basis or only as needed for upgrades, security updates, etc.

Juanita

Taj Mr or Mrs. 500 Points: 596 More actions · Answer 6

Ideally very minimal. But Hey, this world is not ideal. Thanks to Mr. Bill Gates.

The fact remains whenever we cant find a solution to a problem we fall back on our last resort and that is too reboot and as we all know it works many times too.

If the reboot is not warranted like you mention with "upgrades and patches" then I would not recommend to reboot. Rebooting also have a performance hit as it clears cache too.

Tajammal Butt