數(shù)據(jù)庫編程外文翻譯-其他專業(yè)-在線瀏覽
2025-03-24 11:58本頁面
【正文】 ly supported until the first Service Pack release (SP1). In the initial release (RTM) of SQL Server 2021, database mirroring was available, but unsupported. In order to implement database mirroring in the RTM version, you had to apply trace flag 1400 at startup. Database mirroring is a high availability option that provides redundancy and failover capabilities at the database level. Failover can be performed manually or can be configured for automatic failover. Automatic failover requires a witness partner and an operating mode of synchronous (also known as highsafety or full safety). Editions Microsoft makes SQL Server available in multiple editions, with different feature sets and targeting different users. These editions are: Mainstream editions Datacenter SQL Server 2021 R2 Datacenter is the fullfeatured edition of SQL Server and is designed for datacenters that need the high levels of application support and scalability. It supports 256 logical processors and virtually unlimited memory. Comes with StreamInsight Premium edition. Enterprise SQL Server Enterprise Edition includes both the core database engine and addon services, with a range of tools for creating and managing a SQL Server cluster. It can manage databases as large as 524 petabytes and address 2 terabytes of memory and supports 8 physical processors. Standard SQL Server Standard edition includes the core database engine, along with the standalone services. It differs from Enterprise edition in that it supports fewer active instances (number of nodes in a cluster) and does not include some highavailability functions such as hotadd memory (allowing memory to be added while the server is still running), and parallel indexes. Web SQL Server Web Edition is a lowTCO option for Web hosting. Workgroup SQL Server Workgroup Edition includes the core database functionality but does not include the additional services. Express SQL Server Express Edition is a scaled down, free edition of SQL Server, which includes the core database engine. While there are no limitations on the number of databases or users supported, it is limited to using one processor, 1 GB memory and 4 GB database files (10 GB database files from SQL Server Express 2021 R2). The entire database is stored in a single .mdf file, and thus making it suitable for XCOPY deployment. It is intended as a replacement for MSDE. Two additional editions provide a superset of features not in the original Express Edition. The first is SQL Server Express with Tools, which includes SQL Server Management Studio Basic. SQL Server Express with Advanced Services adds fulltext search capability and reporting services. Specialized editions Azure Microsoft SQL Azure Database is the cloudbased version of Microsoft SQL Server, presented as software as a service on Azure Services Platform. Compact (SQL CE) The pact edition is an embedded database engine. Unlike the other editions o
環(huán)評公示相關推薦
鄂ICP備17016276號-1