100%(1)1 out of 1 people found this document helpful
This preview shows page 12 - 15 out of 19 pages.
Uses the referential integrity constraintServer operates in the following transaction modes: Autocommit transactions, Explicit transactions, Implicit transactions, and Batch-scoped transactions (Rothja, 2017). Interfaces: Command line interface, proxy interface, java.sql.Wrapper interface, Graphical Query Designer User Interface, ISQLServerCallableStatement, ISQLServerConnection, ISQLServerDataSource, ISQLServerPreparedStatement, ISQLServerResultSet, ISQLServerStatement (Genemi, 2019).Server core supportDatabase mirroring
MILESTONE 3 13Backup compressionAlways On failover cluster instancesAlways On availability groupsOnline page and file restoreOnline schema changeFast recoveryAccelerated database recoveryDatabase recovery advisorEncrypted backupHybrid backup to Windows AzureFailover servers for disaster recoveryFailover servers for high availabilityAlways EncryptedServer/database audit(Ray, 2019)6. Performance/ScalabilityMS SQL has a number of monitoring and performance tools to ensure the database and server.A performance dashboard in the Server Management studio helps to rapidly identify current performance bottlenecks. Further performance features include: In Memory OLTP, In-Memory ColumnStore, Buffer Pool extension to SSD, Real Time Operational Analytics, Adaptive Query Processing (SQL Server 2017 comparison). SQL Server 2016 (13.x) contains scalability enhancements to the on-disk storage for memory-optimized tables (Genemi, 2015).The following link below details scale limits (CPU, RAM, IO), scalability, and performance features for each edition of MS SQL (-us/sql/sql-server/editions-and-components-of-sql-server-2016?view=sql-server-ver15)An additional technology that can be used with MS SQL Server is Amazon RDS for SQL server. With AWS RDS you can easily set up, operate, and scale MS SQL Server deployments into the cloud. RDS manages time-consuming database administration tasks including provisioning, backups, software patching, monitoring, and hardware scaling (Neu, 2017). This allows DBA’s to focus on the school’s applications, allowing for faster performance, high availability, security, and compatibility that is needed rather than non-value administrative tasks.
MILESTONE 3 14RDS is scalable, faster, and cheaper because it is hosted on AWS cloud storage. While it is an extra cost, its inexpensive and can benefit the school by bringing more value to it and potentially cut back costs related to hiring multiple individuals to perform the tasks needed of a DBA. With AWS RDS, you pay low rates only for the resources that you actually consume, and you also benefit from the option of On-Demand pricing with no upfront or long-term commitments, and even lower hourly rates via Reserved Instance pricing (Neu, 2017).