Tips, Tricks, and Advice from the SQL Server Query Processing Team

The query processing team - query optimization & execution - providing tips, tricks, advice and answers to freqeuently-asked questions in a continued effort to make your queries run faster and smoother in SQL Server.

Browse by Tags

Tagged Content List
  • Blog Post: Mystery of memory fraction in Showplan XML

    If you examine Showplan XML, you may find an entry like <MemoryFractions Input="1" Output="1" /> on some operators . They are internal parameters used by query memory grant to save overall memory usage, and “fraction” means how much this operator is allowed to use from “total additional memory...
  • Blog Post: Understanding SQL server memory grant

    This article describes how query memory grant works in Microsoft SQL Server. It applies to both SQL2005 and SQL2008. Written by Jay Choe, Microsoft SQL Server Engine. -------------------------------------------------------------------------------- Query memory grant (a.k.a. query work buffer) is...
  • Blog Post: Query Execution Timeouts in SQL Server (Part 1 of 2)

    This short article provides a checklist for query execution time out errors in Yukon . It does not touch the time out issues on optimization and connection. Before reading this article, you are recommended to read the following post to get familiar with SQL Server memory management architecture: http...
Page 1 of 1 (3 items)