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 |
|
itsonlyme4
Posting Yak Master
109 Posts |
 Posted - 2008-02-12 : 16:07:24
|
| I will be installing SQL Server 2005 enterprise edition for the first time and was looking for some hints...unfortuntely, I don't know alot about what kind of applications they will be using the databases for.. but I do know that I have 400GB to allocate. My manager suggested a seperate volume for the SQL Server Binaries.. not sure why... ANY OPINIONS ON THAT???This is what he suggested C:\ OSD:\SQL Server application installE:\datafilesF:\Logfilee:tempdbany hints, suggestions, opinions, things to watch out for... ???????I was thinking more along the lines ofc:\OS and application installs (sql server etc..)E:\datafiles and TempDB F:\Logsfiles |
|
|
dewacorp.alliances
452 Posts |
Posted - 2008-02-12 : 16:16:06
|
| At our environment, we generally split between single box and cluster farm. If the cluster farm, we tend to use:C:\Local System (OS and apps)D:\Local Data (mainly for temporarily backups or others utilities files, SQL installation file etc etc)F:\SAN dataG:\SAN transaction logsT:\SAN Tranfer (file from backup disk is transfered to here before gets restored)For single box:C:\Local System (OS and apps)D:\Local SQL Data and Transfer (as well as utility files)E:\Local SQL Transaction Log Generally, rack mount server has maximum of 3 slots so we have RAID 1 for each logical drive. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-12 : 22:59:59
|
| Better to put tempdb on its own disk. |
|
|
|
dewacorp.alliances
452 Posts |
Posted - 2008-02-13 : 00:10:36
|
quote:
Better to put tempdb on its own disk.
How much do you put this one generally (% of the data disk for instance)? Do you put both tempdb.mdf and tempdb.ldf on the same disk? In term of SAN, can this disk be a SATA (slow disk) instead of FIBRE (fast disk)? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-16 : 00:21:19
|
| It depends, I usually give it 200gb. Should separate data from log, and we always use fiber. |
|
|
|
dewacorp.alliances
452 Posts |
Posted - 2008-02-16 : 15:22:08
|
quote:
Originally posted by rmiao
It depends, I usually give it 200gb. Should separate data from log, and we always use fiber.
Hi rmiaoIf you are using 200gb, how much is your user databases in total? I assume this will be close 1TB?Thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-16 : 15:44:18
|
| No. Sql2k5 needs big tempdb than sql2k, especially when you enable row versioning features. |
|
|
|
|
|
|
|
|
installing sql server 2005 for the first time