Feeds

Hit the Nytro: LSI's PCIe cards now even faster with SQL Server 2014, says firm after upgrade

Less spinning rust, more flashy goodness for you all

Protecting against web application threats using SSL

Chip-making chappies LSI have added some go-faster SQL 2014 juice to their Nytro PCIe server flash cards.

SQL Server 2014 can run in-memory; LSI's updated Nytro cards provide a server with PCIe-connected flash. SQL 2014 has a Buffer Pool Extension feature which puts an, erm, buffer pool extension into flash memory where it functions as a level 2 cache, subordinate to the level 1 cache which is DRAM.

That means, where the SQL Server 2014 working set is bigger than the L1 cache, it can avoid going to disk for data it wants that isn't in the L1 cache and so run faster.

SQL Server 2014 will automatically transfer frequently accessed read data into the L2 cache, by writing them into a BPE file. An Alter Server Configuration command used to place the BPE file on the Nytro card.

LSI Nytro and SQL Server 2014 BPE feature

Click pic for larger version

A Microsoft web page says;

The buffer pool extension feature extends the buffer pool cache with non-volatile storage (usually SSD). Because of this extension, the buffer pool can accommodate a larger database working set, which forces the paging of I/Os between RAM and the SSDs. This effectively offloads small random I/Os from mechanical disks to SSDs. Because of the lower latency and better random I/O performance of SSDs, the buffer pool extension significantly improves I/O throughput.

Fusion-io's PCIe flash cards support the BPE feature in SQL Server 2014, and we would suspect there's a set of Microsoft-certified PCIe flash cards and SSDs for BPE as well as the Fusion-io and LSI Nytro products.

Read more about SQL Server 2014 BPE here and get more LSI data on it here. ®

Choosing a cloud hosting partner with confidence

More from The Register

next story
Wanna keep your data for 1,000 YEARS? No? Hard luck, HDS wants you to anyway
Combine Blu-ray and M-DISC and you get this monster
Google+ GOING, GOING ... ? Newbie Gmailers no longer forced into mandatory ID slurp
Mountain View distances itself from lame 'network thingy'
US boffins demo 'twisted radio' mux
OAM takes wireless signals to 32 Gbps
Apple flops out 2FA for iCloud in bid to stop future nude selfie leaks
Millions of 4chan users howl with laughter as Cupertino slams stable door
Students playing with impressive racks? Yes, it's cluster comp time
The most comprehensive coverage the world has ever seen. Ever
Run little spreadsheet, run! IBM's Watson is coming to gobble you up
Big Blue's big super's big appetite for big data in big clouds for big analytics
Seagate's triple-headed Cerberus could SAVE the DISK WORLD
... and possibly bring us even more HAMR time. Yay!
prev story

Whitepapers

Secure remote control for conventional and virtual desktops
Balancing user privacy and privileged access, in accordance with compliance frameworks and legislation. Evaluating any potential remote control choice.
WIN a very cool portable ZX Spectrum
Win a one-off portable Spectrum built by legendary hardware hacker Ben Heck
Storage capacity and performance optimization at Mizuno USA
Mizuno USA turn to Tegile storage technology to solve both their SAN and backup issues.
High Performance for All
While HPC is not new, it has traditionally been seen as a specialist area – is it now geared up to meet more mainstream requirements?
The next step in data security
With recent increased privacy concerns and computers becoming more powerful, the chance of hackers being able to crack smaller-sized RSA keys increases.