, SQL Server 2000. . , SQL Server 2000 , . , .
. , SQL Server 2000 , . , SQL Server 2000 - . , , . , , .
.
MSSQLSERVER
MSSQLServer, SQL Server 2000, Enterprise Manager, sp_configure. . , .
MSSQLServer Enterprise Manager SQL Server Properties. Enterprise Manager Properties. , 3.
SQL Server Properties , . , :
1. Configured values. , . . , . Configured values.
2. Running values. , , .. , . , .. , . Configured values.
, SQL Server 2000. .
|
|
General. General (. . 3) SQL Server Properties , , , , SQL Server, , , , , SQL Server 2000 .
Autostart policies when the operating system starts SQL Seiver 2000. . .
Startup Parameters, (. 4), SQL Seiver 2000, SQL Server 2000, SQL Server 2000 .
General Network Configuration. SQL Server Network Utility, .
Memory. , Memory (. 5) , SQL Server 2000
SQL Server 7.0 SQL Server 2000, , . , , SQL Server 2000. SQL Server 2000 , . , , .
, SQL Server 2000. , , . . , . . SQL Server 2000 , . , .
Dynamically configure SQL Server memory Memory SQL Server Properties , SQL Server 2000. Minimum (MB) Maximum (MB) , . 0 , . 4 .
SQL Server 2000 , 5 200 . . , SQL Server 2000 - . . 5 , SQL Server 2000 .
|
|
, Use a fixed memory size (MB). , SQL Server 2000. SQL Server 2000, , .
Windows NT ( Windows 2000) . (pagefile swapfile). , , SQL Server 2000, , SQL Server 2000 . , Reserve physical memory for SQL Server. SQL Server 2000 .
Memory Minimum query memory (KB). , . 512 2 . , , . .
Processor. Processor (. 6) , SQL Server 2000 .
, , SQL Server 2000. , SQL Server 2000 . . , SQL Server 2000.
SQL Server 2000 Windows NT 4.0 Windows 2000, , Microsoft, 32 . Windows NT Windows 2000 . , , . .
Security. Security (. 7) SQL Server 2000.
SQL Server 2000 : (mixed) Windows NT. , SQL Server, Windows NT. SQL Server .
, SQL Server 2000, Authentication. SQL Server and Windows NT/2000, . Windows NT/2000 only, SQL Server, Windows NT.
|
|
Audit level , SQL Server 2000. None, . Success SQL Server 2000 .
, Failure. All , .
Startup service account , MSSQLServer. System account . This account, .
Connections. Connections (. 8) , , .
Maximum concurrent user connections (0=unlimited) , , 0, , SQL Server 2000, 32 767. SQL Server 2000 , . 40 , .
0, SQL Server 2000 , . .
Allow other SQL Servers to connect remotely to this SQL Server using RPC SQL Server 2000 (RPC, Remote Procedure Call). , , . , .
Query time-out (sec, 0 = unlimited) , . , . Query time-out (sec, 0 = unlimited) 0, . , . o , , (deadlock).
Enforce distributed transactions (MTS), (MSDTC, Microsoft Distributed Transaction Coordinator).
|
|
Server Settings. Server Settings (. 9) . : , , .
Server Settings Default language for user, , .
Default language for user , Language. . , , Language, SQL Server Login Properties.
Server behavior . :
- Allow modifications to be made directly to the system catalogs . INSERT, UPDATE DELETE. , SELECT. . Microsoft ;
- Allow triggers to be fired which fire other triggers (nested triggers) (nested triggers) ( ). , , ;
- Use query governor to prevent queries exceeding specified cost , . , . , , , . .
- - . , . . .
SQL Mail Start mail session using profile, , MSSQLServer .
Server Settings Year 2000 support, , SQL Server 2000 , . (datetime smalldatetime) . . .
Database Settings. Database Settings (. 10) , .
Settings (fill factor) . , , . .
, . , , 100%. , .
, Fixed , . .
Backup/restore . , Time-out period , :
- Wait indefinitely . , ;
|
|
- Try once then quit , , ;
- Try for , . , .
Default backup media retention (days) , , SQL Server 2000 . . .
Database Settings Recovery interval (nun). , SQL Server 2000 (recovery database). SQL Server 2000. , (rollback) (commit) , . 0 , SQL Server 2000 . .
New database default location. , , . :
- Default data directory. , (mdf ndf). , ;
- Default log directory. .
Replication. Replications (. ).
. SQL Server 2000 , , .