?????: SQL ????? 2008 R2 ???????? ?????? ?????? ????? ?? ????? ???? ?? ??? ?? ????? ????? ?? ????? ???? ?? ?? ????? ???? SQL Server Profiler ??????? ???? ??

???? ?????? ???? ??????
???? ID: 2458438 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
Microsoft ?? ????? ????? ?? ??? ??? Microsoft SQL Server 2008 R2 ?????? ?????? ???? ??? ???????? ????? ???? ???, ??????? ??? ?????????? ?? ?? ???? ?? ?? ?? ????? SQL Server 2008 R2 ?? ??? ????? ??? ?? ??? ??????? ???????? ?????? ????
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

?????

?? ?? Microsoft SQL Server Profiler SQL ????? 2008 R2 ???????? ??????, ?? ?? ?????????? ???????? ?? ???? ?? ??????? ?? ??????? ???? ?? ??? ????? ?? ???? ???

?????? 1
???? MDX ????????? ????????? ????? ???? ?????? ?????? ???? ???? ??, ?? ?? ???? ???????? ??????, ConnectionID ?? SPID ????????? ?? ????? ??? ??? ??? ??????? 0?? ??? ???? ?????, ???? triggers ????? ??? ???? ???

?????? 2
TextData ????? ??? ???? ????????? ????????? MDX ????????? ??????? ????? ?? ?? ????????? ?? ?? ????? ?? ??? ??? ??? ?? ?????? ???? ???? ?? ???? ???? ?????, ????? ?? ??????? ?? ????????? ??? ?????? ???? ???

?????? 3
??????? ????? ??????? ??? ????? ???? ?????? ?? ???? ?????? ?????? ??? ?? ???????? ??? ??? ????? ???? ???

4 ??????
??? SQL Server Profiler, ?????? ??? ???????? ??????? ??? ?????? ???? ????? ?? ?????? ???:
  • ??????
  • LockTimeOut
SQL Server 2008 R2 ???????? ?????? ?? ???????? ???????? ?? ?????? ???? ?? ?????? ???? ???, ??????? ?? ??????? ?? ????????? ???

?? ?????? SQL Server Profiler ?? ???????? ?? ?? ???? ?? ??? ??? ?? ????? ?????? ??? ????? ??? ??? ???? ??????? ?? ???, "???? ???????" ??? ??????

????????

SQL Server 2008 R2 ?? ??? ?????? ??? ???????

?? ?????? ?? ?? ???? ?? ???, SQL Server 2008 R2 ?? ??? ?????? ?????? ??? ??????? ????? ???? ??????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
2527041 SQL Server 2008 R2 ?? ??? ?????? ?????? ??? ??????? ???? ?? ??? ????
??? ?? ?????? ?? ??? ????? SQL Server 2008 R2 ?????? ??? 1 ??? ???? ?????? ???? ??? ???

???? ???????

??? MDX ????????? ???? ????????? ???? ?????

??????? SQL ????? 2008 R2 ???????? ?????? ????? ????? ????????? MDX ????????? ?????? ?? ??? ?????? ???? ??:
  • MDX ????????? ???? ?? ????????? ????
  • MDX ????????? ??????? ?? ????????? ????
  • MDX ????????? ??? ?? ????????? ????
?? ?? ?????? ?? ??????? ???? ?? ???, ?????????? ?? ?????? ????????? ????????? MDX ???????? ?? ????? ???? ?? ??? ?????? ???:
  • MDX ????????? ???? ???? ?? ????????? ????
  • MDX ????????? ??????? ?????? ?? ????????? ????
?? ????? ????? ???? ?? ?? ???????? MDX ????????? ?? ?? ???? ??? ???? ????????? ?? ??? ?? ??? ?? ??????? ??? ???? MDX ????????? ????????? ???? MDX ????????? ????? ?? TextData ????? ???? ???? ???? MDX ????????? ?? ??????? ???? ????????? MDX ????????? ???? ??????? ????? ?? TextData ????? ???? ????

?????? ????? ?? ????? ???? ?? ??? ?? ????? ???????

??????? ????? ??????? ?? ?????? ????? ???? ?????? ??? ??? ????? ???? ????? ?? ?? ?????? ?? ??????? ???? ?? ???, ?? ?????? ????? ????? ???? CPU ????? ?? i/O ???????? ?? ???? ??? ??????? ????? ???? ?? ??? ???????? ??? ?? ??????? ?? ??? ???? ??? ?? ???????? ????? ???? ????? ????, ?? ??? ??? ?????? ?? ??? ????? ??? ???? ??? ????? ?? TextData ????? ??? ?????????? ??????? ????? ?? ???? ???:
  • ????? ??, <Value></Value>
  • READ_KB, <Value></Value>
  • ????? ??, <Value></Value>
  • WRITE_KB, <Value></Value>
  • CPU_TIME_MS, <Value></Value>
  • ROWS_SCANNED, <Value></Value>
  • ROWS_RETURNED, <Value></Value>

?????? ?????????? ?? ????? ???? ?? ??? ?????

SQL Server 2008 R2 ???????? ?????? ?? ?????? ???? ?? ?? ???? ?? ?????? ?????????? ?? ????? ????? ?? ??????:
  • ??????
  • LockTimeOut
?? ?? ?????? ?? ??????? ???? ?? ???, ?????????? ?? ????? ?????? ?????? ?????????? ?? ????? ???? ?? ??? ?????? ???:
  • ??????? ???????
  • ??????? ?? ???? ???? ???
  • ??? ?????????
??????? ??????? ???? ????? ???? ?? ?? ?? ????????? ?? ??? ?? ??? ?? ????????? ?? ????????? ?? ??? ??????? ?? ??????? ??? ??????? ???? ???? ????????? ????????? ?? ??? ?????? ???? ??????? ?? ?? ??? ?? ??? ?? ???? ?? ????? ???? ??? ?? ???? ?? ???? ?? ??????? ??? ???? ??? ?? ????? ???? ??? ??? ?? ????????? ???? ????? ???? ?? ?? ?? ??? ????????? ?? ????? ???? ?? ?? ?? ??? ?? ??? ??? ??? ??????? ???? ?? ??? ?? ?????? ??? ????????? ???? ??? ?? ??????? ?? ?????? ?? TextData ????? ??? ??? ?? ??????? ?? ?????????? ???????? ??????? ???? ????? ??:
  • ???????????? ID
  • LockList XML ???
  • WaitList XML ???
  • HoldList XML ???
??? ??????? ???? ?? ??? ???? ???? ?? LockList ??????? ??? ??? ?? ????????? ???? LockList, WaitList?? HoldList ??????? ???? ???

LockList

LockList ??? ?????????? ??????? ????? ??:
  • ??? ??????
  • ????? ??????
  • ???????? ?? ?? ??? ?????? ???? ?? ??? ?? ?? ????????
  • ???????? ID
??? ???????? ?? ??? ???? ?????? ?? ???? ??????? ???? ??? ??? ??? ???? ???? ??? ?? ???? ??? ???? ???? ??? ????????? ??? ??? ???? ?? ???? ???? ??? ????? ???? ???

????? LockList ??? ?? ?? ?????? ??:
<LockList>
                <Lock>
                                <Type>Read</Type>
                                <LockStatus>Acquired</LockStatus>
                                <Object><DatabaseID>AdventureWorks</DatabaseID></Object>
                                <ObjectID>asadfb-vfbvadr-ft3323-54235</ObjectID>
                </Lock>
                <Lock>
                                <Type>Read</Type>
                                <LockStatus>Waiting</LockStatus>
                                <Object><DatabaseID>FoodMart</DatabaseID><Object>
                                <ObjectID>asadfb-vfbvadr-ft3323-54235</ObjectID>
                </Lock>
                <Lock>
                                <Type>Read</Type>
                                <LockStatus>Requested</LockStatus>
                                <Object><DatabaseID>FoodMart</DatabaseID><Object>
                                <ObjectID>asadfb-vfbvadr-ft3323-54235</ObjectID>
                </Lock>
</LockList>
?? ?????? ???, ????????? ??? ??????? ??????, ?? ??????? ????, ?? ????? ??? ?? ??? ????????? ???? ???

WaitList

??????? ?????? ?? ahead ??? ??? ????????? ????????? WaitList ??? ???????? ???? ??? ????? WaitList ??? ?? ?? ?????? ??:
<WaitList>
     <Object><DatabaseID>FoodMart</DatabaseID><Object>
     <ObjectID>asadfb-vfbvadr-ft3323-54235</ObjectID>
     <Type>Read</Type>
     <Transaction>  
  <TransactionID>2342-3we-dsdf-sdf<TransactionID>
  <SPID>234</SPID>
  <Type>Write</Type>
     </Transaction>  
     <Transaction>  
  <TransactionID>2ger342-3rtee-dsdf-sdf<TransactionID>
  <SPID>222</SPID>
  <Type>Read</Type>
     </Transaction>  
</WaitList>

HoldList

??????? ?????? ?? ??????? ???? ?? ????? ???? ?? ?? lock ??? ????????? HoldList ??? ???????? ???? ??? ????? HoldList ??? ?? ?? ?????? ??:
<HoldList>
     <Object><DatabaseID>FoodMart</DatabaseID><Object>
     <ObjectID>asadfb-vfbvadr-ft3323-54235</ObjectID>
     <Type>Read</Type>
     <Transaction>  
  <TransactionID>2342-3we-dsdf-sdf<TransactionID>
  <SPID>234</SPID>
  <Type>Write</Type>
     </Transaction>  
     <Transaction>  
  <TransactionID>2ger342-3rtee-dsdf-sdf<TransactionID>
  <SPID>222</SPID>
  <Type>Read</Type>
     </Transaction>  
</HoldList>

??????

Microsoft ?? ?????? ?? ?? ?? ?? "?? ?? ????" ???? ??? ???????? Microsoft ???????? ??? ?? ?????? ???

??????

???? ??????? ?? ??? ????????? ????? ???? SQL ????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
935897?? ????????? ????? ???? ?????????? ??????? ?? ?? ???????? ?? ??? ?????? ???? ?? ??? SQL Server ??? ?? ?????? ???? ??
SQL ????? ???????? ?? ??? ?????? ?????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
822499Microsoft SQL ????? ?????????? ?????? ???????? ?? ??? ??? ?????? ??????
?????????? ?????? ?????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
824684 Microsoft ?????????? ???????? ?? ????? ???? ??? ???????? ???? ???? ???? ?????? ?? ?????

???

???? ID: 2458438 - ????? ???????: 24 ?? 2012 - ??????: 1.1
???? ???? ???? ??:
  • Microsoft SQL Server 2008 R2 Analysis Services
??????: 
kbfix kbqfe kbexpertiseadvanced kbsurveynew kbmt KB2458438 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:2458438

??????????? ???

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com