Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kappa02
Yak Posting Veteran
65 Posts |
 Posted - 2009-08-07 : 15:36:31
|
We have just install SharePoint 2007 but I believe the person who install it could have done a better job. The database server is a standalone box (that has 8 CPUs) with three drives. Drive “C” 35000MB (Total), 27512MB (Free); Drive “D” 104971MB (Total) 104146MB (Free),Drive “E”409598MB (Total) 409517MB (Free). All of the databases are on drive “D” including the system databases; I would have preferred master, model & msdb on the “C” drive and tempdb on several equal disks. Would it be in our best interest to reconfigure the database files and have one tempdb database file per physical core (using the Alter database command)? Any suggest would be appreciated.  |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-08-07 : 22:37:01
|
| Answer depends on What RAID Level your disks have? We have RAID 10 for Log files and TempDB and RAID 5 for Data Files. Yes, you can spread TempDB Data files as number of processors to acheive parallelism. |
 |
|
|
kappa02
Yak Posting Veteran
65 Posts |
Posted - 2009-08-11 : 08:43:35
|
| We are using RAID 5. |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-08-11 : 14:39:09
|
| Are all of the volumes on the same raid array? Or do you have 3 separate raid arrays?If they are just separate partitions on a single raid 5 array, there will not be significant performance improvements. (excluding very high-end raid cards and SAN's) |
|
|
|
kappa02
Yak Posting Veteran
65 Posts |
Posted - 2009-08-11 : 15:54:28
|
| thanks, you just answer my question, since they separate partitions on a single raid array we won't see that much on a improvement. |
|
|
|
|
|
|
SQL & SharePoint files