??SQL Server???????????

SQL Server????????????

    SQL Server?洢???汾???????Windows?μ?????????SQL Server???????????Windows????????????????Windows??????檔??Windows??????????SQL Server????????????????????????????棨???????????????????????(????DLL?????????????)?????????????????SQL Server??????????á????????????????2??С??????????????sqlservr.exe?????????п????????2????????????檔

    ??????????SQL Server??????????????ж???????????????????????(???????Windows??????????)??????????????????????????????????и?????????????????????3?????

    ?3.SQL Server ???????????

    ???????CPU??0?????????????????13??G??????????????????SQL Server??Windows?????????????????????

    ????SQL Server?????????????????????????????????

    1.?????????С

    2.?????Windows?汾????????????(????windows server 2008???????????????????32GB)

    3.SQL Server??32λ??64λ

    4.???2???????SQL Server?????????????

    5.SQL Server??汾(????express???????1G???)

 
SQL Server OS????????????

    SQL Server OS???????????????????????????????4?????

    ?4.SQL Server OS??????????

Memory Node

    ?????????Memory Node??Memory Node??????????÷????????Windows?????SQL Server OS??????С????SQL Server???????????????Memory Node??Memory Node??????????NUMA???????????á???????? DBCC MEMORYSTATUS  ???????Memory Node???Щ????????5?????

    ?5.??Memory Node???