Главная
Study mode:
on
1
Intro
2
Technical Assistance
3
Ross LoForte, Rick Heiges
4
Field Testing Background
5
Extending the Buffer Pool
6
Using BPE
7
BPE - Good Scenarios and Otherwise
8
Test Configuration
9
Database Cache
10
Process More Data
11
Increase Throughput
12
Consistent Low Latency is Key
13
What is SQL Server In-Memory OLTP?
14
Durability
15
Integrated Experience
16
Performance Factors for In-Memory OLTP Data resides in memory at all times
17
Migration
18
Demo In-Memory OLTP
19
Suitable Application Characteristics
20
Limitations in SQL Server 2014
21
Interpreting the Results
22
Overall Performance
23
Transaction Log Performance
24
Transaction Logs - Write Megabytes/sec
25
Transaction Logs - Write Latency (usec)
26
Database Startup Tests
27
Memory Optimized File Group
28
File Group Performance - Checkpoints
29
Scaling Beyond 12000 Users (24K Users)
30
Use Cases
31
Summary
32
References
Description:
Explore the powerful new features of SQL Server 2014 in this informative conference talk from PASS Data Community Summit. Dive into field benchmark results and customer examples of In-Memory OLTP (Codename "Hekaton") and Buffer Pool Extension (BPE) features. Learn how these technologies can significantly boost performance by leveraging today's powerful processors and fast solid-state storage. Discover the behavior, scalability, and ideal use cases for each feature through comprehensive testing conducted at MTC Chicago. Gain insights into extending the buffer pool, increasing throughput, and achieving consistent low latency. Understand the integrated experience, durability aspects, and performance factors of In-Memory OLTP. Examine suitable application characteristics, limitations in SQL Server 2014, and interpret detailed performance results, including transaction log performance and database startup tests. Explore real-world use cases and gather valuable references to enhance your SQL Server implementation. Read more

Field Testing Buffer Pool Extension and In Memory OLTP Features

PASS Data Community Summit
Add to list
0:00 / 0:00