07 2022 档案
摘要:reference https://docs.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes?view=sql-server-ver15 查询数据库索引碎片超过30%的表,然后重建
阅读全文
摘要:[root@azk8s-oc sqlmi]# head sql1-linux.yaml apiVersion: v1 data: username: c3FsYWRtaW4K password: SHVhd2VpMTIjMjMK kind: Secret metadata: name: sql1-l
阅读全文
摘要:CPU最佳实践。 根据CPU架构和核数配置MaxDop. https://learn.microsoft.com/zh-CN/sql/database-engine/configure-windows/configure-the-max-degree-of-parallelism-server-co
阅读全文
