Re: Oracle on NT with raw devices

From: Thomas Cox <thomasbcox_at_nospam.home.com>
Date: Mon, 05 Apr 1999 23:47:15 GMT
Message-ID: <37094B2A.C6F93A3E@nospam.home.com>

"Christopher M. Day" wrote:

> If you have performance figures for the gain in using RAW over NTFS then
> please make them known to the rest of the group. I'm sure lots of people
> are interested.

> Chris.

> > Using Raw FS increases performance by 10 - 15% for NT, but decreases
> > manageability by 50%.

> > Stilian

According to folks who do TPC-C and -D benchmarks for a living, they find Raw gives about 2% better performance for them than NTFS. Since TPC benchmarks completely ignore manageability, they use Raw to get that 2% gain, and damn the torpedoes.

For me, I would never use Raw unless I had to (i.e. Oracle Parallel Server). I really do care about manageability.

Cheers.
-Tom
--
See also my DBA white papers at <http://home.att.net/~tbcox>

Received on Mon Apr 05 1999 - 18:47:15 CDT