Browse by Tags

Tagged Content List
  • 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 (2 items)