Cari Blog Ini

22 Maret 2012

Feature Performance and Maintenance Database

Maintenance Plan Tasks
* Back Up Database Task
* Check Database Integrity Task
* Execute SQL Server Agent Job Task
* Execute T-SQL Statement Task
* History Cleanup Task
* Maintenance Cleanup Task
* Notify Operator Task
* Rebuild Index Task
* Reorganize Index Task
* Shrink Database Task
* Update Statistics Task


Feature
* SQL Server Profiler
* SQL Mail
* Database Tuning
* Execution Plan
* Defragmantation
* Replication
* Mirroring Database
Maintenance Database;
* Pembuatan Cadangan Database (Backup Database)
* Pemindahan dan Penghapusan Data-Data yang Tidak Diperlukan
* Melakukan Indexing, Defragmentasi, dan Shrinking Database
* Melakukan Performance Tuning Database