procedure cache 中文意思是什麼

procedure cache 解釋
過程緩存
  • procedure : n. 1. 工序，過程，步驟。2. 程序，手續；方法；訴訟程序；（議會的）議事程序。3. 行為，行動，傳統的做法；（外交、軍隊等的）禮儀，禮節。4. 〈罕用語〉進行。
  • cache : n. 1. （探險者等貯藏糧食、器材等的）暗窖，密藏處。2. 貯藏物。3. 【計算機】高速緩沖內存。vt. 1. 貯藏；密藏；窖藏。2. 【計算機】把…儲存到硬盤上。
  1. When any sql statement is executed in sql server 2005, the relational engine first looks through the procedure cache to verify that an existing execution plan for the same sql statement exists

    在sql server 2005中執行任何sql語句時，關系引擎將首先查看過程緩存中是否有用於同一sql語句的現有執行計劃。
  2. After an execution plan is generated, it stays in the procedure cache

    生成執行計劃后，它處于過程緩存中。
  3. Number of pages in the procedure cache that are currently allocated to this process

    當前為此進程分配的過程緩存中的頁數。
  4. The lazywriter process periodically scans the list of objects in the procedure cache

    惰性寫入器進程定期掃描過程緩存中的對象列表。
  5. The part of the memory pool that is used to store execution plans is referred to as the procedure cache

    內存池中用於存儲執行計劃的部分稱為過程緩存。
  6. The age of our sample query plan is decremented to 0 after 16 scans of the procedure cache, unless another user references the plan

    在本例中，查詢計劃的年經過16次過程緩存掃描后減為0 ，除非其他用戶引用了該計劃。
  7. If there are any execution plans in the procedure cache that reference the table, alter table marks them to be recompiled on their next execution

    如果過程緩存中存在引用表的執行計劃， alter table會將這些執行計劃標記為下次執行時重新編譯。
分享友人
分享到 Line

分享到臉書