Deployment Guide: SQL Server 2005 x64 on Windows Server 2008 Enterprise x64

Virtualization Windows Server 2008 Enterprise x64 and SQL Server 2005 offers many powerful features and improvements. Since this guide, the process of introducing the system ….

More PDF Content

Deployment Guide: SQL Server 2005 x64 on Windows Server 2008 Enterprise x64
Introduction … 3
New features of Windows Server 2008 Enterprise … 3
Installing and setting up Windows Server 2008 Enterprise x64 and SQL Server 2005 x64 in this environment … 4
Defining our environment … 4
Configuring the RAID disk groups… 5
Installing Windows Server 2008 Enterprise x64… 8
Configuring the operating system drives … 10
Installing SQL Server 2005 … 11
SQL Server 2005 post-installation tasks … 15
Next steps: Best practices for administering and monitoring SQL Server 2005 … 20
Administering SQL Server 2005 in this environment … 20
Monitoring SQL Server 2005 in this environment … 23
AUTOGROWTH … 21
AUTO CLOSE … 21
One tempdb data file per core … 22
Processor and memory parameters … 22
Counters available from the Reliability and Performance Monitor … 23
Dynamic management views and functions… 24
Summing up … 26
Appendix A. Methodology: Creating the RAID disk groups. 28
Appendix B. Methodology: Installing Windows Server 2008
Enterprise… 31
Appendix C. Methodology: Installing SQL Server 2005 … 34
Setting IP address, subnet mask, and domain information 32
Configuring data drives… 33
Using the ALTER DATABASE command to modify the location of user database or tempdb files and logs after an installation… 37
About Principled Technologies… 40

Download Deployment Guide: SQL Server 2005 x64 on Windows Server 2008 Enterprise x64 pdf from www.dell.com, 40 pages, 1009.68KB.
Related Books

Leave a Reply