New Database request checklist

08 March,2016 by Jack Vamvas

You’ve just spent 2 weeks optimising a database for a new application, ensuring all the items on SQL Server Install Checklist are met. There’s a plan in place to scale for growth , a maintenance plan and an agreement to commit a health check once a month.

Everything is looking good. Then the owner requests if they add a new database , for a new third party application. As it’s there server – and are paying for it – they want to make it as cost effective as possible.

As a DBA you have a responsibility to complete some capacity planning and performance testing – but you’ve moved on to other projects. You don’t complete the due diligence. Before you know it this “small” database is ramping up with thousands of IOs and some complex queries “out of the box”, which you aren’t allowed to touch under the warranty agreement.

This is a typical scenario. That’s why it is useful to have a process in place where you ask some standardised questions to the requestor. These questions may lead to other questions, but the key is that some consideration is given to the impact of the database on the other databases .

The first step is ask if the third party has some documentation in place .

Here is a sample of questions. I normally get the requestor to fill out the details – as much as possible. I follow up with a meeting where we can discuss in detail.

 

Business App

Name of business applications

App Owner

Name of the Owner of this DB (approve changes etc)

 

 

Maintenance

What Backup Schedule ?

Maintenance

Is monitoring required ?

 

 

Database

Database Name:

Database

Collation (Default same as Server)

Database

Recovery Model (Default Simple)

DataBase

Compatibility Level (Default Same as server)

 

 

Database (Data File)

Data file Initial Size (MB)

Data File Autogrowth

Data File Growth (In % or Meg)

Data File Autogrowth

Restriceded File Growth ?

Database (Log File)

Log File Initial Size (MB)

Log File Autogrowth

Log File Growth (In % or Meg)

Log File Autogrowth

Restriceded File Growth ?

 

 

 

 

Security (SQL)

Do you require SQL login

 

Whats Rights Does the SQL login's require

Security (AD)

What AD groups require access To this DB

 

What Rights do the AD groups require (R/W/E/Other)

 

 

Misscellaneous

Read Only ? (Default No)

 

 

 

 

Database Files

Does the DB require Extra Files?(fill in below for each file)

 

Logic Name of file

 

Group

 

Initial Size (MB)

 

Auto Growth

 

Path

 

In the cloud – there is increasing demand for immediate stand up of databases – that developers can set up with little or no lead time. That’s ok for a development area , but in a Production environment with high scale, mission critical databases, some due diligence is required.

 

Read More on database provisioning

SQL Server Install Checklist

Storage Checklist FAQ - SQL Server DBA

SQL Server database files configuration checklist - SQL Server

 

 

 


Author: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on New Database request checklist


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer