파일그룹내 파일 사용율

 

인옥이형이 낚였다고 머라했음....-_-+

 

 

CREATE DATABASE [lob2]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N'a', FILENAME = N'L:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\DATA\a1.mdf' , SIZE = 4160KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ),
( NAME = N'a10_1', FILENAME = N'L:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\DATA\a10_1.ndf' , SIZE = 10240KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10240KB ),
( NAME = N'a10_2', FILENAME = N'L:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\DATA\a10_2.ndf' , SIZE = 10240KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10240KB ),
( NAME = N'a100', FILENAME = N'L:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\DATA\a100.ndf' , SIZE = 102400KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10240KB )
LOG ON
( NAME = N'a_log', FILENAME = N'L:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\DATA\a1_log.ldf' , SIZE = 2000064KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO

use lob2
go

create table tblx (idx int identity(1,1), col1 varchar(max))
go

declare @col1 varchar(max)
set @col1 = replicate (cast('a' as varchar(max)), 1000000)

insert tblx values (@col1)
go 100

dbcc showfilestats