Search sqlserver-dba.com
Follow sqlserver-dba.com
*Use the Comments section for questions
SQLServer-DBA.com Links
Recent Posts
- The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
- How to find privilege changes with SQL Server Default Trace
- sys.dm_server_services - How to check if SQL Server service is running or not?
- Msg 3023, Level 16, State 2 Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed.
- Can we restore a database to an older version in SQL Server?
- How do I save all SQL Agent Jobs
- How to view SQL Server mount point space without access to server
- DBCC SHRINKFILE: page could not be moved because it is a work table page.
- SQL Agent Last Modified explanation
- Sql certificate chain was issued by an authority that is not trusted
New Database request checklist
08 March,2016 by Tom Collins
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
Storage Checklist FAQ - SQL Server DBA
SQL Server database files configuration checklist - SQL Server
Author: Tom Collins (http://www.sqlserver-dba.com)
Share:
Verify your Comment
Previewing your Comment
This is only a preview. Your comment has not yet been posted.
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.
Posted by: |