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

As with SQL Server 2008 x64, are too many to include in this guide. The following list shows some of the most ….

More PDF Content

Deployment Guide: SQL Server 2008 x64 on Windows Server 2008 Enterprise x64
Introduction … 3
New features of SQL Server 2008 x64 … 3
New features of Windows Server 2008 Enterprise… 4
Installing and setting up Windows Server 2008 Enterprise x64 and SQL Server 2008 x64 in this environment … 5
Defining our environment … 5
Installing Windows Server 2008 Enterprise x64… 6
Configuring the drives … 8
Installing SQL Server 2008 x64 … 11
Next steps: Best practices for administering and monitoring SQL Server 2008 x64 … 16
Administering SQL Server 2008 x64 in this environment … 16
AUTOGROWTH … 16
AUTO CLOSE… 17
One tempdb data file per core … 17
Processor and memory parameters … 18
Notes on the new SQL Server 2008 x64 compression capabilities … 19
Monitoring SQL Server 2008 x64 in this environment… 20
Counters available from the Reliability and Performance Monitor … 20
Dynamic management views and functions… 20
Performance Data Collector and Management Data Warehouse … 22
Summing up … 28
Appendix A. Methodology: Installing Windows Server 2008
Enterprise… 29
Set IP address, subnet mask, and domain information … 30
Configuring data drives… 31
Appendix B. Methodology: Installing SQL Server 2008 x64 32
Using the ALTER DATABASE command to modify the
location of user database or tempdb files and logs after an installation… 34
About Principled Technologies… 36

Download Deployment Guide: SQL Server 2008 x64 on Windows Server 2008 Enterprise x64 pdf from www.principledtechnologies.com, 36 pages, 893.08KB.