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

Secure remote control for conventional and virtual desktops

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. ®

Remote control for virtualized desktops

More from The Register

next story
Azure TITSUP caused by INFINITE LOOP
Fat fingered geo-block kept Aussies in the dark
NASA launches new climate model at SC14
75 days of supercomputing later ...
Yahoo! blames! MONSTER! email! OUTAGE! on! CUT! CABLE! bungle!
Weekend woe for BT as telco struggles to restore service
You think the CLOUD's insecure? It's BETTER than UK.GOV's DATA CENTRES
We don't even know where some of them ARE – Maude
DEATH by COMMENTS: WordPress XSS vuln is BIGGEST for YEARS
Trio of XSS turns attackers into admins
BOFH: WHERE did this 'fax-enabled' printer UPGRADE come from?
Don't worry about that cable, it's part of the config
Cloud unicorns are extinct so DiData cloud mess was YOUR fault
Applications need to be built to handle TITSUP incidents
Astro-boffins start opening universe simulation data
Got a supercomputer? Want to simulate a universe? Here you go
prev story

Whitepapers

Why cloud backup?
Combining the latest advancements in disk-based backup with secure, integrated, cloud technologies offer organizations fast and assured recovery of their critical enterprise data.
Forging a new future with identity relationship management
Learn about ForgeRock's next generation IRM platform and how it is designed to empower CEOS's and enterprises to engage with consumers.
How to determine if cloud backup is right for your servers
Two key factors, technical feasibility and TCO economics, that backup and IT operations managers should consider when assessing cloud backup.
Reg Reader Research: SaaS based Email and Office Productivity Tools
Read this Reg reader report which provides advice and guidance for SMBs towards the use of SaaS based email and Office productivity tools.
The Heartbleed Bug: how to protect your business with Symantec
What happens when the next Heartbleed (or worse) comes along, and what can you do to weather another chapter in an all-too-familiar string of debilitating attacks?