Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
heze
Posting Yak Master
192 Posts |
 Posted - 2007-03-01 : 23:25:48
|
| Hi,According to the literature, in SQL Server2000 one extent is made up of 8 contigous pages.Question:When we are talking about SQL Server pages, are we refering to the pages in which the physical memory is divided?For example, if the op sys uses pages of size 64Ks, are these the same pages the SQL Server literature groups in the extent?Thank you |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-03-02 : 00:06:24
|
no, they are not the same.page size in sql server is ~8k.
www.elsasoft.org |
 |
|
|
heze
Posting Yak Master
192 Posts |
Posted - 2007-03-02 : 00:18:12
|
| Thanks jezemine, then, what is the relation of the SQL Server pages with the op sys memory organization? Does SQL SRVR bypasses the virtual memory mechanisms and interacts directly with the disk and memory? Is the extent-page organization some kind of virtual memory mechanism?Thank you |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
|
|
rlaubert
Yak Posting Veteran
96 Posts |
Posted - 2007-03-02 : 07:52:24
|
| SQL Server uses Extents when allocating disk space with the operating system. An Extent is 8 pages (8*8k=64K) which is what Windows uses when accessing the disk drive.Raymond LaubertMCDBA, MCITP:Administration, MCT |
|
|
|
|
|
|
SQL Server Pages vs Operating syst Pages