SQL Server 2008 Guide on Windows Server 2008

SQL Server 2008 Guide on Windows Server 2008

SQL Server 2008 x64 introduces a wide variety of new features. While there are far too many to discuss in this Guide, the following list mentions some of the more significant ones. Backup compression. SQL Server 2008 x64 can automatically compress database backups, a feature previously only available via the purchase of third-party software products. “Hot add” CPUs. On supported hardware platforms you can now add one or more CPUs while SQL Server 2008 x64 is running. As with SQL Server 2005, you can also hot add memory. Installing and setting up Windows Server 2008 Enterprise x64 and SQL Server 2008 x64 in this environment. Plan on at least 60 minutes for installing Windows Server 2008 Enterprise x64 on the Dell PowerEdge 2950 server. Each step below takes at least a minute. We put the approximate amount of time each step takes in parentheses at the end of the description of that step. Those times below exclude data entry time. The time to install updates, which was ten minutes in our setup, will increase over time as Microsoft releases additional OS updates. 1. Boot the server using the Windows Server 2008 Enterprise x64 DVD. (2 minutes) 2. A screen appears prompting you to press any key to boot from DVD. Do so. In Windows Boot Manager, select Windows Setup, and press Enter. The installation software will begin to load files. (2 minutes). Configure all database servers with static IP addresses. This practice assures that SQL Server 2008 x64 resources will remain available even in the event of a DHCP server failure. It also increases the stability of your networking and DNS environments. To achieve optimal performance that scales with heavy workloads, Microsoft recommends that the number of data files for a SQL Server 2008 x64 database range from 0.5 to 1 for each CPU core on the server.


DOWNLOAD LINK: SQL Server 2008 Guide on Windows Server 2008

Share and Enjoy...