jnelson993
Posts: 910
Score: 145 Joined: 2/18/2005 From: Minneapolis, MN Status: offline
|
Yeah, I know I'm coming to this late, but if they want an easy speed up, kill the RAID 5 b.s. and go with RAID 10. Like Sherry said, SAN won't fix squat, especially since you'll likely be lumped in with everyone else's SAN traffic and won't have any control over limiting the use of those spindles. And if the read/write heads are moving while your transaction log is trying to write, it can't do it's big sequential writes as fast and inserts/updates/deletes are slowed. RAID 10 is really a giant leap in helping you out here. Aside from providing better redundancy, it provides much better performance. Trust me, I've spend months and months on RAID and spindles and logical disks and partition offsets and allocation unit sizes, etc. And I also agree with Sherry, 8 hours seems very quick. I suppose you've done it so many times, you've got the process down . You could speed that up by having an unattended build of the server, including SQL and all the configuration stuff, then you won't spend so long clicking NEXT->NEXT->NEXT
_____________________________
Number2 (John Nelson) MyITForum - Blog MyITForum - Forum Posts
|