March 9, 2008 at 2:30 pm
Hi,
I am writing to have some support.
Sorry if my questions are basic for some of you.
We are currently running an SQL 2000 on a single server
We're planning to migrate to SQL2005 plus 2 new servers in cluster with a SAN
First we'll just migrate the database in the current hardware environment by backup/restore method.
During surfing on the forum, I found that I'll have to check for the incompatibility of SQL2005 and set to 90.
What should be the exact reason for this?
Regarding the hardware migration (the SAN will have 9 disk. Six of them for data will be Raid 10
configured and two will be in Raid 1 configured (for logs).
I read also that I'll need to run a SQLIO.exe
What's I/O?
why should I run it?
Is there any other point that I should care about??
Thanks for your supports and help
March 9, 2008 at 11:11 pm
Sql Server 2005 has a compatability of 90 whereas Sql Server 2000 has 80. In order to utilize the features available in Sql 2005 you need to have it as 90. Certain features like Performance dashboard etc.
Refer this link for more info about compatability differences and the new features available using compatability of 90.
http://msdn2.microsoft.com/en-us/library/ms178653.aspx
[font="Verdana"]- Deepak[/font]
March 10, 2008 at 8:44 pm
Your specs state your RAID setting for data is going to be 10. I recommend that you go with RAID 5 if performance is going to be a factor. RAID 5 is preferred for read operations over 10. You want fast write performance for your log files, but will want to optimize the data RAID for reads.
- Tim Ford, SQL Server MVPhttp://www.sqlcruise.comhttp://www.thesqlagentman.com http://www.linkedin.com/in/timothyford
March 11, 2008 at 6:17 am
SQLIO.exe:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx
http://www.microsoft.com/technet/prodtechnol/sql/2005/iobasics.mspx
"Got no time for the jibba jabba!"
-B.A. Baracus
March 11, 2008 at 6:25 am
SQLIO allows you to stress test your storage. It would be a good idea to try this before migration so you can iron out any issues with the hardware setup.
Gethyn Elliswww.gethynellis.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply