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 |
|
dursaliye
Starting Member
22 Posts |
 Posted - 2005-04-28 : 13:55:44
|
| Hello,I thought that the physical allocation of"header+pointer+trace infromation+ data = 8 KB pages" and "8 page= 1 extend = 64 KB" and "16 extend = 1 block = 1024 KB" is build in the memory by reading data from data files during starting of SQL Server 2000. I know SQL Server caches them during starting but I'm uncertaing about whether pages are stored in memory or disk as with pointers,headers and other? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-04-28 : 18:55:55
|
| Pages (data, index, text, IAM, etc.) are stored on disk. The buffer manager determines when they need to be read from/written to disk, accessed from RAM, or flushed from RAM to make room for new pages to be read. Pages are only cached in RAM if they are read from disk; merely starting SQL Server will not cache anything, unless you have some kind of startup process or job that retrieves data. (some system tables will have their data cached on startup)I don't know what you mean by "trace information", but if you want to learn the details look up "pages" in Books Online and read all of the subtopics. |
 |
|
|
dursaliye
Starting Member
22 Posts |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-04-29 : 07:24:56
|
| The term "tracking info" is unusual, what it means is that the tail end of the data page stores the row offset table. These are pointers to where each row is stored on the page. There is a diagram in Books Online that illustrates this clearly. |
|
|
|
dursaliye
Starting Member
22 Posts |
Posted - 2005-04-29 : 08:10:49
|
| I read Books Online but I was confused. I figured out physical allocation of SQL Server data pages by your help.Thanks again. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-04-29 : 08:16:32
|
| Read Books Online again, until you are NOT confused. It is the best source of information on SQL Server, and the more familiar and comfortable you are with it, the more successful you will be with SQL Server. |
|
|
|
dursaliye
Starting Member
22 Posts |
Posted - 2005-04-29 : 08:41:42
|
| Books Online is my favorite. I always read it but not interested in physical structure till now because I'm starting to prepare a Turkish site so that there is not much Turkish web site on SQL Server 2000. |
|
|
|
|
|
|
|
|
where are pages stored?