Murilo Miranda

Author
Recent Posts

Murilo Miranda is a Luso-Brazilian blogger and speaker. SQL Server MVP, living in the UK. Nowadays he's Database Consultant at Pythian, company based in Ottawa - Canada.

With experience working in Portugal, Holland, Germany and United Kingdom, he's always available to learn and share his knowledge, in order to contribute to SQL Server community,

View all posts by Murilo Miranda

Latest posts by Murilo Miranda (see all)

Understanding backups on AlwaysOn Availability Groups – Part 2 - December 3, 2015
Understanding backups on AlwaysOn Availability Groups – Part 1 - November 30, 2015
AlwaysOn Availability Groups – Curiosities to make your job easier – Part 4 - October 13, 2015

Using SMB fileshare as a storage alternative

January 16, 2015 by Murilo Miranda

Do you know that you can store system and user databases in a fileshare? Even for a clustered instance this is an option now. In this article we will check how to implement this solution.

On the latest versions of SQL Server new possibilities to assign storage to a clustered instance became available. In this article, we will talk about one of these options, which is also an option for standalone instances by the way: The network-attached storage – SMB Fileshare.

Buffer Pool Extension (BPE) – How it works?

December 31, 2014 by Murilo Miranda

You already understand the benefits of the BPE and how to deal with the feature, now it’s time to better understand how it works.

Here we are, the last article of this Buffer Pool Extension series. We came from the explanation of what is the Buffer Pool, made an introduction of the new In-Memory technology and saw on what the Buffer Pool Extension can help in keep a stable environment, and finally, the part 3 showed how to implement the Buffer Pool Extension in your SQL Server 2014 system.

Buffer Pool Extension (BPE) – Implementing another level of cache

December 30, 2014 by Murilo Miranda

This third part of the BPE series shows the basics of Buffer Pool Extension and know how to implement and troubleshoot it.

During all the Buffer Pool Extension (BPE) series we have been explaining base concepts related to this new technology, as well as its benefits. We understood how the Buffer Pool works and the main benefits of implement the Buffer Pool Extension together with In-Memory technology. I recommend you to read the previous articles, if you are not familiarized with those concepts, so everything into this article will make more sense 🙂

Buffer Pool Extension (BPE) – In-Memory OLTP: The Memory Challenge

December 24, 2014 by Murilo Miranda

In continuation of the previous post “Buffer Pool Extension (BPE) – Introduction to the Buffer Pool”, we will keep diving into the Buffer Pool Extension, this time, talking about another important factor behind this feature – the memory. No, we will not review how the memory works literally, we are talking about the great SQL Server 2014 new feature: The In-Memory OLTP, or the known HEKATON.

Buffer Pool Extension (BPE) – Introduction to the Buffer Pool

December 9, 2014 by Murilo Miranda

Introduced on SQL Server 2014, the Buffer Pool Extension came to build up a new layer of cache, helping to maintain the “hot” pages accessible with less effort. With the introduction of Hekaton, the BPE has also an important role. In this article we will explore all the aspects of this new feature as well as understand how it works.

With the release of SQL Server 2014, earlier this year, some new features were released, with a special remark to the In-memory OLTP (Hekaton). Together with that new feature, new challenges were brought. The available memory is, of course, one of the main challenges. More ahead, we will understand better why.