??????????? ????? ???? ?????? ????? ????? ????? ??? ????? ??????? ?????? TokenAndPermUserStore ?? SQL Server 2005

?????? ????????? ?????? ?????????
???? ???????: 927396 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???: 429501 (SQLBUDT)
????? ???? | ?? ????

?? ??? ??????

???????

?? Microsoft SQL Server 2005 ?? ????? ??????? ???????:
  • ??????????? ???? ???? ???? ???? ???? ???? ????? ???? ?????? ??? ???????.
  • ??????? ???? ???????? ???????? ?????? SQL Server ???? ?? ???????.
  • ??? ???? ?????? ?? ?????? ??? ????? ??????? ad hoc ??? ????????? ?? ????? ??? ????? ???? sys.dm_exec_requests ?? sys.dm_os_waiting_tasks. ??? ???? ?? ???? ????????? ?????? ?? ????.
  • ????? ??? ?????? ?????? TokenAndPermUserStore ????? ????.
  • ??? ?????? ?????? TokenAndPermUserStore ?????? ??? hundred ???????? (MB).
  • ?? ??? ???????? ???? ????? ????? FREEPROCCACHE DBCC ????? ???????.
??????? ??? ????? ??????? ?????? TokenAndPermUserStore ????? ??????? ??????? ??????? ??? ???:
SELECT SUM(single_pages_kb + multi_pages_kb) AS 
   "CurrentSizeOfTokenCache(kb)" 
   FROM sys.dm_os_memory_clerks 
   WHERE name = 'TokenAndPermUserStore'

?????

????? ?????? ?????? TokenAndPermUserStore ?????? folllowing ????? ????? ??????:
  • LoginToken
  • TokenPerm
  • UserToken
  • SecContextToken
  • TokenAccessResult.
???? ?????? ?? ??????? TokenAccessResult ?????? ?????. ???? ??? ??????? ???? ???? ?????? ?? ????????? TokenAccessResult ???? ????? ??? ?? 65535.

??? ???? SQL Server ???? ????? ??? ???? ????? ?? ????? ????????? ?????? ?????? ???? ?????? ?? ????????? TokenAccessResult ???? ????? ??? ?? 65535 ?? ????? ????? sys.dm_os_memory_cache_entries. ???? TokenAccessResult ????????? ???? ??? ??? ??? ?? 65535 ??????? ????. ??? ??????? ??????? ????? ??????? ?????? ??? ????????? ??? ???????? ???????????. ??? ???? ??????? ?? ???? ?????? ????????? ??????:
select * 
from t1 join t2 join t3
?? ??? ??????? ???? SQL Server ???? ?????? ??? ?????? ???? ?????????. ???? ??? ???????? ?? ??? ??? ?????? ??? ??? t1, t2, t3 ?? ??. ??? ??????? ???????? ??? ???????? ???? ??? ????? TokenAccessResult ?? ?????? ?? ?????? ?????? TokenAndPermUserStore ???? ??? 65535. ?? ??? ???? ???????? reuses ?? ????? ??? ????????? ??? ???? SQL Server reuses ????? ????? ??????? ?????? TokenAccessResult ??? ?????.

??? ????? ??? ???? ????? ??????? ?????? ??? ??? ????? ??? ????? ?? ??????? ?????? ?????????. ??? ?????? ?? ?????? ??? ????? ??????? ?????? ??? ???? ???? ????? ???? ???? ??? ?????. ??? ?????? ?????? ??????? ????????? ??? ????? ???? ????? ?? ??????? ???? ???????? ???????? ".

????

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

??? ??? ???????? ??? ?????? ??? ???? ???? ???? ?? SQL Server 2005. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
913089????? ?????? ??? ???? ???? ???? ?? SQL Server 2005
??? ??? ??????? ??? ????? ???? ??????? ?????? ?????? ??????? ??? SQL Server 2005 ?????? ????? ?????? SP2. ???? ???????? ????? ????? ??????? ?????? ?????? TokenAccessResult ?????????? ad hoc ?????? ??? ??? ????? ??????? ad hoc ???? ??? ????.

???? ??????

?????? ??? ??? ???????? ?????? ???? ?? ???? ?? ????? ???????:
  • ???? ???? parameterize ??????????? ????????.

    ?????????
    • ???? ??? ??????? ?? ?????? ????? ??????? ????????? ad hoc ?????? ?????? ???.
    • ??? ??????? ??? ??????? ??? ???? ?????? ????? TokenAccessResult ?? ?? ??? ??? ???? ????? ??????? ad hoc ?? ?????? ??????.
    • ???????? ??? ???????? ??? TokenAndPermUserStore ???? ????? ??????? ?????? ??? ???? ??????.
  • ?????? ????????? ad hoc ??? ????????? ??????? ?? ?????? ????????? ??????? ????? ?? ????? ????????? ??????? ??????.

    ?????????
    • ?? ??????? ?????? ??? ??????? ???????? ?? ??????? ??????.
    • ??? ????? TokenAccessResult ?? ???? ?? ????? ??? ???????.
    • ????? ?? ??? ????? ??? ????? ??? ??????? ???? ?? ????? ??????? ??????, ?? ????? ??????? ?????? reuses ??????? TokenAccessResult ???? ????. ?????? ?? ???? ????? TokenAccessResult ??????? ???????.
  • ????? ???? FORCE_PARAMETERIZATION ????? ????????.

    ?????????
    • ???? ??? ??????? ?? ?????? ????? ??????? ????????? ad hoc ?????? ?????? ???.
    • ??? ??????? ??? ??????? ??? ???? ?????? ????? TokenAccessResult ?? ?? ??? ??? ???? ????? ??????? ad hoc ?? ?????? ??????.
    • ???????? ??? ???????? ??? TokenAndPermUserStore ???? ????? ??????? ?????? ??? ???? ??????.
  • ????? ????? ?????? ???? ???? ?????? ????? ????????? ad hoc ???? ?? ?????? ????? ????? ??????.

    ?????????
    • ??? ??? ????? ??????? TokenAccessResult ??????? ????? ??? ????? ????????? ??? ????? ???? ??? ??? ?? ?????? ????? ????? ??????.
    • ???? ?? ??? ????? ??????? TokenAccessResult ????? ??? ?????? ??? ????? ??????? ?????? TokenAndPermUserStore ??? ??? ???? ???????.
  • ??? ??????? ?? ????? ??????? ?????? TokenAndPermUserStore.

    ?????????
    • ?????? ????? ?? ?????? ????? ??????:
      FREESYSTEMCACHE DBCC ('TokenAndPermUserStore')
    • ????? ?????? ?????? ?????? ?? ??? ????? ??????? ?????? TokenAndPermUserStore ??? ??? ????? ????? ????.
    • ????? ????? ???? ?????? ?? SQL Server ???? ?????? ????????? ???????:
      • ???? ?? ??? ??? ????? ??????? ?????? TokenAndPermUserStore. ?????? ????? ?? ?????? ????? ??????:
        SELECT SUM(single_pages_kb + multi_pages_kb) AS 
           "CurrentSizeOfTokenCache(kb)" 
           FROM sys.dm_os_memory_clerks 
           WHERE name = 'TokenAndPermUserStore'
      • ??? ???? ???? ?? ???? ???? ??? ???????? ??? ????? ??????? ??????, ?? ?????? ????? ??????:
        DBCC FREESYSTEMCACHE ('TokenAndPermUserStore')

?????

????? ?? ?????????? ???? ??? ????? ???????? ??????? ?????? ?? "????? ??????? ?? Microsoft:
933564FIX: ???? ????? ??????? ?? ??????? ??????? ????? ????? ??????? ?????? USERSTORE_TOKENPERM ?? SQL Server 2005
959823????? ????? ????? ??????? ????? ????? ????? ??????? ?????? TokenAndPermUserStore ?? SQL Server 2005 ?????? ????? ?????? Service Pack 3

???????

???? ???????: 927396 - ????? ??? ??????: 06/?????/1430 - ??????: 4.0
????? ???
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
????? ??????: 
kbmt kbtshoot kbinfo kbsql2005tsql kbprb KB927396 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????927396

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

 

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