Where to read about ms sql server architecture?

Question

Software design

Tell me where you can find a normal description of the architecture of ms sql server
As well as a description of the standard duties of a database administrator.
Thanks in advance.

Answer 1

If there are no GOSTs, then let's create them here. Type memo dba ..
Here is an example:
1. Check logs ( set email notification if error)
2. Check jobs .. ( set email notification if error)
3. Check indexes .. ( run script and rebuild indexes if defragmentation is more than 20 for example %) .. It is better to run in the evening
(and the statistics on the tables will be recalculated by itself? When indexes are rebuilt?)
4. Analyze the statistics of accessing tables .. See if the indexes correspond to the type of data usage)
5. Check current connections .. an hour about the number of connections and add it to your table
6 ... Those who are interested, join memo two (dba)