Re: SQL Server for Data Warehouse

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Thu, 16 Nov 2000 09:19:50 GMT
Message-ID: <3a13a4f7.874127@news-server>

On Wed, 15 Nov 2000 17:40:46 +0800, "David Ng" <david.ng_at_interhealthtechnology.com> wrote:

>
>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.
>

You need to crack up the NT monitor and investigate where the bottlenecks are. Once you have a solution for these (most likely I/O bandwidth or memory) and the performance doesn't pick up, then you may have grounds for complaining to the boss and asking for a change.

Basically, get the facts to substantiate your claim. In NT, the monitor will give you plenty.

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Thu Nov 16 2000 - 03:19:50 CST