Following on from my post last week on SQL Server 2014 : What’s New I am having a little deeper look into the Buffer Pool Extension (,strong>BPE). The introduction of the BPE, which is available in Standard Edition and Enterprise Edition allows you to extend your available memory by providing a hybrid buffer pool to help reduce I/O bottlenecks as long as you have access to an SSD.
With the recent release of SQL Server 2014 on April 1 2014, there are some things that we need to know and be aware of to allow us to make any decisions about our potential upgrade path to this new version. Reviewing the SQL Server 2014 licensing datasheet we can see the changes we need to know about.
SQL Server's AlwaysOn Availability Groups provide a very resilient way of providing High-availability for SQL Server databases, but there are inevitable limits to their capacity. How many database can you reasonable add? it depends on the resources available and the workload, but you can come up with a reasonable estimate as Warwick explains
Hi, I'm Warwick Rudd, I am a Microsoft Data Platform MVP as well as a Microsoft Certified Master working as the Principal Consultant here at SQL Masters Consulting.
In my blog I will look at all things SQL Server as well as some things outside of the SQL Server relm but hopefully you will find them helpful and interesting.