--_f90cfac7-4951-4dc7-9bf4-1d351c96c9d6_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Ok, so I have this client who has a need.=20
High speed access for OLTP and data retrieval and a slower access for
docu=
ment retrieval. (.pdfs).
Looking at the new(er) generation of SAS Raid controllers, I can mix and
ma=
tch SAS and SATA within the same backplane.
So does it make sense to split the database spaces against the two types
of=
disks? RootDB, TempDB, some appDBs on SAS, then some appDBs that contain
t=
he tables for the blobs on the SATA?=20
Then use RAID 10 on SAS and maybe raid 60 on SATA? (Art will probably kill
=
me for mentioning anything but raid 10... ;-)
Does anyone see any performance tuning issues?
I can see doing this set up for a medical office in a box system.
(Not that this is the application for the client. For some reason they are
=
extremely "hush hush")
TIA!
-G
_________________________________________________________________
Make i'm yours.=A0 Create a custom banner to support your cause.
http://im.live.com/Messenger/IM/Contribute/Default.aspx?source=3DTXT_TAGHM_=
MSN_Make_IM_Yours=
--_f90cfac7-4951-4dc7-9bf4-1d351c96c9d6_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<html>
<head>
<style>
..hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class=3D'hmmessage'>
Ok, so I have this client who has a need. <br><br>High speed access for
OLT=
P and data retrieval and a slower access for document retrieval.
(.pd=
fs).<br>Looking at the new(er) generation of SAS Raid controllers, I can
mi=
x and match SAS and SATA within the same backplane.<br><br>So
d=
oes it make sense to split the database spaces against the two types of
dis=
ks? RootDB, TempDB, some appDBs on SAS, then some appDBs that contain the
t=
ables for the blobs on the SATA? <br><br>Then use RAID 10 on SAS and maybe
=
raid 60 on SATA? (Art will probably kill me for mentioning anything but
rai=
d 10... ;-)<br><br>Does anyone see any performance tuning issues?<br><br>I
=
can see doing this set up for a medical office in a box system.<br>(Not
tha=
t this is the application for the client. For some reason they are
extremel=
y "hush hush")<br><br>TIA!<br><br>-G<br><br><br /><hr />Make i'm yours. <a
=
href=3D'http://im.live.com/Messenger/IM/Contribute/Default.aspx?source=3DTX=
T_TAGHM_MSN_Make_IM_Yours' target=3D'_new'>Create a custom banner to
suppor=
t your cause.</a></body>
</html>=
--_f90cfac7-4951-4dc7-9bf4-1d351c96c9d6_--
|
