Tag Archives: resource

Video on Performance tuning memory allocation and spill issues

By | September 20, 2015

I was inspired by a recent article I read on parameter sniffing to add my own contribution to the topic, I explain how tempdb spools occur due to poor memory grants and they impact of parameter values in determining how much resources are allocated. I then go on to cover two different ways that the… Read More »

Lock, Latches, Waits and Deadlocks explained weirdly (like never before)!!!

By | August 27, 2015

When conducting MS SQL Server Trainings I often resort to weird examples to explain how certain things work. Over the years I have some favorites that I use over and over. The most disgusting by far would be the one I use to explain Locking, blocking and deadlocks. There are some definite advantages to doing… Read More »

Better Triage: Getting hospital care delivered properly

By | August 18, 2015

If you have seen my recent posts on LinkedIn you probably know that I am looking to interact with healthcare professionals to brainstorm ideas on how Triage can be improved. In this post I will cover what Triage is and some common issues identified with the process and my attempt at a solution. I am… Read More »

SQL 2016- Live Query Stats

By | July 16, 2015

I am a bit confused about this feature so I thought I would post about it to get feedback on its usage in SQL 2016. With SQL 2016 there is a feature called Live Query Stats being introduced. As its name suggests it provides details on the actual tasks being executed in real time. What… Read More »

Sports- Answer to the Ultimate Question of Life, the Universe, Project Management and Everything”

By | July 1, 2015

I recently was posed an interesting question. How to measure an individual’s contribution or the success of a project. A question we all face during our appraisal cycles. While I am no expert, I rely on my experience from my college years a lot when faced with management questions. To provide some context, I was… Read More »

Performance Tuning CPU issues in MS SQL Server – Indexes

By | March 18, 2015

In this video we cover how the correct use of Indexes can help elimintae CPU bottlenecks , we cover how to identify CPU issues and a few different ways the issues can be resolved. Performance Tuning CPU issues The video is ment to provide a starting place for novices to undertsand the role played by… Read More »

Part 2 Buffer pool extension SQL 2014

By | January 16, 2015

In this second part (read the first part here) of the series we continue testing the limits of our RAM and try to understand SQLs behaviour when it encounters memory pressure. To this end we have created a table that is little more than 2 GB in size and have set out SQL server buffer… Read More »