Whether the database is closed and its resources are freed when no user connection accesses the database. Value - 3 Description - Unknown Explanation - The recovery type is not known. All operations are fully logged, including bulk operations such as SELECT INTO, CREATE INDEX, and bulk loading data. Value - 2 Description - Full Explanation - Database backups and transaction log backups provide full recoverability from media failure. In exchange for better performance and less log space usage, the risk of exposure to loss is greater than with full recovery. Value - 1 Description - Bulk Logged Explanation - Logging for all SELECT INTO, CREATE INDEX, and bulk loading data operations is minimal and therefore requires less log space. Value - 0 Description - Simple Explanation - The database can be recovered only to the last full database backup or last differential backup. Type of recovery model that a database will use: Whether the comparison method for multi-byte character data is case-sensitive or not. Also, whether the database is unavailable, or is being made unavailable, for use by authorized users. Table 1-3 Database Setting Configuration Metrics Metric TCP/IP Sockets Net-Libraries port number on an instance of the SQL Server. Version of Simple Management Protocol (SNMP) currently installed on an instance of the SQL Server.ĭefault operating system directory implementing storage for SQL Server system user-defined databases. Whether Simple Network Management Protocol (SNMP) is installed on an instance of the SQL Server. TRUE when components supporting replication are installed. Windows NT Performance Monitor polling behavior when the monitor is launched. Operating system path and file name to be used for the SQL Server error log. Number of CPUs available to the SQL Server on the server. If FALSE, the SQL Server sends events only to the SQL Server error log. If TRUE, the SQL Server sends all events to the Windows NT application log and the SQL Server error log. Whether the SQL Server uses the Windows NT application log. The full path and file name of the operating system file containing the master database. Table 1-2 Registry Setting Configuration Metrics MetricĬomparison method for multi-byte character data is either case-sensitive or not.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |