FIX: The sys.syscommittab system table is not cleaned up after the retention period for change tracking in SQL Server 2008

???? ?????? ???? ??????
???? ID: 2446860 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
Microsoft ?? downloadable ???? ?? ??? ??? Microsoft SQL Server 2008 ??????? ?????? ???? ??? ??????? ????? ???? ???, ??????? ?? ?? ?????? ??? ??? ?????????? ?? ?? ??? ??????? ??????? ????? SQL Server 2008 ?? ??? ????? ?? ?? ??? ???? ???
??? ?? ??????? ???? | ??? ?? ??????? ????

?????

?? ???????? ?? ????? ????.:
  • You enable theChange Tracking, ??Auto Cleanupproperties for a database in Microsoft SQL Server 2008.

    ???:TheAuto Cleanupproperty automatically cleans up the data for change tracking.
  • You set theRetention Period, ??Retention Period Unitsproperties.
In this scenario, thesys.syscommittabsystem table for change tracking is not cleaned up after the specified retention period.

???
  • ?????? ???? ????????? ?? ???????? ???????? ????, ???? ?? ??? ????? ?????? ?????? ??? ??? ????????? ?????? ???? ?? ?????? ??, ?? ?? ?????? ??????? ??? ???
    Use <Database Name>
    select top 10 * from sys.dm_tran_commit_table order by commit_time
  • ????? ????? ?? ??? ????? ??? ???? ?? ???sys.syscommittab?????? ????, ?????????? ?? ??????? ??????? (DAC) ?? ????? ?? ????? ?? ?????? ????, ?? ???? ??? ????? ?????? ?????:
    sp_spaceused 'sys.syscommittab'

????????

SQL Server 2008 ?????? ??? 1

?? ?????? ?? ????? ???? ?????? ???? ??? ?? ????? ?????? 11 ??? SQL Server 2008 ?????? ??? 1 ?? ????

?? ????? ?????? ?????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
2413738SQL Server 2008 ?????? ??? 1 ?? ??? ????? ?????? ?????? 11
???:Builds ????? ???? ???, ??????? ?? ?? ????? ?????? ??? ??? ?????????? ?? ?? ??? ??????? ??????? ????? SQL Server 2008 ?? ??? ????? ?? ?? ??? ???? ??? Microsoft ??????? ???? ?? ?? ?? ????? ?????? ????? ?????? ?????? ?? ???????? ?? ???? ???? ?? ??? ??? ???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
970365SQL Server 2008 SQL Server 2008 ?????? ??? 1 ?? ?????? ???? ??? ?? ?? ??? ?????? ??? ?? ?? ????? ??
Microsoft SQL Server 2008 ?????????? ??????? SQL Server ?????? ??? ?? ??? ???? ???? ???? ?? SQL Server 2008 ?????? ??? 1 ?? ??????? ???? ?? ??? ??? SQL Server 2008 ?????? ??? 1 ???????? ?? ???? ???? ?????? ??? ???????? ??? ??, ???? ?? ???????? ???? SQL Server ?????? ??? ??? ?????? ???? ???? ?? ?? ???? SQL Server ?????? ??? ??? ????? ???

SQL Server 2008 ?????? ??? 2

?? ?????? ?? ????? ???? ?????? ???? ??? ?? ????? ?????? 2 ??? SQL Server 2008 ?????? ??? 2 ?? ???? ?? ????? ?????? ?????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
2467239SQL Server 2008 ?????? ??? 2 ?? ??? ????? ?????? ?????? 2
???:Builds ????? ???? ???, ??????? ?? ?? ????? ?????? ??? ??? ?????????? ?? ?? ??? ??????? ??????? ????? SQL Server 2008 ?? ??? ????? ?? ?? ??? ???? ??? Microsoft ??????? ???? ?? ?? ?? ????? ?????? ????? ?????? ?????? ?? ???????? ?? ???? ???? ?? ??? ??? ???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
2402659SQL Server 2008 SQL Server 2008 ?????? ??? 2 ?? ?????? ???? ??? ?? ?? ??? ?????? ??? ?? ?? ????? ??
Microsoft SQL Server 2008 ?????????? ?? ??????? SQL Server ?????? ??? ?? ??? ???? ?? ???? ?? SQL Server 2008 ?????? ??? 2 ?? ??????? ???? ?? ??? ??? SQL Server 2008 ?????? ??? 2 ???????? ?? ???? ???? ?????? ??? ???????? ??? ??, ???? ?? ???????? ???? SQL Server ?????? ??? ??? ?????? ???? ???? ?? ?? ???? SQL Server ?????? ??? ??? ????? ???

??????

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

??????

???????? ???????? ?? ???? ??? ???? ??????? ?? ??? ????? Microsoft ?????? ??????? (MSDN) ??? ?????? ?? ????:
???? ??????? ?? ??? ????????? Servicing ???? SQL ????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
935897?? ????????? Servicing ???? ?? SQL Server ??? ?? ??????? ?? ?? ???????? ?? ??? ?? ???????? ?? ?????? ???? ?? ??? ?????? ??
SQL ????? ?????? ?? ??? ?????? ?????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
822499Microsoft SQL Server ?????????? ?????? ???????? ?? ??? ??? ?????? ??????
?????????? ?????? ???????? ?? ???? ??? ???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
824684Microsoft ?????????? ???????? ?? ????? ???? ?? ??? ????? ?? ???? ???? ???? ???????? ?? ?????

???

???? ID: 2446860 - ????? ???????: 17 ????? 2011 - ??????: 2.0
???? ???? ???? ??:
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Service Pack 1
??????: 
kbautohotfix kbqfe kbhotfixserver kbfix kbmt KB2446860 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:2446860

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

 

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