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 |
|
bhushan_juare
Starting Member
45 Posts |
 Posted - 2011-10-14 : 06:11:10
|
| Hi Guys,I am working on Sql Server 2005. I want to know System Scripts (Sql) for below task.1)Data Monitoring – Data Buffering Quality, DD cache Quality, SQL Pin ratio, Alloc fault rate 2)Check System logs for errors or warning 3)Check failed update requests 4)Check for old pending locks or failed locks 5)Check Database Growth 6)Check Missing Indexes 7)Check table space used 8)Database growth and storage plan 9)Data Archival 10)Check DMS Status and connectivity 11)Applications Monitoring and Management 12)Application Alerts for Work Process Monitoring 13)Daily Monitoring checklist for DBBuffer ,Cache Hits ,Clearing of Caches 14)SQL Hardening If anyone know plz let me know.Thanks... |
|
|
Cindyaz
Yak Posting Veteran
73 Posts |
Posted - 2011-10-20 : 08:58:01
|
| you will need to clarify each of your request in detail. eg. I dont understand what do you mean by "Check DMS Status and connectivity". How are you going to monitor your application using SQL script ("Applications Monitoring and Management").I'm not sure if checklist too need to be filled by SQL Script? (Daily Monitoring checklist for DB)? |
 |
|
|
|
|
|
System Script For Database Management in Sql 2005