I have two issues:
I have a new server for the Navision Database. It will have Sql 2005 x64, Windows 2003 Server 64.
I have 3 RAID 10 systems for the database. I intend to use one for transaction log and I am wandering what to do with the two left:
- split the database in 2 (using the same filegroup by creating 2 data files within navision) OR
- put the tabledata on the first array and move the indexes/sifts on the second one. Has anybody used a script for doing that for all tables in database?
2) As I read on the Internet it is best to use FAT32 for the database systems, especialy for the transaction log (true?). Another thing related to this is the allocation unit size on the disks. One Extent has 8 pages, one page has 8k. As far as I know SQl reads optimum 1 extent at a time...so alocation unit size should be 64 k for maximum perfomance? Am I right?
Any opinion is very apreciated
ps: some interesting mibuso topics relatedhttp://www.mibuso.com/forum/viewtopic.php?t=12469http://www.mibuso.com/forum/viewtopic.php?t=11468http://www.mibuso.com/forum/viewtopic.php?t=10335http://www.mibuso.com/forum/viewtopic.php?t=16342