Tag Archives: STATISTICS IO

Buffer Pool Extension – New feature in SQL Server 2014

Before diving into Buffer Pool Extension (BPE) details, it is worth taking a look at the Buffer Management to refresh your knowledge. You may find buffer management details @ http://technet.microsoft.com/en-us/library/aa337525(v=sql.105).aspx Buffer Pool Extension (BPE) can use nonvolatile storage devices (Ex: … Continue reading

Posted in SQL, SQL Query, sql2014 | Tagged , , , | Leave a comment

SET STATISTICS IO ON; SET STATISTICS TIME ON – performance tuning

SET STATISTICS IO ON and SET STATISTICS TIME ON are beautiful ways which can be used while performance tuning individual queries. SET STATISTICS IO ON Enabling STATISTICS IO is very informative as it displays Scan count, logical reads, physical reads, … Continue reading

Posted in Performance, Script, SQL, SQL Query | Tagged , , , , , | Leave a comment