sql server 2008性能和可擴展性

1、SQLServer2008性能和可擴展性性能和可擴展性SQLServer技術(shù)文檔技術(shù)文檔作者：作者：AnnWeber(內(nèi)容主管)技術(shù)審核員：技術(shù)審核員：MichaelRaheem和NirajNagrani項目編輯：項目編輯：JoanneHodgins發(fā)布日期：發(fā)布日期：2007年8月適用產(chǎn)品：適用產(chǎn)品：SQLServer2008概述：概述：MicrosoftSQLServer?2008所集成的工具和技術(shù)都是實施關(guān)系型數(shù)據(jù)庫、報表系統(tǒng)、以

2、及企業(yè)級數(shù)據(jù)倉庫所必需的，并且還針對性能做了優(yōu)化。通過SQLServer2008，你可以在利用最新硬件技術(shù)的同時，對服務(wù)器進行整合。SQLServer2008還可以幫助你將復雜的數(shù)據(jù)解決方案進行擴展。目錄目錄導言導言................................................................................................................

3、...1使用使用SQLServer2008優(yōu)化性能優(yōu)化性能.............................................................................1關(guān)系型數(shù)據(jù)庫的性能關(guān)系型數(shù)據(jù)庫的性能...........................................................................................1可測量

4、的實際性能可測量的實際性能........................................................................................1高性能的查詢處理引擎高性能的查詢處理引擎...................................................................................1性能優(yōu)化工具性能優(yōu)化工具..

5、............................................................................................2ResourceGovern....................................................................................2性能套件性能套件....................

6、...............................................................................2數(shù)據(jù)倉庫和分析性能數(shù)據(jù)倉庫和分析性能...........................................................................................3報表服務(wù)性能報表服務(wù)性能..................

7、.................................................................................4集成服務(wù)性能集成服務(wù)性能...................................................................................................4擴展擴展SQLServer2008.........

8、................................................................................4硬件支持硬件支持........................................................................................................4熱插拔硬件熱插拔硬件................

9、.................................................................................5高級并發(fā)特性高級并發(fā)特性...................................................................................................5使用使用SQLServer2008向外擴展向外擴展.

10、............................................................................5可擴展的共享數(shù)據(jù)庫可擴展的共享數(shù)據(jù)庫...........................................................................................5數(shù)據(jù)選擇路由數(shù)據(jù)選擇路由.....................

11、..............................................................................5點對點復制......................................................................................................6查詢通知查詢通知.........................

12、...............................................................................6擴展分析服務(wù)...................................................................................................6總結(jié)總結(jié)..............................