???????????SQL Server???????????——?????????????Instant File Initialization???????????SQL Server?????????????????????????????????????￡?????t??????????????????????????????????????????????μ??????SQL Server??????κ?Windows????????????
???????????
??????SQL Server??????????????????????????????????SQL Server????????WIN32 API????????0??????·????NTFS?????????·????????????????0???0x0????д???????????????????????????????????NTF????????洢?????????????SQL Server?????У???????0???????
?????????μ??????
????????????????
?????????????
??????????10GB????????????SQL Server??1???????10GB???????д??0???????????????????????????CREATE DATABASE???
1 -- Create a new 10 GB database
2 CREATE DATABASE TestDatabase ON PRIMARY
3 (
4     NAME = N'TestDatabase'??
5     FILENAME = N'D:SQLDATATestDatabase.mdf' ??
6     SIZE = 10240000KB ??
7     FILEGROWTH = 1024KB
8 )
9 LOG ON
10 (
11     NAME = N'TestDatabase_log'??
12     FILENAME = N'D:SQLLogTestDatabase_log.ldf' ??
13     SIZE = 1024KB ??
14     FILEGROWTH = 10%
15 )
16 GO
??????????????????????????10GB????????????????SQL Server??????????????仨?????49?????SQL Server???WIN32 API????д??10GB??0???洢??????????????????????????10GB?????????????????????????1????????????????????????????????????ζ???????????????????????????????SQL Server??1?????????????
????SQL Server??1??????10GB“??”?????????NTF??????????????????0???????
??????1?????????????SQL Server???д??10GB????????????????
????????????д???20GB??????????洢???????????????????????????SQL Server????????1???????д??10GB??????????洢——?????????????????
???????????????
???????????SQL Server?????????????????0????????????????????SQL Server??????????SERVICE???????????е?SQL Server??——??о????????Performance Volume Maintenance Task???????????????SQL Server??SQL Server?????????????????0????????????????????????????Ч——??SQL Server?????????????????0???????????????а??Σ???????????????????0???????????????????????????????????????????????????????????????????????????????????0??????
????????????secpol.msc??SQL Server??SERVICE?????????о????????Performance Volume Maintenance Task???????

???????????SQL Server??????????????????????0?????????????????CREATE DATABASE????????????210ms——????????????????????????????DBCC PAGE????????????NTFS????洢?????????
????1 -- Enable DBCC trace flag 3604
????2 DBCC TRACEON(3604)
????3 GO
????4
????5 -- Dump out a page somewhere in the data file
????6 -- A hex dump is working here
????7 DBCC PAGE (TestDatabase?? 1?? 1000?? 2)
????8 GO
????????????????????????????????????????????????￡?SQL Server??????????Щ????????——???·????NTFS????????洢??????——??SQL Server??????????????

?????????SQL Server??????????????????????????????????????????????????????????????????????????洢??????????????????????￡???SQL Server????????????????
???????????????????SQL Server???????????????У??????????3004??3605???????????Щ???????????SQL Server??????????????????????0????????????????????μ?????????????SQL Server??????????????????????????????????????????????????0????????