MS-SQL Server - MBC Of Database Architecture, Schedule Jobs & Tools

MBC Of Database Architecture, Schedule Jobs & Tools

- Memory Architecture https://learn.microsoft.com/en-us/sql/relational-databases/memory-management-architecture-guide?view=sql-server-ver16

- Backup Architecture
https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/quickstart-backup-restore-database?view=sql-server-ver16

- Configuration Architecture

There are five types of configurations.

a. Going to the Service properties from object explorer and configure accordingly.

b. By going to the properties on database level and change as per requirement.

c. sys.configurations or sp_configure

d. Configuration Manager

e. Control Panel for Virtual Memory or Paging & Lock Pages in Memory.

Related links..

https://learn.microsoft.com/en-us/sql/relational-databases/sql-server-configuration-manager?view=sql-server-ver16

https://learn.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-configurations-transact-sql

https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-configure-transact-sql

Schedule Jobs
https://learn.microsoft.com/en-us/sql/ssms/agent/schedule-a-job?view=sql-server-ver16

Tools
https://learn.microsoft.com/en-us/sql/tools/overview-sql-tools?view=sql-server-ver16

Any query will be considered.

T. Amit Vaid S.