官术网_书友最值得收藏!

  • SQL Server on Linux
  • Jasmin Azemovi?
  • 187字
  • 2021-07-02 20:24:19

System databases

SQL server has a concept of system and user databases. User databases are created for specific types of business process: HR, online shop, eHealth, and so on. It's up to the user (developers and DBAs) to define all the parameters. Here, you are in charge (more about it Chapter 4, Database in the Sandbox).

On the other hand, system databases are created during the installation procedure without almost any user influence. It is a repository of all SQL Server internals and it continues its process of updating its content, such as:

  • Configuration data
  • Users information
  • Database objects
  • Query execution statistics
  • Troubleshooting
  • Data statistics
  • And many more

SQL Server simply can't work without it. All this important information is stored in the following system databases:

  • master (system-wide settings and information about user databases)
  • tempdb (a place for any temporal database tasks)
  • model (the template for new user databases)
  • msdb (used by SQL Server Agent Service for tasks scheduling )

Those four databases are default and the user can't directly access their content. To do that we need to use system catalog and dynamic management views objects.

主站蜘蛛池模板: 德令哈市| 清苑县| 花莲市| 华池县| 驻马店市| 天气| 都昌县| 澄城县| 曲麻莱县| 交城县| 布拖县| 界首市| 衡南县| 安宁市| 辽阳县| 开封市| 双峰县| 海南省| 独山县| 东乡族自治县| 保靖县| 濮阳市| 临清市| 大石桥市| 广丰县| 祁阳县| 确山县| 岳池县| 汝南县| 宁城县| 铜川市| 浦县| 梧州市| 隆化县| 昭苏县| 谷城县| 双鸭山市| 磴口县| 肇州县| 西和县| 霞浦县|