超大数据库(XLDB)环境下的管理员程序员生存指南视频课程

1

Introduction

2

Free Tips for SSMSFree tips

3

Tuning--Tracing/Profiling

「仅限付费用户」点击下载“XLDB_suvival_guide_4_senior_dbas.pdf”

4

Tuning--Indexing,common issue

「仅限付费用户」点击下载“XLDB_suvival_guide_4_senior_dbas.pdf”

5

Tuning--check io, time, planset statistics io,time,profile on

「仅限付费用户」点击下载“XLDB_suvival_guide_4_senior_dbas.pdf”

6

Tuning--HintOptimize the Optimizer

「仅限付费用户」点击下载“XLDB_suvival_guide_4_senior_dbas.pdf”

7

Tuning--cte,tbl variable, snapCTETable variablesnapshot (reader won't block writer, writer won't block reader)

8

Tuning--traceflagsswitches, so certain things will hapeen

9

Clustering/HA/DRClusteringHA High availabilityDR Disaster Recovery

10

Upgrade/MigrationIn a small time of window:UpgradeMigration

11

Back upHow to speed up your XLDB backupHow to plan your backupBack up at different levels

12

Restore/T-log, VLFRestoret-log managementVLF -- impact your start up time

13

dbcc checkdbHow to checkdb faster in small time of window

14

Update statisticsTo get better performance, you need Update statistics regularlyHow to update statics?When to update statistics?Do it faster?

15

De-fragmentationDe-fragmentationRebuild index/Reindex/reorgFrequent DML happens to your table, let's defragment.

16

Data archivalMake XLDB -> VLDB -> Small DB, so easy to manage

17

Control your resourceThere are bad guys,let's face it.How to make sure they won't abuse your system with 2 hours report and run away? Resource Governor is the solution.

18

MonitoringYou want to be alerted when something goes horribly wrong? won't you?You want data to be collected for OS, RAM, DISK,network so you can compare later on, right?

19

Appendix 1/Demo Covering index

「仅限付费用户」点击下载“demo5_coverindex.txt”

20

Appendix 2/Demo table variable

「仅限付费用户」点击下载“demo6_table_variable_issue.txt”