THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL2014 » Performance   (RSS)
  • Updateable columnstore index gotchas

    SQL Server 2014 introduces updateable nonclustered and clustered columnstore indexes. When new data is inserted, it goes first to deltastore where background process divides it into row groups, indexes and compresses. Indexing progress can be observed via sys.column_store_row_groups DMV. According to BOL, row groups in deltastore can be in one of ...
    Posted to Michael Zilberstein (Weblog) by mz1313 on December 1, 2013
  • Delayed Durability–I start to like it!

    In my previous post about the subject I’ve complained that according to BOL, this feature is enabled for Hekaton only. Panagiotis Antonopoulos from Microsoft commented that actually BOL is wrong – delayed durability can be used with all sorts of transactions, not just In-Memory ones. There is a database-level setting for delayed durability: ...
    Posted to Michael Zilberstein (Weblog) by mz1313 on November 5, 2013
  • sys.dm_exec_query_profiles – FAQ

    As you probably know, this DMV is new in SQL Server 2014. It had been first announced in CTP1 but only in BOL. Now in CTP2 everyone can “play” with it. Since BOL is a little bit unclear (understatement detected), I’ve prepared this small FAQ as a result of discussion with Adam Machanic (blog | twitter) and Matan Yungman (blog | twitter). Q: What ...
    Posted to Michael Zilberstein (Weblog) by mz1313 on October 21, 2013
  • New DMV–yes… no… that’s complicated

    Remember the excitement about new sys.dm_exec_query_profiles DMV? It promised to be a gamechanger, providing query visibility at a runtime and easily extractable information about heavy iterators in execution plan. So it has been announced but missing. Now in CTP2 it is finally here. So, singing one of my favorite Queen songs “… It finally ...
    Posted to Michael Zilberstein (Weblog) by mz1313 on October 16, 2013
  • SQL Server 2014 – delayed transaction durability

    As I’m downloading SQL Server 2014 CTP2 at this very moment, I’ve noticed new fascinating feature that hadn’t been announced in CTP1: delayed transaction durability. It means that if your system is heavy on writes and on another hand you can tolerate data loss on some rare occasions – you can consider declaring transaction as DELAYED_DURABILITY = ...
    Posted to Michael Zilberstein (Weblog) by mz1313 on October 16, 2013
  • New DMV… not yet

    Downloaded and installed new toy: And while reading BOL, stumbled upon new extremely useful DMV: sys.dm_exec_query_profiles. This DMV enables DBA to monitor query progress while it is being executed. Counters in the DMV are per operation per thread. So we’ll be able to monitor in real time which thread (even for parallel processing) processes ...
    Posted to Michael Zilberstein (Weblog) by mz1313 on July 1, 2013
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement