Newby, need monitoring type scripts

[rbringas]

Does anyone have any scripts that does monitoring that I can run to give me database stats of all databases in a SQL server. I am new at the RDBMS field but been on a proprietary database runs on mainframe since 1992.

Can someone also tell me pointers on monitoring and daily tasks as SQL DBAs. I was entrusted since March of this year 2 applications on SQL Server 7.0 that has both test servers and replicated on one via SURVIVE IT. Any help would do. Thanks to all you tecchies, newbies like me will not survive if not for you all.

 

[tlbroadbent]

Here are some helpful links that discuss various aspects of SQL Admninistration.

Link to SQL Server 2000 Operations Guide:
faq183-1062

Administration Best Practices:

http://vyaskn.tripod.com/sql_server_administration_best_practices.htm

Administering SQL Server:

http://msdn.microsoft.com/library/en-us/adminsql/ad_perfmon_6ofn.asp

Monitoring SQL Server:

http://msdn.microsoft.com/library/en-us/adminsql/ad_mon_perf_76cm.asp

http://msdn.microsoft.com/library/en-us/adminsql/ad_mon_perf_00mr.asp

http://msdn.microsoft.com/library/en-us/adminsql/ad_mon_perf_86ib.asp

http://msdn.microsoft.com/library/en-us/adminsql/ad_perfmon_1qgj.asp

Backup strategy:

http://msdn.microsoft.com/library/en-us/adminsql/ad_bkprst_63eh.asp

Using DBCC for database maintenance:

http://support.microsoft.com/support/kb/articles/Q134/6/56.asp

Introduction to SQL Performance Monitor:

http://www.swynk.com/friends/goldman/PerfMonTips.asp

SQL Performance Tuning and Optimization Intro:

http://www.swynk.com/friends/goldman/Optimization1.asp

http://www.swynk.com/friends/goldman/Optimization2_1.asp

Links to more SQL articles on a variety of topics.

http://tlbroadbent.home.attbi.com/sqlarticles.htm

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[rbringas]

Thank you very much, really appreciate it. I will be very busy for a while...