SQL Processes to read / write data pages from / to memory and disk?

• HookSQLDBA7

  SSChampion

  Points: 10709

  More actions

  January 22, 2008 at 3:17 pm

  #123396

  Does SQL Server (2000) have background processes (like Oracle) which reads data from disk into memory and writes data from memory to disk? If so, what are they called? Or are these processes performed by the Database Engine?

  Thanks, Kevin

• Minaz Amin

  SSChampion

  Points: 11052

  More actions

  January 22, 2008 at 11:55 pm

  #770757

  SQL Server 2000 I/O Basics by Bob Dorr.

  http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx

  "More Green More Oxygen !! Plant a tree today"