November 5, 2003 at 7:39 am
Hi!
As far as I know MS SQL 2000 uses extends of 64KB to read from or write to hard disk.
Is this true about MS SQL 6.5? Or does it use pages of 8KB instead?
Thanks.
November 5, 2003 at 9:18 am
You'd have to dig through BOL, but I think 8kb sounds right. I thought it was substantially enhanced in SQL 7.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 6, 2003 at 6:50 am
6.5 used page of 2K. And I think the extent was 8K. 6.5 and earlier used the old Sybase data structures. (Disk Device, etc) With v7, the entire data engine was completely rewritten, and operates differently.
They are completely different.
What's the business problem you're trying to solve?
What's the business problem you're trying to solve?
November 6, 2003 at 7:02 am
One of my collegs found disk performance statistics, that showed that 32KB sripe size is the best for MS SQL 6.5, so, as he said, the same should be for MS SQL 2000. I argued that MS SQL 2000 uses extends of 64KB to read/write data and MS SQL 6.5 should had used smaller portions of data, so for MS SQL 2000 the best is 64KB. Thats all. 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply