Advertisement

Data Storage Internals

  • Dmitri Korotkevitch
Chapter

Abstract

A SQL Server database is a collection of objects that allow you to store and manipulate data. In theory, SQL Server supports 32,767 databases per instance, although the typical installation usually has only several databases. Obviously, the number of databases SQL Server can handle depends on the load and hardware. It is not unusual to see servers hosting dozens or even hundreds of small databases.

Keywords

Database File Space Allocation Data Page Buffer Pool Object Page 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Supplementary material

313962_2_En_1_MOESM1_ESM.zip (1.4 mb)
SQL Server Internals 2nd Edition (zip 1,434 kb)

Copyright information

© Dmitri Korotkevitch 2016

Authors and Affiliations

  • Dmitri Korotkevitch
    • 1
  1. 1.TampaUSA

Personalised recommendations