Re: SQL Server for Data Warehouse

From: Barbara Kennedy <barbken_at_teleport.com>
Date: Wed, 15 Nov 2000 18:28:37 -0800
Message-ID: <bDHQ5.3161$3d4.84479@nntp2.onemain.com>

It is a Microsoft product... :-)

One thing you might look at is how much IO capability it has. If you have just one disk it won't matter what RDBMS you use you would be limited to the total IO that that disk could handle. I would go looking at root causes first. (Disk IO capacity, what is the execution plan?) Etc.

"David Ng" <david.ng_at_interhealthtechnology.com> wrote in message news:8utlj9$m0g$1_at_news.hk.linkage.net...
> Hi,
>
> I am an Oracle DBA and take up a data warehousing project lately. The
> current project using SQL server 7 as the back end database and have a lot
> of
> performance problems.
>
> Can anyone tell me why SQL server 7 is so bad as data warehouse database ?
I
> need facts and examples in technical terms to convince my boss.
>
> Thanks in advances
>
> David
>
>
Received on Wed Nov 15 2000 - 20:28:37 CST