FIX: SQL Server 2008 R2 Analysis Services ???? ????? ???? ??????? ????? ??????? ??????? ?????? ???????? Profiler ???? SQL

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

?? ??? ??????

???????

?? ???? ??? ??????? Microsoft SQL Server Profiler ???? ???? SQL Server 2008 R2 Analysis Services? ???? ?? ???? ?? ?????? ???????.

????? 1
????? ??? ????? ??? ???? ????? ???????? ????? MDX ?????? ???? ??? ??? Analysis Services? ??????????? ????? SPID ???? ???? ??? ???? ? 0. ?????? ?? ??? ????? ???? ????? ???? ???? ?????? ?????.

????? 2
????? ??????? ?? ???????? ????? MDX ????? ???? ??? ?????? ???? ??? ???? ??? ??????? ??????? ?? ?????? ??? ????? ??? ???????? ????? ??? ?? ?????? ????????? . ?????? ?? ???? ????? ???????? ????? ???? ????? ???? ?????.

????? 3
??????? ?????? ?????? ?? ???? ??? ??????? ???? ??? ????????? ?????? ??? ???? ?? ?????? ???????.

????? 4
?? SQL Server ???? ????? ???????? ????? ????? ???? ????? ??? ??????? ??? ????? ????? ????? ??????? ??????? ????? ???:
  • ???? ???? ???
  • ?????????
??? ???? ??? ????????? ??? ????? ??? ?????? ??????? ????? ???????? ???? ????? ????? SQL Server 2008 R2.

??? ??????? ???? ??? ??????? ??????? ???? Profiler ???? SQL ??? ??? ???????. ?????? ??? ???? ?? ?????????? ???? ?????? "???? ?? ?????????".

????

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

??? ??? ???????? ??? ?????? ??? ???? ???? ???? ? SQL Server 2008 R2. ?????? ??? ???? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2527041 ????? ?????? ??? ???? ???? ???? ? SQL Server 2008 R2
?????? ????? ??? ??????? ???? ???? ??? ?? SQL Server 2008 R2 Service Pack 1.

??????? ????

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

????? ??????? SQL Server 2008 R2 Analysis Services ??????? ??????? ?????? ???????? ????? MDX ????? :
  • ????? ???????? ????? MDX ?????
  • ????? ???????? ????? MDX ???????
  • ????? ???????? ????? MDX ?????
??? ????? ??? ???????? ??????? ????? ??????? ??? ?????? ??????? ????? ???????? ????? MDX ????? :
  • ????? ???????? ????? MDX ????? ???
  • ????? ???????? ????? MDX ????? ?????
???? ??? ??????? ??? ?? ??? ?? ???????? ????? ??? ????? ??? ??????? ??????? ???????? ????? MDX. ?????? ????????? ?? ????? ????? ??? ???????? ????? MDX ????? ??? ???????? ????? MDX ??????. ?????? ????????? ?? ????? ????? MDX ???????? ????? ???? ????? ????? ??? ???????? ????? MDX ????? ??????.

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

??????? ?????? ?????? ?? ???? ??? ??????? ???? ??? ????????? ?????? ??? ????. ??? ????? ??? ???????? ??? ??? ??? ????? ??????? ??????? ??????? ?????? ??????? ??? ??????? CPU ??????? ???????/???????. ??? ????? ??? ????????? ?? ??? ????? ?? ?? ????? ?????? ??? ??? ????? ?? ????? ????? ?? ??? ??? ????? ????? ????????? . ???? ????? ????????? ??????? ?? ?????? ????????? ?? ?????:
  • ??? ?? ???: <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 ??????? ????? ??????? ???? ???? ?? ????? ???????:
  • ???? ???? ???
  • ?????????
??? ????? ??? ???????? ????? ??????? ???? ??????? ??????? ????? ?? ????? ???????:
  • ????? ?????? ???
  • ????? ????? ????
  • ?????? ?????
???? ????? ?????? ??? ????? ????? ???? ?????? ???? ????? ?????? ?????????. ????? ??????? ?? ????? ???? ??? ????? ????? ?? ?????? ???? ????? ???? ??? ????????. ??? ???? ??? ????? ??? ????? ???? ???? ?? ???????. ???? ????? ?? ?????? ????? ????? ????? ???? ?????? ?? ????? ?????? ?????? ??? ????? ?? ????. ??? ????????? ?? ?????? ????????? ?? ??? ???????. ????? ??? ????????? ?????? ??? ??? ?????? ???????:
  • ???? ?????????
  • ???? XML ???????
  • ???? XML ????????
  • ???? XML ????????
????? ?????? ??? ????? ? ????? ??????? ?? ????? ????? ??? ??????? ??????? . ????? ??? ????? ?? ?????? ????? ????????? ????????? ???????? ???????? .

???????

?????? ??????? ????? ??? ????????? ???????:
  • ??? ???????
  • ???? ?????
  • ???? ?????? ?????? ???? ???? ???? ???
  • ???? ??????
?????? ????? ??? ????? ??? ???? ??????. ???????? ??? ??? ????? ????? ????? ??????? ??? ????????? ????? . ????? Duration ???? ??? ????? ???? ??? ??? ??????? ??????? ?????.

???? ??? ???? ?????? ??????? :
<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>
     <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>
     <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 Server? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
935897????? "????? ????? ??????? ????????" ?? ???? SQL Server ?????? ??????? ????? ?????? ?? ??????? ????
????? ?? ????????? ??? ???? ????? ????????? SQL Server? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
822499???? ????? ???? ???? ??????? ????? Microsoft SQL Server
????? ?? ????????? ??? ??????? ????? ???????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
824684 ????? ????????? ???????? ????????? ?? ??? ??????? ????? Microsoft

???????

???? ???????: 2458438 - ????? ??? ??????: 03/???/1433 - ??????: 1.1
????? ???
  • Microsoft SQL Server 2008 R2 Analysis Services
????? ??????: 
kbfix kbqfe kbexpertiseadvanced kbsurveynew kbmt KB2458438 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????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