|
Home > Archive > MS SQL Server > March 2006 > Disk Layout from h/w perspective
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Disk Layout from h/w perspective
|
|
| Hassan 2006-03-05, 8:23 pm |
| We usually have our databases comprise of 2 data files and one log file
Is it best to have these files on their own array controller or even on
different channels on the same array controller ?
Whats ideal ?
How do organizations lay out there databases i.e. data and log files along
with the tempdb and backup files,etc.
Would love to hear in terms of array controllers,etc..
You could tell me in terms of an HP or a Dell server..Doesnt matter.. Just
seeking for advices.
| |
| Hilary Cotter 2006-03-05, 8:24 pm |
| Ideally you would have your own controller for each with different raid
arrays -raid 10 for the logs and raid 5 for the data. If your work load is
write intensive (over 20% writes) I would make both arrays raid 10.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Hassan" <Hassan@hotmail.com> wrote in message
news:Odg69QpPGHA.3984@TK2MSFTNGP14.phx.gbl...
> We usually have our databases comprise of 2 data files and one log file
>
> Is it best to have these files on their own array controller or even on
> different channels on the same array controller ?
>
> Whats ideal ?
>
> How do organizations lay out there databases i.e. data and log files along
> with the tempdb and backup files,etc.
>
> Would love to hear in terms of array controllers,etc..
>
> You could tell me in terms of an HP or a Dell server..Doesnt matter.. Just
> seeking for advices.
>
| |
| Hassan 2006-03-05, 8:24 pm |
| So even if a controller has 2-4 channels, you would not prefer to have
arrays hooked to different channels on the same array controller ?
"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:O8TYu0qPGHA.3728@tk2msftngp13.phx.gbl...
> Ideally you would have your own controller for each with different raid
> arrays -raid 10 for the logs and raid 5 for the data. If your work load is
> write intensive (over 20% writes) I would make both arrays raid 10.
>
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
>
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
>
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
>
>
> "Hassan" <Hassan@hotmail.com> wrote in message
> news:Odg69QpPGHA.3984@TK2MSFTNGP14.phx.gbl...
>
>
|
|
|
|
|