What exactly does DBA work for one of the SQL Server 2000 management expert series courses? ) [SQL Server]

What are the responsibilities of DBAs?

L Security

L availability functional and performance

L Reliability

L scalability

Design and Implementation

L database server environment

L database storage Architecture

L logical object structure of the database

L database object permission Configuration

L database backup and recovery policies

L database performance optimization policies

L heterogeneous collaboration structure of databases

DBA Working Method

Analysis> Design> Implementation> test> Optimization

SQL Server in a large server environment

L SMP multi-CPU support and large-capacity memory support

L awe multi-CPU support and large-capacity memory support

L distributed partition View

L index View

Database Storage Architecture

L analyze users' data storage needs

L suitable storage device structure

-SCSI is better than ide

-Raid is better than single disk

L database data files and log files

-Raw partition (unformatted partition)

-Multiple data files and file groups (data files, log files, and index files are stored on different hard disks, which helps increase the file read/write throughput)

L Data Distribution Model

-Data Partition

Design and implement the Database Data Structure

L analyze user application requirements

L design a data-off system model

L implement data tables

L access support caused by Data Structures

L create an index

L index implementation

Database Object permission Configuration

L plan the user logon method (SQL Server/Windows Authentication)

L assign server role permissions (cannot be customized)

L assign database role Permissions

L create a custom database role

Database backup and recovery policies

L assess data protection requirements (data protection scope and recovery time restrictions, for example, data can be lost one week before restoration)

L plan backup policies

-Completeness, difference, and log

-Backup Device and Its replacement policy

-Especially pay attention to testing backup policies to simulate data disasters.

L set the database recovery model

L implement backup policy

Database performance optimization policies

L develop database performance requirements (response time and throughput)

L set database performance baseline

L plan the performance monitoring Solution

L performance monitoring Solution

L audit performance monitoring logs

L solve performance problems

Design and implement a collaborative working environment for database servers

L data transmission between SQL Server servers

L data transmission between SQL Server and other database server products

L use remote server data