FIX: ???? ???? ???????? ????? ?????? ???? ???????? ?? ????? ?????? ????? ?? SQL Server 2008 ?? SQL Server 2008 R2

?????? ????????? ?????? ?????????
???? ???????: 2584903 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

???? Microsoft ?????? ??????? ? Microsoft SQL Server 2008 R2 SP1 ???? ??????? ??????? ???????. ??? ???????? ?????????, ?? ????? ???? ????? ??? ???? ????????? ??????? ?????? ???? ??????? ?????? ???????? ???? ?? ????? ??????? SQL Server 2008 R2 SP1 ???????.

???????

????? ?? ????????? ??????:
  • ????? ?????? ????? ????? (?????) ????? ??? ???? snapshots.query_stats ???? ????? ??? ???? ????? ?? ???????? ?? Microsoft SQL Server 2008 ?? ?? Microsoft SQL Server 2008 R2.
  • ????? ????? ?????? "???? ????????" ??????? ???? ???????? ?? ????? ???????? ?????.
    mdw_purge_data_ [<MDW database="" name=""></MDW>]
?? ??? ?????????? ?????? ????? ?????? "???? ????????" ?????? ???? ????????.

??????
  • ???? ???????? ?????? ?????? ??????? core.sp_purge_data ????? ???? ????????.
  • ????? ?? ????????? ??? ??? ??????? ?? SQL Server 2008 R2? ?? ?????? ???? Microsoft ?????? ??? ???:
    ??????? ???? ??? ??? ??????? ?? SQL Server 2008 R2

?????

???? ??? ??????? ??? ??? ?????? mdw_purge_data ????? ?????? ?????? ????? ????? ?????? ???? ??? ??? ?????? snapshots.query_stats ????? ??? ???? ????? ?? ????????.

????

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

SQL Server 2008

??? ??? ??????? ?? SQL Server 2008? ???? ??? ???????:
  1. ?????? ??? ???? ???? ???? ? SQL Server 2008.

    ?????? ??? ???? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
    968382 ????? ?????? ??? ???? ???? ???? ? SQL Server 2008
  2. ?????? ????? ?????? ??????? ??? ???? ????? ?? ???? ????? "????? ????? ?????? ???????? ????????" ??? ?? ??? ?????? ???? ???? ???? ? SQL Server 2008.


SQL Server 2008 R2

??? ??? ??????? ?? SQL Server 2008 R2? ???? ??? ???????:
  1. ?????? ??? ???? ???? ???? ? SQL Server 2008 R2.

    ?????? ??? ???? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
    2527041 ????? ?????? ??? ???? ???? ???? ? SQL Server 2008 R2
  2. ?????? ????? ?????? ??????? ??? ????? ?? ???? ????? "????? ????? ?????? ???????? ????????" ??? ?? ??? ?????? ???? ???? ???? ? SQL Server 2008 R2
  3. ????? sp_purge_orphaned_notable_query_text ??????? ?????? ??? ???:

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

    -- Deleting TOP N orphaned rows in query plan table by joining info from temp table variable
    -- This is done to speed up delete query. 
    DELETE TOP (@delete_batch_size) snapshots.notable_query_plan 
    FROM snapshots.notable_query_plan AS qp , #tmp_notable_query_plan AS tmp
    WHERE tmp.[sql_handle] = qp.[sql_handle]
    ????? ?????

    -- Deleting TOP N orphaned rows in query text table by joining info from temp table
    -- This is done to speed up delete query. 
    DELETE TOP (@delete_batch_size) snapshots.notable_query_text 
    FROM snapshots.notable_query_text AS qt, #tmp_notable_query_text AS tmp
    WHERE tmp.[sql_handle] = qt.[sql_handle]
    ?????? ??? ????????? ?????? ?????? ?? ??????? sp_purge_orphaned_notable_query_text ????? ??? ????? delete ????? ?????? snapshots.notable_query_plan ???? ??? ???? ??? ????? SQL Server 2008 R2 ?????? service Pack 1.

?????

?? ????? Microsoft ?? ??? ?? ???? ????? ?? ?????? Microsoft ??????? ?? ??? "????? ???".

??????? ????

???? ???? ?????? ??? ???? ???????? ????? ?????? ??????? ???? ????? ???????? ?? ??????? ???????:
http://blogs.msdn.com/b/sqlagent/archive/2011/04/12/data-collector-s-sp-purge-data-may-run-for-hours-if-there-are-many-orphaned-plans-to-purge.aspx


???????

???? ???????: 2584903 - ????? ??? ??????: 15/???/1433 - ??????: 5.0
????? ???
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Standard
????? ??????: 
kbqfe kbexpertiseadvanced kbsurveynew kbfix kbmt KB2584903 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????2584903

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

 

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