Hi all,

Here is an interesting case I encountered recently.

I have a procedure that takes >45 sec to complete.
The users would very much like to have it execute much faster.
It has > 11,000 lines of code and originally, it went something like this: (more…)

SQL Server 2014 – Intense read/write contention (3/3)

In Part I of this series, we reviewed the benefits that In-Memory OLTP may provide for workloads that are bound by insert performance.In part II, we took a look at the benefits it may offer for workloads that are less constrained by inserts, but require ultra-fast access to read-only, or read-mostly data. Today, we will look at the benefits that In-Memory OLTP can offer workloads that suffer from extreme contention between reads and writes.


SQL Server 2014– In-Memory OLTP for insert performance (1/3)

SQL Server 2014– In-Memory OLTP for insert performance (1/3)

SQL Server 2014 has been released last week, isn’t that great? Sure it is! But what’s in it for you? should you run to your CTO to get the upgrade budget right now? Do you start building the new servers immediately? Are you one of those people that wait for service pack <fill in> before you consider going to production? To make the right decision, you need to make sure the value proposition of the upgrade is worthwhile and will give you a positive return. In the next few blog posts, we will cover some of the exciting new technologies that SQL Server 2014 has to offer, what bottlenecks they were designed to solve, and provide general guidelines regarding their actual benefit and where these might be a good fit. (more…)