Re: NT File System

So, your conclusion is raw devices are better in both many read and write operations espcially the throughput rather than the response time?

Steven Cruz (stevenc_at_istar.ca) wrote:
: Hello;
:
: Actually the master device is the busiest device there is. The master
: database keeps track of data pages and such. Also, Sybase will not guarantee a good
: restore from file system, since it can not guarantee a write to disk. Another thing
: to remember is that if your query requires more disk reads than your OS has
: cached, the dataserver process will be put to sleep until your IO is complete. This
: may not only hurt your query, but hurt all the other queries run at that time.
:
: Ng K C Paul wrote:
:
: > I am a developer. Actually, I don't like raw devices from the
: > administration and performance point of view. But in the production
: > environment, we need raw device for master database since it is really
: > important and seldom changed. Also, we cannot restore it from backup.
: >
: > How can I configure raw devices in NT?
: >
: > nasof_at_hotmail.com wrote:
: > : Why are you not considering RAW devices for NT? You seemed to like it on
: > : UNIX.
: > :
: > : -Frank
: > :
: > : In article <6s3he6$3aj$1_at_imsp009a.netvigator.com>,
: > : paulkcng_at_news.netvigator.com (Ng K C Paul) wrote:
: > : > What kind of File System should I install the database software and
: > : > data and log to? FAT or NTFS? I know that the security is better in NTFS.
: > : > Also, there is a compress option in NTFS. In unix, raw device is more
: > : > reliable than unix file system which has disk cache that can speed up
: > : > certain I/O operations. What about performance on NT?
: > : >
: > : > In WIN97/98, there is also FAT32. Should I use it to install
: > : > MS-SQLServer 7.0, Personal Oracle8 or Adaptive SQLServer Anywhere Studio?
: > : > It seems that FAT32 can save more space than FAT but NT4.0 cannot read
: > : > files on FAT32, am I right? Also, is there any difference on backup and
: > : > recovery time on different file system?
: > : >
: > :
: > : -----== Posted via Deja News, The Leader in Internet Discussion ==-----
: > : http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
:
:
:
  Received on Sat Aug 29 1998 - 00:00:00 CDT