What are the basic uses for master Msdb model tempdb and resource databases?

Question

The msdb database stores information regarding database backups, SQL Agent information, DTS packages, SQL Server jobs, and some replication information such as for log shipping. The tempdb is used to store temporary objects such as global and local temporary tables and stored procedures.

What is the MSDB database used for?

The msdb database is used by SQL Server Agent for scheduling alerts and jobs and by other features such as SQL Server Management Studio, Service Broker and Database Mail. For example, SQL Server automatically maintains a complete online backup-and-restore history within tables in msdb.

What is the use of TempDB?

The tempdb system database is a global resource that holds: Temporary user objects that are explicitly created. They include global or local temporary tables and indexes, temporary stored procedures, table variables, tables returned in table-valued functions, and cursors.

What is TempDB MDF used for?

TempDB is used by the server for operations such as storing temporary and work tables, ordering records, storing records' versions, etc'. If the TempDB is growing, then the server needs more space in it.

Expert · Answer