Feature sql server terbaru performance.pptx

feautre

1. Feature MsSql

2. It simplifies performance troubleshooting to help quickly find performance differences caused by query plan changes Query Store automatically captures a history of queries, plans, and runtime statistics, and retains these for review can be enabled for particular databases where you want troubleshooting and not the entire server Query Store

3. MsSQL 2016 or higher version SQL Server Management Studio must installed OS windows support MsSQL 2016 or higher version Requirement

4. This feature resumes an online index rebuild operation from where it stopped after events such as database failovers, running out of disk space, or pauses. Resumable online index rebuild

5. Clustered indexes must be created, rebuilt, or dropped offline when the underlying table contains image, ntext , and text large object (LOB) data types. Don’t create a new index online while rebuilding an existing index online on the same table additional Disk space MsSQL 2017 or higher version Requirement

6. can use Machine Learning Services to build and train machine learning and deep learning models within SQL Server Can run Python and R scripts with relational data can use open-source packages and frameworks, and the  Microsoft Python and R packages  for predictive analytics and machine learning SQL Server Machine Learning Services

7. A database engine instance is required. You cannot install just R or Python features, although you can add them incrementally to an existing instance. No failover cluster MsSQL 2017 or higher version Do‘t install   Machine Learning Server (Standalone)  on the same computer running an in-database instance Requirement

8. analyzes databases and makes recommendations that you can use to optimize query performance. can use to select and create an optimal set of indexes, indexed views, or table partitions without having an expert understanding of the database structure or the internals of SQL Server. Recommend the best mix of rowstore and  columnstore  indexes for databases by using the query optimizer to analyze queries in a workload. Tune workloads from a variety of sources including SQL Server Query Store, Plan Cache, SQL Server Profiler Trace file or table, or a .SQL file. Recommend aligned or non-aligned partitions for databases referenced in a workload. Recommend indexed views for databases referenced in a workload. Analyze the effects of the proposed changes, including index usage, query distribution among tables, and query performance in the workload. Recommend ways to tune the database for a small set of problem queries. Allow you to customize the recommendation by specifying advanced options such as disk space constraints. Provide reports that summarize the effects of implementing the recommendations for a given workload. Consider alternatives in which you supply possible design choices in the form of hypothetical configurations for Database Engine Tuning Advisor to evaluate. Database Tuning Advisor

9. user who is member of the  sysadmin  fixed server role must initialize the Database Engine Tuning Advisor. Initialization also enables users that are members of the  db_owner  fixed database role MsSQL 2012 or higher version Requirement

10. protects the data from rogue administrators, backup thieves, and man-in-the-middle attacks. Always Encrypted allows you to encrypt only certain columns, rather than the entire database. Data can decrypted only in application Always Encrypted

11. MsSQL 2016 or higher version SQL management studio or power shell Key metadata Encryption properties of the selected database columns, and/or encrypting the data that may already exist in columns that need to be encrypted. Requirement