09-28-2009 07:41 AM
Solved! Go to Solution.
09-28-2009 11:58 AM
Thank You! I really appreciate the feedback.
If we do a single RAID 10 container on the 6 drives for the SQL server rather than three RAID 1s, should we still do separate partitions for the various functions? (i.e. OS, TranLogs, Databases). It seems that we would not see the benefit of separate partitions since we would be writing to the same disks/container. Or would we still see benefit since it might simplify maintenance (i.e. defragmenting, back-ups)
Received response from Symantec rep:
Thanks! You’re pretty much right on the money regarding the separate partitions. Here’s a scenario where separate partitions might help. If later on you decided to move the indexes or logs to a new location the process would involve stopping all the services, moving the data and then doing a find and replace in SQL. If they’re all on the same partition doing that find and replace is more complex.
09-28-2009 07:56 AM
09-28-2009 08:13 AM
09-28-2009 09:18 AM
09-28-2009 10:03 AM
09-28-2009 10:54 AM
09-28-2009 11:58 AM
Thank You! I really appreciate the feedback.
If we do a single RAID 10 container on the 6 drives for the SQL server rather than three RAID 1s, should we still do separate partitions for the various functions? (i.e. OS, TranLogs, Databases). It seems that we would not see the benefit of separate partitions since we would be writing to the same disks/container. Or would we still see benefit since it might simplify maintenance (i.e. defragmenting, back-ups)
Received response from Symantec rep:
Thanks! You’re pretty much right on the money regarding the separate partitions. Here’s a scenario where separate partitions might help. If later on you decided to move the indexes or logs to a new location the process would involve stopping all the services, moving the data and then doing a find and replace in SQL. If they’re all on the same partition doing that find and replace is more complex.
09-29-2009 09:13 AM