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

The essential guide to IT transformation

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

Boost IT visibility and business value

More from The Register

next story
Pay to play: The hidden cost of software defined everything
Enter credit card details if you want that system you bought to actually be useful
HP busts out new ProLiant Gen9 servers
Think those are cool? Wait till you get a load of our racks
Shoot-em-up: Sony Online Entertainment hit by 'large scale DDoS attack'
Games disrupted as firm struggles to control network
Silicon Valley jolted by magnitude 6.1 quake – its biggest in 25 years
Did the earth move for you at VMworld – oh, OK. It just did. A lot
VMware's high-wire balancing act: EVO might drag us ALL down
Get it right, EMC, or there'll be STORAGE CIVIL WAR. Mark my words
Forrester says it's time to give up on physical storage arrays
The physical/virtual storage tipping point may just have arrived
prev story

Whitepapers

Top 10 endpoint backup mistakes
Avoid the ten endpoint backup mistakes to ensure that your critical corporate data is protected and end user productivity is improved.
Implementing global e-invoicing with guaranteed legal certainty
Explaining the role local tax compliance plays in successful supply chain management and e-business and how leading global brands are addressing this.
Backing up distributed data
Eliminating the redundant use of bandwidth and storage capacity and application consolidation in the modern data center.
The essential guide to IT transformation
ServiceNow discusses three IT transformations that can help CIOs automate IT services to transform IT and the enterprise
Next gen security for virtualised datacentres
Legacy security solutions are inefficient due to the architectural differences between physical and virtual environments.