electric4us
asked on
SQL Server 2008 installation
Installing MS Sql server 2008. Need advice on the disk partition and how to split up the tempdb, userdb and log files.
I currently have 4 partitions on the server. the C:\ drive has the OS and I don't plan to store anything else there. the D:\ drive would have the SQL server application installed. I would like the optimal performance and would like tempdb and log files separated if that's necessary.
Please advise.
Thanks.
I currently have 4 partitions on the server. the C:\ drive has the OS and I don't plan to store anything else there. the D:\ drive would have the SQL server application installed. I would like the optimal performance and would like tempdb and log files separated if that's necessary.
Please advise.
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
the server has 8 sas drives that is configured with raid 10. the partitions are located there. so are you suggesting I have 2 different configurations with that disk set? raid 10 and 1?