Re: OLAP and OLTP on sae server?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 08/15/04 

Date: Sun, 15 Aug 2004 20:52:59 +0200

Ben,

This is basically not recommended. But it really depends on the concrete
workload - how many users you have, how much work will SQL Server and
Analysis Services have to handle together, what is your HW configuration... 

-- 
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Ben" <anonymous@discussions.microsoft.com> wrote in message
news:5f5001c48171$5b4f2ea0$a601280a@phx.gbl...
> Hi,
>
> I have one SQL 2000 Ent Server that is installed with
> OLTP.  I have a business application that needs its db to
> be OLAP.  Is it OK to have some DBs operate in OLTP and
> OLA{ mode at the same time on the same server?

Relevant Pages