SQL Homework – January 2020 – Create an End of Year/New Year checklist.

Leave a comment

January 5, 2021 by Kenneth Fisher

It’s a brand new year and hopefully it will be better than last year. While that may be particularly true this time around, really, wouldn’t it be nice if every year was better than the last? One way to help with that is checklists. Well, documentation in general, but in this case we are talking about checklists.

So, since you’ve probably just finished up a series of end of year tasks, and are now starting in on your new years tasks it’s the perfect time to write them down. What kind of stuff do I mean? Well, how about something like this as a starting point.

  • Review min/max memory for each instance.
    You may have increased the memory size over the year and forgotten to update this setting. Now’s a good time for a review.
  • Review instances for databases that are no longer in use.
  • Review databases for objects that are no longer needed.
    Backup objects (tablename_20190125, spname_20180503, etc) are a great example.
  • Did the job that legal makes such a big deal about finish correctly? You know, the one that takes a full backup, stores it to a long term retention area, and gets rid of the 7 year old backup?
  • Were there any problems with any other special end of year batch jobs?

Anyway, you get the idea. Anything you did special over the last few weeks and that you plan on doing in the next few weeks is fair game. If you have the time you might want to add some review tasks. Make sure everything is where you think it is. You might even need to generate some data collection tasks (index usage for example) so that you have it for next year to see what, if any indexes are completed unused and can be gotten rid of. Heck, you might even add a task to review your existing documentation and make sure it’s all up to date.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,753 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
%d bloggers like this: