Hi,
The following post had also been posted on the SQL Server Administration forum, but I'm also posting it here, since this is about SharePoint, so I hope I could get some advice from some of you "SharePoint guys"...
==============================
I'm trying to determine what kind of hardware I should use for a SharePoint Portal Server (single server). The server should get about 10 RPS (Requests per second), this is why the single server setup will be used. The SQL database (because of the document management) should grow to about 600 GB.
I wonder what hardware I should use to get some good performance from the SQL Database. What kind of difference in performance would the following setups give me?
1 - Would "Setup # 2" be about 10% faster than "Setup # 1"? Or more like 20% Or something else?
2 - What about "Setup # 3"?
3 - Also, how much RAM would that kind of setup need? 2 GB? 4 GB? 8 GB? more?
4 - And then, what about the processor? Single processor? Dual processor ? Quad processor?
5 - Should 36 GB disks be enough for the Transaction log and the TempDB?
I don't think that the IIS part of the setup will use much CPU and RAM (since it shouldn't get more that 10 RPS during peeks), so I focus more on what the SQL Server part needs than on the IIS part.
Setup # 1
=========
OS : 2 X 73 GB @ 15K RPM (RAID 1)
SQL Database + transaction log : 4 X 300 GB @ 10K RPM (RAID 10)
Setup # 2
=========
OS : 2 x 73 GB
SQL Database : 4 X 300 GB @ 10K RPM (RAID 10)
Transaction Log : 2 X 36 GB @ 15K RPM
TempDB : 2 X 36 GB @ 15 K RPM
Setup # 3
=========
OS : 2 x 73 GB
SQL Database : 8 X 146 GB @ 15K RPM (RAID 10)
Transaction Log : 2 X 36 GB @ 15K RPM
TempDB : 2 X 36 GB @ 15 K RPM
The following post had also been posted on the SQL Server Administration forum, but I'm also posting it here, since this is about SharePoint, so I hope I could get some advice from some of you "SharePoint guys"...
==============================
I'm trying to determine what kind of hardware I should use for a SharePoint Portal Server (single server). The server should get about 10 RPS (Requests per second), this is why the single server setup will be used. The SQL database (because of the document management) should grow to about 600 GB.
I wonder what hardware I should use to get some good performance from the SQL Database. What kind of difference in performance would the following setups give me?
1 - Would "Setup # 2" be about 10% faster than "Setup # 1"? Or more like 20% Or something else?
2 - What about "Setup # 3"?
3 - Also, how much RAM would that kind of setup need? 2 GB? 4 GB? 8 GB? more?
4 - And then, what about the processor? Single processor? Dual processor ? Quad processor?
5 - Should 36 GB disks be enough for the Transaction log and the TempDB?
I don't think that the IIS part of the setup will use much CPU and RAM (since it shouldn't get more that 10 RPS during peeks), so I focus more on what the SQL Server part needs than on the IIS part.
Setup # 1
=========
OS : 2 X 73 GB @ 15K RPM (RAID 1)
SQL Database + transaction log : 4 X 300 GB @ 10K RPM (RAID 10)
Setup # 2
=========
OS : 2 x 73 GB
SQL Database : 4 X 300 GB @ 10K RPM (RAID 10)
Transaction Log : 2 X 36 GB @ 15K RPM
TempDB : 2 X 36 GB @ 15 K RPM
Setup # 3
=========
OS : 2 x 73 GB
SQL Database : 8 X 146 GB @ 15K RPM (RAID 10)
Transaction Log : 2 X 36 GB @ 15K RPM
TempDB : 2 X 36 GB @ 15 K RPM