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 sec

--创建分区文件组
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:\DataDB\seclab_sgk_db\seclab_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:\DataDB\seclab_sgk_db\seclab_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:\DataDB\seclab_sgk_db\seclab_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:\DataDB\seclab_sgk_db\seclab_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:\DataDB\seclab_sgk_db\seclab_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:\DataDB\seclab_sgk_db\seclab_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:\DataDB\seclab_sgk_db\seclab_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:\DataDB\seclab_sgk_db\seclab_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:\DataDB\seclab_sgk_db\seclab_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:\DataDB\seclab_sgk_db\seclab_sgk_db_10.mdf‘,filegrowth=10mb) to filegroup seclab_sgk_db_10;

总结

以上是内存溢出为你收集整理的SQLServer亿万级数据优化全部内容，希望文章能够帮你解决SQLServer亿万级数据优化所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。