Netherlands: Software

Introductie van Micorosoft SQL Server 2016

Issue link:

Contents of this Issue


Page 16 of 212

6 C H A P T E R 1 | Faster queries @sql += N'UPDATE STATISTICS ' + quotename(schema_name(t.schema_id)) + N'.' + quotename( + ';' + CHAR(13) + CHAR(10) FROM sys.tables AS t WHERE t.is_memory_optimized = 1; EXECUTE sp_executesql @sql; When the statistics change on a table, any natively compiled modules might not run as efficiently afterward. The automatic update does not recompile the natively compiled modules. Therefore, you should periodically use sp_recompile to reoptimize the natively compiled modules. Planning data migration to memory-optimized tables SQL Server 2016 includes several tools for helping you plan a migration of data in existing tables to In-Memory OLTP. Reports and tasks in SQL Server Management Studio (SSMS) help you evaluate workloads and create checklists of migration steps. You can also use SQL Server PowerShell or Windows PowerShell to evaluate candidate objects for migration. In SSMS, you can now run the Transaction Performance Analysis Report directly on the production database. You do not need to configure a management data warehouse or data collectors as you do for SQL Server 2014. To run the report, right-click a database in Object Explorer, point to Reports, point to Standard Reports, and then select Transaction Performance Analysis Overview. You then choose Tables Analysis or Stored Procedure Analysis. If you choose the Table Analysis option, a report with a scatterplot chart showing the relative performance gain and amount of migration work required is displayed, as shown in Figure 1-1. When you click a table in the chart, a new report displays query-access characteristics and contention statistics for the selected table. Figure 1-1: Transaction Performance Analysis Overview.

Articles in this issue

Archives of this issue

view archives of Netherlands: Software - Introductie van Micorosoft SQL Server 2016