If your most recent partitions become fragmented due to activity it’s no longer necessary to rebuild indexes on the entire table. Individual partitions may now be rebuilt individually. This feature is only available in Enterprise edition of SQL Server 2014 and require a 64 bit installation of SQL Server. This feature can improve performance substantially but there is a small window where a crash may cause data loss. A non-durable, memory only table is also supported – but in case of a crash all data in these tables will be lost. These tables are also versioned so that concurrent reads and writes are supported with reduced locking. A second copy of the table exists on disk and is updated shortly after transactions are updated. The new Memory-Optimized table feature of SQL Server 2014 allows us to safely create tables in memory for improved performance. This feature requires a 64 bit installation and works with Enterprise or Standard edition of SQL Server 2014.
Because ssd has much better IO performance than normal disk we get the benefits of a very large buffer pool without adding more memory. The Buffer pool extension allows us to extend the buffer pool to storage (you’ll want this to be ssd since we’re trying to speed things up). This was easy and effective but not always practical and often expensive. In previous versions of SQL Server the easy way to fix IO issues was to add memory. This feature requires Enterprise edition of SQL Server 2014. This option also allows us to selectively terminate blocking processes caused by online index rebuilds. You can now specify how long an index rebuild should wait for the locks required. We are excited to discuss how implementing new features, can help benefit your SQL Server environment. XTIVIA is highlighting the following new features in SQL Server 2014 and can assist you with the implementation of these features, as well as all other new features available with the 2014 version.
0 kommentar(er)
