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.
| Author |
Topic |
|
Jheds
Starting Member
17 Posts |
 Posted - 2007-01-07 : 06:01:28
|
| We are supposed to prepare a report on an SQL SERVER 2000 DATABASE HEALTH CHECK.This has to be done immediately.I am doing this for the first time.Im sure that there has to be an existing template or must do list/checklist to check the most important things in the SERVER.We have to emphasize on setup and configuration related information.If anybody has done this kindly provide with all your approches.Thanking In Anticipation,Regards,Jheds |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-01-07 : 11:03:12
|
| I reckon there are 3 areas:1) How shoddy are the naming conventions and general way in which the database is built2) How shoddy are the housekeeping routinesand 3) (given you said "setup and configuration") How good is the DBA documentation for the tasks they need to do periodically, and documentation sufficient for a new walk-in DBA to pick up the baton.1) MS have a "Best Practices" tool which will investigate a database and make suggestions based on what it finds. That might be a good place to start.2) Other than that, in a physical sense, have a look at DBCC in BoL. That has commands to PROVE that the database is not corrupted; report on the level of fragmentation; perform optimisations and so on.There is stuff which might help at: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Houskeeping3) Can't help you much with that, as its mostly related to YOUR particular application, except perhaps for database structure documentation. There have been a number of threads about that on SQL Team, but there is nothing in my FAQ - bu a search should bring up the relevant threads.Kristen |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
|
|
|
|
|
URGENT ! PL HELP ...