February 12, 2010 at 9:10 am
We are getting ready to migrate from SQL Server 2005 Enterprise Edition to SQL Server 2008 Enterprise Edition. To keep life simple, we plan to build a new Development/Test cluster and a new Production cluster, using Microsoft Clustering and SAN disk space.
Can anyone point me to a SQL Server 2008 Installation/Upgrade Best Practices document or FAQ? I am looking for recommendations for the following:
- Is there anything in particular that we should plan for in our SAN configuration? (i.e., block sizes, the number of drive letters, the number of mount points, etc.)
- Our old SQL 2005 configuration puts *.MDF and *.NDF on E: with *.LDF, *.BAK, and *.TRN on F:, meaning that we lose everything if F: has issues. (Whoever came up with that design left the organization a while back. Hmmmm.... Maybe the *.LDF files could be recreated, but that would be a hassle for a server hosting 80 databases.) For SQL 2008, we are thinking about using E: for *.MDF, *.NDF, and *.LDF with *.BAK and *.TRN on F:. This is not optimal either (because of potential performance problems), but at least the backups survive if the database fails and the database survives if the backup drive fails. I worked a shop a while back that used this E: configuration, and the SAN disk space performed well. Purests will likely recommend putting *.LDF on a separate drive letter, but since it is all SAN space (and I have no control of how it is configured underneath the operating system), I don't know if this is worth the trouble. Any thoughts?
- Are there any best practices for which features to install or not install?
- What else should we look for?
February 14, 2010 at 9:49 am
Here 2 of the 5 articles by Ross, perhaps if you Google you can find the rest or some additional articles:
http://www.networkworld.com/community/node/30052
http://www.networkworld.com/community/node/30275
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply