Few questions about setting shared storage for SQL cluster

Hello,
I have 2 questions about setting HW for SQL cluster :
1. What is best practice to set up quorum and MSDTC disk resources? I'm
interested what group of disks they should use : one dedicated to SQL logs
or one dedicated to SQL data? How one or another design can affect
performance?
2. This question I think applies and to standalone SQL servers. It is stated
in some documents that stripe size in storage can affect performance of the
system. Is there any recomendations for this when using MS SQL?
I've been browsing through MS and HP (HP hardware is used)
supports/knowledge bases and found no precise answer to my questions so
maybe here someone can point me to some resources.
Br,
Darius K.
Quorum and MSDTC should reside on their own disks. No sharing with SQL Data
or Logs. MS states to separate Quorum and MSDTC, but that really only
applies if you are running a lot of distributed transactions.
Stripe size and stripe alignment should be covered by your hardware vendor.
If the 'expert' they provide does not understand SQL server's unique
requirements, make them send you an new one. A good hint is if he wants to
make everything a large RAID5 container and slice LUNS off of it as you need
them. That works OK for a file share, it stinks for SQL.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Dakl" <dakl@.one.lt> wrote in message
news:%23DRA7GR2EHA.3092@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I have 2 questions about setting HW for SQL cluster :
> 1. What is best practice to set up quorum and MSDTC disk resources? I'm
> interested what group of disks they should use : one dedicated to SQL logs
> or one dedicated to SQL data? How one or another design can affect
> performance?
> 2. This question I think applies and to standalone SQL servers. It is
stated
> in some documents that stripe size in storage can affect performance of
the
> system. Is there any recomendations for this when using MS SQL?
> I've been browsing through MS and HP (HP hardware is used)
> supports/knowledge bases and found no precise answer to my questions so
> maybe here someone can point me to some resources.
> Br,
> Darius K.
>
|||Hi
SQL Server does I/O in the database file in 8 extents of 8kb (=64kb). All
our volumes holding databases are formatted at 64kb at OS level. The EMC
hardware striping is out of our control. When I can control it, and we are
using RAID-5, I configure it to be 64kb blocks too.
Some I/O systems perform better at 32Kb blocks, others at 64kb. You need to
test to see what is best.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:#4NigkU2EHA.3708@.TK2MSFTNGP14.phx.gbl...
> Quorum and MSDTC should reside on their own disks. No sharing with SQL
Data
> or Logs. MS states to separate Quorum and MSDTC, but that really only
> applies if you are running a lot of distributed transactions.
> Stripe size and stripe alignment should be covered by your hardware
vendor.
> If the 'expert' they provide does not understand SQL server's unique
> requirements, make them send you an new one. A good hint is if he wants
to
> make everything a large RAID5 container and slice LUNS off of it as you
need[vbcol=seagreen]
> them. That works OK for a file share, it stinks for SQL.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Dakl" <dakl@.one.lt> wrote in message
> news:%23DRA7GR2EHA.3092@.TK2MSFTNGP10.phx.gbl...
logs
> stated
> the
>
|||Hi,
I know that Quorum and MSDTC should reside on their own disks. But it is not
affordable to use separate disks. So scenario is this : there are 2 disk
groups (arrays) - one with RAID1 for Logs and second one with RAID10 for
data. To what group is better to add LUNs for Quorum and MSDTC? Or maybe
there is no difference in fact?
Br,
Dakl
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:%234NigkU2EHA.3708@.TK2MSFTNGP14.phx.gbl...
> Quorum and MSDTC should reside on their own disks. No sharing with SQL
Data
> or Logs. MS states to separate Quorum and MSDTC, but that really only
> applies if you are running a lot of distributed transactions.
> Stripe size and stripe alignment should be covered by your hardware
vendor.
> If the 'expert' they provide does not understand SQL server's unique
> requirements, make them send you an new one. A good hint is if he wants
to
> make everything a large RAID5 container and slice LUNS off of it as you
need[vbcol=seagreen]
> them. That works OK for a file share, it stinks for SQL.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Dakl" <dakl@.one.lt> wrote in message
> news:%23DRA7GR2EHA.3092@.TK2MSFTNGP10.phx.gbl...
logs
> stated
> the
>
|||If you can't do RAID 10 for everything, then I would put them on the RAID 1.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"Dakl" <dakl@.one.lt> wrote in message
news:Ou3VNL52EHA.2192@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I know that Quorum and MSDTC should reside on their own disks. But it is
> not
> affordable to use separate disks. So scenario is this : there are 2 disk
> groups (arrays) - one with RAID1 for Logs and second one with RAID10 for
> data. To what group is better to add LUNs for Quorum and MSDTC? Or maybe
> there is no difference in fact?
> Br,
> Dakl
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:%234NigkU2EHA.3708@.TK2MSFTNGP14.phx.gbl...
> Data
> vendor.
> to
> need
> logs
>
|||I have a EMC CX500 with 1T striped Raid 10 for Data and separate 100G Raid 5
Luns for Logs, Qorum and MSDTC. This may be a little overkill but seems to
work fine under the load we put it. In testing changes to block size really
didn't appear to affect performance greatly, in production we went with 64K.
Sir Limey
"Rodney R. Fournier [MVP]" wrote:

> If you can't do RAID 10 for everything, then I would put them on the RAID 1.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://www.msmvps.com/clustering - Blog
> "Dakl" <dakl@.one.lt> wrote in message
> news:Ou3VNL52EHA.2192@.TK2MSFTNGP14.phx.gbl...
>
>
sql

FC or ATA for LOG FILES?

I'm setting up a new DB and separating the log files to storage separate
from the data. The data will be on FC storage. Will the log files perform
optimally on FC or ATA?
Thanks in advance.
SBGFC as in FC-ATA where you're basically using cheap hardware?
I question your decision to put data and log files on such equipment in the
first place. However, as to the log files themselves, I suspect you could
put log files on an MFM drive, or an old 20MB removable platter and be fine
99.99% of the time. There just isn't that much I/O to the logs.
"SBG" <sbg@.thomasville.org> wrote in message
news:O1j$TY%23HIHA.4196@.TK2MSFTNGP04.phx.gbl...
> I'm setting up a new DB and separating the log files to storage separate
> from the data. The data will be on FC storage. Will the log files
> perform
> optimally on FC or ATA?
> Thanks in advance.
> SBG
>|||Oh, and .01% of the time is about 1 hour a year.
"Jay" <nospan@.nospam.org> wrote in message
news:eA$a3i%23HIHA.5544@.TK2MSFTNGP02.phx.gbl...
> FC as in FC-ATA where you're basically using cheap hardware?
> I question your decision to put data and log files on such equipment in
> the first place. However, as to the log files themselves, I suspect you
> could put log files on an MFM drive, or an old 20MB removable platter and
> be fine 99.99% of the time. There just isn't that much I/O to the logs.
> "SBG" <sbg@.thomasville.org> wrote in message
> news:O1j$TY%23HIHA.4196@.TK2MSFTNGP04.phx.gbl...
>> I'm setting up a new DB and separating the log files to storage separate
>> from the data. The data will be on FC storage. Will the log files
>> perform
>> optimally on FC or ATA?
>> Thanks in advance.
>> SBG
>>
>

Favorites Storage in SQL Server Books-on-line

Where are the topics (links) saved to the favorites tab of the books-on-line
stored. I want to tranfer my topics to a new machine. Thank you for your
assistance.
Bob
In the hh.dat file. The location of this file depends on the
OS but you would want to look for the path to
Application Data\Microsoft\HTML Help\hh.dat
You can rename the existing one on the new machine and then
copy the hh.dat from your current machine.
I've never had problems doing it but if you have problems,
you can delete the hh.dat that you copied and then rename
the original back to hh.dat
-Sue
On Wed, 17 Nov 2004 11:30:17 -0500, "Robert A. Farrenkopf"
<Bob.Farrenkopf@.BestSoftware.com> wrote:

>Where are the topics (links) saved to the favorites tab of the books-on-line
>stored. I want to tranfer my topics to a new machine. Thank you for your
>assistance.
>Bob
>

Favorites Storage in SQL Server Books-on-line

Where are the topics (links) saved to the favorites tab of the books-on-line
stored. I want to tranfer my topics to a new machine. Thank you for your
assistance.
BobIn the hh.dat file. The location of this file depends on the
OS but you would want to look for the path to
Application Data\Microsoft\HTML Help\hh.dat
You can rename the existing one on the new machine and then
copy the hh.dat from your current machine.
I've never had problems doing it but if you have problems,
you can delete the hh.dat that you copied and then rename
the original back to hh.dat
-Sue
On Wed, 17 Nov 2004 11:30:17 -0500, "Robert A. Farrenkopf"
<Bob.Farrenkopf@.BestSoftware.com> wrote:
>Where are the topics (links) saved to the favorites tab of the books-on-line
>stored. I want to tranfer my topics to a new machine. Thank you for your
>assistance.
>Bob
>

Favorites Storage in SQL Server Books-on-line

Where are the topics (links) saved to the favorites tab of the books-on-line
stored. I want to tranfer my topics to a new machine. Thank you for your
assistance.
BobIn the hh.dat file. The location of this file depends on the
OS but you would want to look for the path to
Application Data\Microsoft\HTML Help\hh.dat
You can rename the existing one on the new machine and then
copy the hh.dat from your current machine.
I've never had problems doing it but if you have problems,
you can delete the hh.dat that you copied and then rename
the original back to hh.dat
-Sue
On Wed, 17 Nov 2004 11:30:17 -0500, "Robert A. Farrenkopf"
<Bob.Farrenkopf@.BestSoftware.com> wrote:

>Where are the topics (links) saved to the favorites tab of the books-on-lin
e
>stored. I want to tranfer my topics to a new machine. Thank you for your
>assistance.
>Bob
>