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 |
|
joshp
Starting Member
8 Posts |
 Posted - 2004-07-11 : 22:22:42
|
| Does anyone know of any documentation that describes the SQL 2000 best practices when it comes to partitioning. I have heard that Transaction Logs, TEMPDB, and SQL Data should all be on seperate LUN's? Is this true? If so, is there any other performance tricks you could recommend?Thanks. |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-11 : 23:31:35
|
| RAID 1 or 10 for the Transaction LogsRAID 1 or 10 for the tempdb.RAID 5 or RAID 10 for the data (if you can afford RAID 10. Otherwise, spend the money getting logs and tempdb on it.)Try to place the IO on as many channels as you can on the servers. For example if you have four channels, 2 network cards, and 2 HBA cards put one on each channel so you don't saturate the bus. If you have a SAN, try to spread the data out as evenly as you can on the SAN. Some SANs have channels that only reach halfway across an enclosure so it's better to divide your arrays across those channels. There are all kinds of hints and "tricks". The biggest thing is to know your hardware, know the benefits of distributed IO, and know RAID.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
SQL Cluster LUN's