This Book is Provided by Principledtechnologies :
They provide industry-leading technology assessment and fact-based marketing services. They bring to every assignment extensive experience with and expertise in all aspects of technology testingand analysis, from research into new technologies, to the development of new methodologies, to testing with existing and
new tools.
Topic Covered in this Book:
- New features of SQL Server 2008 x64
- New features of Windows Server 2008 Enterprise
- Installing and setting up Windows Server 2008 Enterprise
- x64 and SQL Server 2008 x64 in this environment
- Defining our environment
- Installing Windows Server 2008 Enterprise x64
- Configuring the drives
- Installing SQL Server 2008 x64
- Next steps: Best practices for administering and monitoring SQL Server 2008 x64
- Administering SQL Server 2008 x64 in this environment
- AUTOGROWTH
- AUTO CLOSE
- One tempdb data file per core
- Processor and memory parameters
- Notes on the new SQL Server 2008 x64 compression capabilities
- Monitoring SQL Server 2008 x64 in this environment
- Counters available from the Reliability and Performance Monitor
- Dynamic management views and functions
- Performance Data Collector and Management Data Warehouse
- Summing up
- Appendix A. Methodology: Installing Windows Server 2008 Enterprise
- Set IP address, subnet mask, and domain information
- Configuring data drives
- 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
DOWNLOAD : Guide to SQL Server 2008
Bookmarks