Basic Documentation for the sql server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Basic Documentation for the sql server

Author

Topic

srikanth12
Starting Member

22 Posts

Posted - 2010-03-18 : 23:36:17

Hi All,

We have a database of 1TB and my manager asked me to document it and its server properties. So could any one from here please suggest me what steps i need to follow( or the major things which i need to consider for the documentation). Please no short answers. I need specific points so that i can make sure i documented all the points.

Thanks in Advance

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2010-03-19 : 01:09:00

General DB Document Structure!

1.General Information
1.1Purpose of this document
1.2Scope
1.3Acronyms and Abbreviations

2.Database Overview

3.Data Models

3.1
3.2
3.3

4.Data Flow Diagram

4.1
4.2
4.3

5.Issues and Limitations

Senthil.C
------------------------------------------------------
[Microsoft][ODBC SQL Server Driver]Operation canceled

http://senthilnagore.blogspot.com/

srikanth12
Starting Member

22 Posts

Posted - 2010-03-20 : 14:52:02

Could you let me know what server properties i need to consider in the documentation?

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-03-20 : 17:47:10

- OS Version and SP level
- SQL Version and SP level
- # SQL instances
- Physical RAM
- #, type and speed of CPUs
- Physical disk configuration and capacity. RPM and seek time if you can too.
- Configured SQL Server Max memory
- Any non-standard configurations
- # and size of data files
- Perfmon counts for CPU, I/O

That's a decent start

ahmad.osama
Posting Yak Master

183 Posts

Posted - 2010-03-23 : 06:43:00

In addition to russell's list

- logins
- Jobs and Maintenance plans, if any
- Backup policy for the database
- Database Purpose and Usage.
- Database Design/Diagram.

srikanth12
Starting Member

22 Posts

Posted - 2010-03-24 : 11:21:06

Thanks for all of you. I will make sure i have all of these documented.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources