SQLServer亿万级数据优化

--创建分区文件组
alter database test add filegroup seclab_sgk_db_01
alter database test add filegroup seclab_sgk_db_02
alter database test add filegroup seclab_sgk_db_03
alter database test add filegroup seclab_sgk_db_04
alter database test add filegroup seclab_sgk_db_05
alter database test add filegroup seclab_sgk_db_06
alter database test add filegroup seclab_sgk_db_07
alter database test add filegroup seclab_sgk_db_08
alter database test add filegroup seclab_sgk_db_09
alter database test add filegroup seclab_sgk_db_10

?

alter database seclab_sgk_db add file(name=‘seclab_sgk_db_01‘,filename=‘E:DataDBseclab_sgk_dbseclab_sgk_db_01.mdf‘,size=3mb,filegrowth=10mb) to filegroup seclab_sgk_db_01;alter database seclab_sgk_db add file(name=‘seclab_sgk_db_02‘,filename=‘E:DataDBseclab_sgk_dbseclab_sgk_db_02.mdf‘,filegrowth=10mb) to filegroup seclab_sgk_db_02;alter database seclab_sgk_db add file(name=‘seclab_sgk_db_03‘,filename=‘E:DataDBseclab_sgk_dbseclab_sgk_db_03.mdf‘,filegrowth=10mb) to filegroup seclab_sgk_db_03;alter database seclab_sgk_db add file(name=‘seclab_sgk_db_04‘,filename=‘E:DataDBseclab_sgk_dbseclab_sgk_db_04.mdf‘,filegrowth=10mb) to filegroup seclab_sgk_db_04;alter database seclab_sgk_db add file(name=‘seclab_sgk_db_05‘,filename=‘E:DataDBseclab_sgk_dbseclab_sgk_db_05.mdf‘,filegrowth=10mb) to filegroup seclab_sgk_db_05;alter database seclab_sgk_db add file(name=‘seclab_sgk_db_06‘,filename=‘E:DataDBseclab_sgk_dbseclab_sgk_db_06.mdf‘,filegrowth=10mb) to filegroup seclab_sgk_db_06;alter database seclab_sgk_db add file(name=‘seclab_sgk_db_07‘,filename=‘E:DataDBseclab_sgk_dbseclab_sgk_db_07.mdf‘,filegrowth=10mb) to filegroup seclab_sgk_db_07;alter database seclab_sgk_db add file(name=‘seclab_sgk_db_08‘,filename=‘E:DataDBseclab_sgk_dbseclab_sgk_db_08.mdf‘,filegrowth=10mb) to filegroup seclab_sgk_db_08;alter database seclab_sgk_db add file(name=‘seclab_sgk_db_09‘,filename=‘E:DataDBseclab_sgk_dbseclab_sgk_db_09.mdf‘,filegrowth=10mb) to filegroup seclab_sgk_db_09;alter database seclab_sgk_db add file(name=‘seclab_sgk_db_10‘,filename=‘E:DataDBseclab_sgk_dbseclab_sgk_db_10.mdf‘,filegrowth=10mb) to filegroup seclab_sgk_db_10;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!