any dba checklist  
Author Message
malev_nospam





PostPosted: Fri Dec 17 05:26:31 CST 2004 Top

SQL Server >> any dba checklist

hi,

1. any dba checklist information available on the net, e.g. daily operation,
weekly or monthly
2. will the dba switch on the server-side trace during product to monitor
any abnormal behaviour? if yes, any examples?

thanks a lot!

SQL Server94  
 
 
John





PostPosted: Fri Dec 17 05:26:31 CST 2004 Top

SQL Server >> any dba checklist Hi

To some extent your check list will be determined by the system you are
running and how it is configured.
This site is a good resource of information
http://www.sql-server-performance.com/articles_all_by_date.asp, You may also
want to look at the operations guide at
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops0.mspx

A list of useful resources can be found at
http://www.aspfaq.com/show.asp?id=2423

Books online is also a valuable resource and if you look up sqldiag and
blackbox you may find the answer to your second question.

John



> hi,
>
> 1. any dba checklist information available on the net, e.g. daily
> operation,
> weekly or monthly
> 2. will the dba switch on the server-side trace during product to monitor
> any abnormal behaviour? if yes, any examples?
>
> thanks a lot!
>
>
>
>
>