2 SQL Server 7.0 SQL Server SQL Server 7 SQL Server 7 5 2.1 SQL Server 7 SQL Server 7 SQL Server SQL Server SQL Server 2.1.1 SQL Server Windows NT/2000 Windows 95/98 ( r a n d o m access memory R A M ) SQL Server ( 512 M B R A M 512 M B 1 G ( p a g e ) ( ( ) ( ) ( s w a p p i n g ) ( p a g i n g ) I / O ( SQL Server SQL
8 SQL Server 2.1.2 SQL Server SQL Server (memory pool SQL Server (Open Data Services ( D L L ( 2-1 SQL Server ( b u ffer cache) (procedure cache S Q L ( T- S Q L ) (log cache ( ) (connection context) D L L E X E T- S Q L ( ) ( ) 2-1 SQL Server SQL Server SQL Server SQL Server SQL Server ( SQL Server ( I / O
2 SQL Server 7.0 9 S Q L 1 4 0 Windows NT Windows 2000 SQL Server ( l a z y w r i t e r SQL Server ( ) 0 Windows NT Wi n d o w s 2 0 0 0 I / O Windows 95 Windows 98 ( 2. 5. 4 SQL Server SQL Server I / O 2.1.3 SQL Server 7 SQL Server SQL Server ( ( SQL Server SQL Server ( SQL Server ( 200 K B 5 M B SQL Server SQL Server 5 M B SQL Server 5 M B SQL Server S Q L S e r v e r ( 5 M B SQL Server SQL Server SQL Server min server memory( SQL Server
1 0 SQL Server 256 M B min server memory 256 ( SQL Server SQL Server max server memory( ) SQL Server 512 M B max server memory 512 ( SQL Server SQL Server min server memory Windows NT / ( SQL Server SQL Server SQL Server SQL Server min server memory max server memory SQL Server ( ) SQL Server SQL min server memory max server memory SQL Server s p _ c o n f i g u r e show advanced options( ) SQL Server RECONFIGURE (SQL Server SQL Server (Enterprise Manager P r o p e r t i e s ( ) M e m o r y ( SQL Server SQL Server SQL ( D B A )
2 SQL Server 7.0 11 2.1.4 Windows NT 4 4 G B 2 G B 2 G 2 G B SQL Server Microsoft Windows NT 4 50 3 G B 3 G B 1 G B Windows NT 4 b o o t. i n i / 3 G B Windows 2000 Windows 2000 ( Windows D a t a c e n t e r ) 64 G B Windows 2000 (Advanced Server Windows 2000 SQL Server 7 Windows 2000 8GB Windows 2000 64GB 2.2 SQL Server 7 SQL Server 7 2.2.1 SQL Server 7 Windows NT ( N T F S ) ( FAT ) ( ( p a g e ) SQL Server T- S Q L SQL Server. m d f. n d f. l d f
1 2 2-2 2-3 C u s t o m e r s - c u s t - p r ( ) ( ) 1 c u s t - d a t a 1 - c u s t - p r ( ) ( ) 2 c u s t - d a t a 2 - l o g 1 3 c u s t - d a t a 3 1 - l o g 1 2 - l o g 2 2-2 2-3 SQL Server 32TB 4TB 2.2.2 SQL Server ( ) c u s t o m e r s _ f g ( ) 1 2 ( 3 ) 1 2-4 c u s t o m e r s _ f g 2 ( c u s t o m e r ) 2-4
2 SQL Server 7.0 13 ( 3 R A I D ) T 1 T 2 T 1 T 2 T 1 T 1 T 2 T 1 T 2 T 2-5 I / O I / 2-6 2 1 T 2 T 1 1 T 1 T 2 1 2-5 2-6 I / O ( ) I / O SQL Server SQL F 1 400 M B F 2 100 M B F 1 4 F 2 1 ( 8 ( )
1 4 d b _ o w n e r A LTER DATA B A S E SQL Server (SQL Server Books Online SQL Server SQL Server 7 5 15 2.2.3 SQL Server 7 SQL Server ( SQL Server (growth increment SQL Server SQL Server ( SQL Server 2.2.4 SQL Server S Q L Server 7 8 K B ( SQL Server 2 K B SQL Server ( 96 B
2 SQL Server 7.0 15 ) ( I D SQL Server 6 / 8 64 K B 8060 B I / O I / 2.3 SQL Server 7 (online transaction processing O LT P ) SQL Server 2.3.1 SQL Server 2.3.2 SQL Server ( (row identifier, RID) (Key) (Page) 8 K B (Extent) 8 64 K B
1 6 ( Table) (Database) SQL Server S E L E C T I N S E RT U P D AT E D E L E T E (data definition language D D L TA B L O C K SQL Server SQL Server SQL Server SQL Server SQL ( 2.3.3 SQL Server l o c k s ( ) l o c k s SQL Server 0 SQL 96 B SQL Server 40 l o c k s 0 SQL Server l o c k s l o c k s SQL Server show advanced options( 1 s p _ c o n f i g u r e SQL Server 19 2.4 ( t h r e a d SQL Server Windows NT
2 SQL Server 7.0 17 SQL Server ( ) ( SQL Server SQL Server Windows NT SQL Server ( C P U SQL Server a ffinity mask SQL Server SQL Server C P U C P U C P U I / O C P U C P U Windows NT C P U C P U (context switch) SQL Server ( f i b e r s ) SQL Server S Q L S e r v e r S Q L S e r v e r Windows NT C P U SQL Server s p _ c o n f i g u r e l i g h t w e i g h t p o o l i n g ( ) SQL Server S Q L (worker thread S Q L SQL Server C P U max worker t h r e a d s ( SQL Server 255 ( s p _ c o n f i g u r e S Q L SQL Server S Q L S e r v e r SQL Server SQL Server 255 Windows 95 2.5 Windows 98 max worker thread SQL Server 7
1 8 2.5.1 SQL Server 7.0 SQL Server 7 I / O SQL Server SQL 6.5 I / O SQL Server ( SQL Server 6.5 2 K B 8 K B ( ) ( 16 K B 3 2 K B 2.5.2 SQL Server SQL Server SQL Server SQL Server SQL Server 2-7 2-8 2-9 SQL Server 1 2 3 2-7
2 SQL Server 7.0 19 1 2 3 4 2-8 1 2 3 4 2-9 ( 15 ( ) 2. 5. 4 2.5.3
2 0 trunc.log on chkpt T R U E 2.5.4 ( c h e c k p o i n t ( SQL Server SQL ( ) 1. SQL Server C H E C K P O I N T S H U T D O W N SQL Server (Service Control Manager SQL Server 2. ( recovery interval( SQL Server SQL Server recovery interval S Q L S e r v e r SQL Server 0
2 SQL Server 7.0 21 SQL Server 1 30 recovery interval T- S Q L recovery interval c o n t e x t P r o p e r t i e s SQL Server Proterties Database Settings( ) Recovery Interval Spin( T- S Q L recovery interval s p _ c o n f i g u r e SQL Server R E C O N - F I G U R E T- S Q L R E C O N F I G U R E SQL Server T- S Q L ( recovery interval recovery interval 2.6 SQL Server SQL R A I D I / O