?????????κε?????????????????????????????е?д???????????????????????λ???????
????1.?????db??????????????????ó??MB(M)????????????????????????????????????????100-200M??????????????????????????С????????á?
????????????????????mdf??????????1m????????db?????д?????????????????????????????????????????????io????????????????????????????????
?????????????????ldf?????????????10%???????????db????????????д???????????????????????????????????????С??100G?????????????????10G????λ????????????????????????????10??G??????????io?????????????

????2.???????????Щ??檔????????С??????????64g????????????sqlserver??60g????4??g?????????????仰?????????????????????sqlserver???Щ???????????????sqlserver??????????????????????????64g??????sqlserver???????50g?????????????????????????????????????????sqlserver????50g??????????14g??檔?????Щ??????????????÷?sqlserver????棬??????????????????????????????д????????????????sqlserver??64g??涼???????????????????????????????????????sqlserver???????е??Щ???????????????????檔?????????????????????治???????????????????????????
????3.profiler???????????????????
????4.windows???????????????sqlserver???????????????????????????perfmon.msc??????????????????????blog??д??
????5.??????????????????????????????д????????????????й???ip????????????xp_cmdshell????洢????????????????config??
????????????sqlserver??????????????????????????????????????????????????????????sa??????????????????????xp_cmdshell???????????????????????????????????????????????????????????????????????￡????????????????????????????????????????????????????????????????xp_cmdshell?????????????????????
????6.????????????????????????????????????????????????????????????????????????????????????????????db??????????????
????7.?????????????????ù?ssms?????????????????????????????????????????????????????192.168.1.3?????????????ssms??????ip???????192.168.1.4???????????db?????????????????????????????????????????????????????????????????????????????????????????е?????е??????????db???
????8.???db?????????·??????????????·????????????????????????db????data????????д?????????????????????????????????????????????????????￡?????????е?????????漰????????????????tá??????2?????????У????????raid10???raid0??????2?????????????????y?mdf?????ldf????????????io?????mdf????raid10???ldf????raid0?????
????9.???????????????????????С??????????С??????????????????????????????????????????????io???????????????????????????????????????????????????????
????10.????????????г??????????????????????????????????????????????????????????????????????????????????С??????????????????????????????????????????????????????????????
????11.?????????????????????????е?????
????12.??sql??????????SELECT LOGIN_TIME FROM MASTER..SYSPROCESSES WHERE SPID= 1
????13.????ó??????sa???????????????sa???????????????sa???????Σ?????????ɡ?
????14.????????????????????????crtl+1??sp_who??????????????ctrl+2??sp_lock??????е??????alt+x??????f5??????п???????????????????win+r??????????????????ssms?????sqlserver??management studio????б??alt+f1?????????????sp_help???????????????????????alt+n????Щ???????????????????????????????????
????15.???????????????????????????ε????????в??????д???????????η?????????????±??и????????????????????????Ч????????????????????????????????????????????????SQL Server??intellisense?????????????????и??????????????????????????п???ctrl+shift+r??????????
?????????????????????????????????- -????????????????????????????????в?????????????????????λ?????