RAID devices vs size of database file 
Author Message
 RAID devices vs size of database file

I have a question that perhaps someone can answer.

When creating a database, you can put the data onto one big data device,
lets say 10 GB.  Now as the database is operating and a checkpoint occurs,
the committed trans are flushed to the disk.  Will the RAID device attempt
to rewrite the 10 GB file?  Would I be better off using 5 - 2GB files in
lieu of the one big file (lets say they are on one RAID array as would be
the 10 Gb file)?

Where can I find information about how the data is managed within the data
device (how are pages manipulated within the database file) or how SQL
Server and the HAL in NT manages the physical data files?

Thanks - Jay



Sat, 04 Jan 2003 03:00:00 GMT
 RAID devices vs size of database file

Jay,

It is my understanding the SQL was built with the win32 libraries.
I don't know if its "pure" win32, whatever that means.

kenny thomason


Quote:
> I have a question that perhaps someone can answer.

> When creating a database, you can put the data onto one big data device,
> lets say 10 GB.  Now as the database is operating and a checkpoint occurs,
> the committed trans are flushed to the disk.  Will the RAID device attempt
> to rewrite the 10 GB file?  Would I be better off using 5 - 2GB files in
> lieu of the one big file (lets say they are on one RAID array as would be
> the 10 Gb file)?

> Where can I find information about how the data is managed within the data
> device (how are pages manipulated within the database file) or how SQL
> Server and the HAL in NT manages the physical data files?

> Thanks - Jay



Sat, 04 Jan 2003 03:00:00 GMT
 RAID devices vs size of database file
 Jay - SQL manages data in 8K pages (in SQL 7).  In NT terms it does 64K i/o's.
 Therefore the sizing/splitting of your files is irrelevant.

 > I have a question that perhaps someone can answer.

Quote:

> When creating a database, you can put the data onto one big data device,
> lets say 10 GB.  Now as the database is operating and a checkpoint occurs,
> the committed trans are flushed to the disk.  Will the RAID device attempt
> to rewrite the 10 GB file?  Would I be better off using 5 - 2GB files in
> lieu of the one big file (lets say they are on one RAID array as would be
> the 10 Gb file)?

> Where can I find information about how the data is managed within the data
> device (how are pages manipulated within the database file) or how SQL
> Server and the HAL in NT manages the physical data files?

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 Reply here - no email
 SQL FAQ (484 entries) see
 forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps (faqrtf.zip - L7
- SQL Public)
 or    http://www.ntfaq.com/Section.cfm?sectionID=34
 or www.sqlserverfaq.com
 or www.mssqlserver.com/faq


Sun, 05 Jan 2003 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Max database size vs max data file size

2. How to shrink the Database size and Database Device size

3. Raw devices Vs. File system devices

4. Device size and database size

5. Device size and database size

6. Database size bigger than device size???

7. Optimum Configuration for Page Size, NTFS Allocation Unit size and RAID Stripe size

8. SQL Server database file size versus Oracle File size

9. blocks size/and RAID 1+0 versus RAID 5 NT4 SS7

10. Raid performace issues (Raid 5 vs. Raid 0+1) with database files

11. Impact of partitoning Sybase 11 databases on RAID ( 5 ) devices

12. Raid 5 vs Raid 1+0


 
Powered by phpBB® Forum Software