Sunday, April 6, 2014

Video: SQL Server Performance Tuning with Wait Statistics (Introduction)

To investigate performance bottleneck, Wait Statistics is a power full tool which a DBA like to use on priority. Understanding waits is not that difficult but the way books and blog entries describe, makes it more complicated.
This is first out of 5 videos series. A simple way to understand internals of WAITS and how they can effectively be used to resolve SQL Server performance problems.


SQL Server Performance Tuning with Wait Statistics (Introduction) from aasim abdullah on Vimeo.

Sunday, March 2, 2014

Video: SQL Server 2014 - In Memory OLTP (Data Durability)

SQL Server 2014 - In Memory OLTP as per its name, keeps all the rows for memory optimized tables inside memory. What would happen, if hardware fails. Don't worry SQL Server 2014 take cares… Checkout our third and last animated video of this series.



SQL Server 2014 - In Memory OLTP (Data Durability) from aasim abdullah on Vimeo.

----------------------------------------------------------------------------------------
Don't miss other videos of this series
----------------------------------------------------------------------------------------
SQL Server 2014 - In Memory OLTP (Overview)
SQL Server 2014 - In Memory OLTP (MultiVersion Concurrency Control)