SQL Server 2005 database DBA Checklist for database administrator

This article provides SQL Server 2005 database DBA Checklist for database administrator. The objective is to provide Check list for database administratorOvercome existing database server issues like CPU Utilization more (95%), growth in transaction log Database Performance (CUP Utilization) SQL Server 2005 database is 64 bit, its basic feature is it tries to use all the available physical memory that is supported by operating system. Set maximum server memory for SQL Server 2005 and leave rest for th...