Browse by Tags

Tagged Content List
  • Blog Post: What’s that HTDELETE wait type?

    One of the many improvements, shipped with the SQL Server 2014, made to the iterators used in the batch mode processing query execution paradigm applicable to a query that uses at least one columnstore index ( Apollo ) , corresponds to the enhancement and extension of aggregation. Among other things...
  • Blog Post: What’s in PREEMPTIVE_OS_FILEOPS wait type?

    This one wait type is one of the many hundreds which came up new with SQL Server 2008. As my colleague Denzil Ribeiro found in the code, this one in particular is one that accounts the time SQL Server threads have waited for file system operations to complete. SQL Server workers switch preemptive before...
  • Blog Post: What’s in SOS_PHYS_PAGE_CACHE?

    My colleague Assaf Fraenkel asked a few days ago about that wait type he noticed was showing up in some of the instances he works with, and that he hadn’t seen before. Where that wait type is used inside the engine and what it accounts for wasn’t publicly documented, so I took a peep into the source...
Page 1 of 1 (3 items)