| Author |
BTS 2004 - SQL Server Analysis Services
|
|
| Harrison Davis 2004-06-10, 5:30 pm |
| I was told that SQL Server Analysis Services which HAT uses was very CPU
intensive and should not reside on the BizTalk Data base box. Can it reside
on a different server and how would you set it up to work correctly with BTS
2004.
| |
| Michael Roze [MSFTF] 2004-06-11, 5:43 pm |
| At runtime It is the DTADb that is can be resource intensive.
Under high stress situations large volumes of data need to be moved from
the MsgBox databases to the DTADb database.
This can cause extensive DISK IO [INSERTS] usage and a fair amount of CPU
usage.
Thus it is recommended to use fast disks [e.g. RAID arrays] or if possible
a SAN.
If the machine on which the Message Box and DTADb resides becomes a point
of contention, it is recommended to upgrade the disks
If that is not possible it is recommended to move the DTADb to a dedicated
machine which has fast disks.
HAT use this database to query data. This can cause additional contention
on the DTADb if the system in under high stress.
This behavior is unavoidable due to the persistent nature of the BizTalk
system design.
Hope this helps.
Thanks,
MRoze
This posting is provided "AS IS" with no warranties, and confers no rights.
EBusiness Server Team
I was told that SQL Server Analysis Services which HAT uses was very CPU
intensive and should not reside on the BizTalk Data base box. Can it reside
on a different server and how would you set it up to work correctly with BTS
2004.
| |
| Tanglesoft 2004-06-20, 11:08 pm |
| I agree with what is said below, however HAT does not
require SQL Analysis services to be present in order to
function. It is only used if you wish the install a BAM
aggreation database.
>-----Original Message-----
>At runtime It is the DTADb that is can be resource
intensive.
>Under high stress situations large volumes of data need
to be moved from
>the MsgBox databases to the DTADb database.
>This can cause extensive DISK IO [INSERTS] usage and a
fair amount of CPU
>usage.
>Thus it is recommended to use fast disks [e.g. RAID
arrays] or if possible
>a SAN.
>If the machine on which the Message Box and DTADb
resides becomes a point
>of contention, it is recommended to upgrade the disks
>If that is not possible it is recommended to move the
DTADb to a dedicated
>machine which has fast disks.
>
>HAT use this database to query data. This can cause
additional contention
>on the DTADb if the system in under high stress.
>
>This behavior is unavoidable due to the persistent
nature of the BizTalk
>system design.
>
>Hope this helps.
>
>Thanks,
>MRoze
>
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>EBusiness Server Team
>
>I was told that SQL Server Analysis Services which HAT
uses was very CPU
>intensive and should not reside on the BizTalk Data base
box. Can it reside
>on a different server and how would you set it up to
work correctly with BTS
>2004.
| |
| Harrison Davis 2004-06-20, 11:08 pm |
| Thanks for clarifying why the SQL Analysis Service usage - The install says
it is needed for HAT or BAM(under the Installing SQL Server 2000 heading),
if it is really for BAM then I don't think I need it - although my original
question I don't belive was answered.
| |
| Paul Davidson 2004-06-28, 7:28 pm |
| Yes, Analysis(plus SP3a) can be installed on a seperate machine, however
you must give certain permissions to the identity of the SQL account that
runs the job that archives the data(wherever the primary import db is). It
should be called out in the product docs but I don't have the link handy.
Let me know if you can't find it.
--------------------
From: "Harrison Davis" <hdavis@somewhere.com>
References: <#vWbB0vTEHA.2908@TK2MSFTNGP10.phx.gbl>
<2tAh1j#TEHA.308@cpmsftngxa10.phx.gbl>
<1d7d301c45474$b7555960$a601280a@phx.gbl>
Subject: Re: BTS 2004 - SQL Server Analysis Services
Date: Thu, 17 Jun 2004 10:39:39 -0400
Lines: 6
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
Message-ID: <uXBizjHVEHA.3420@TK2MSFTNGP12.phx.gbl>
Newsgroups: microsoft.public.biztalk.setup
NNTP-Posting-Host: gatekeeper.travelers.com 204.89.226.65
Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12
.phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.setup:3797
X-Tomcat-NG: microsoft.public.biztalk.setup
Thanks for clarifying why the SQL Analysis Service usage - The install says
it is needed for HAT or BAM(under the Installing SQL Server 2000 heading),
if it is really for BAM then I don't think I need it - although my original
question I don't belive was answered.
|
|
|
|