????? ???? ?? ????? ????? ??????? ???? ?????? ?????? ?? ??????? 64 ?? ?? SQL Server

?????? ????????? ?????? ?????????
???? ???????: 918483 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? Microsoft SQL Server ???????? ??? ??????? ??????? ??????? ?????? ???????? ??? ?????? ????? ??????? ???????????. ??? Windows Server 2003 ?? Windows XP ?? ???? ????? ????? ??????? SQL Server ????? ??????? ??????? ???? ??? ??????? ?? ??? "????? ????? ??????? Windows ????????????????????????????". ??? ???? ????? ??? ???? ??????? Microsoft Windows 2000 Server? SQL Server ???? ???? ???? ??????? ??????? ???????? ??? ?????? ???????? ????? ????? ??????? Windows ???????. ???????? ??? ??? ????????? ?? ???????????????????????????? Windows API ?? ?? ???? ????? SQL Server ?????? ?????? ??????? ?? ??????? ??? ???? ????. ???? ??? ??????? ???????:
  • ???? ?????? ?? ???? ?????? ????? ?????? ?????? SQL Server.
  • ????? ????? ????? ???????? ???????? ?? ??????? ??? ????? ???????? ???????/??????? ??????.
????? ?? ?????????? ???? ??????? "????? ??????? ???????????" ?????? "?????? ????? ??????" ?? "??? SQL Server ??? ??????".

???????

?? ??????? 64 ?? ?? SQL Server? ?? ???? ?????? ?????. ??? ???? ??????? ?? ???? ??????? ???????:
  • ?????? ????? ???? ???? SQL ????.
  • ???? ??????? ?????? SQL Server ?? ????????? ????? ?????.
  • ?????? ???????? ??????? ? SQL Server.
  • ???? ?????? ??? ????? ??????? ????? ?? ??????? ????????? ??? ??????.
??? ??? ?????? SQL Server 2005 Service Pack 2 (SP2) ?? ????? ????? ??? ????? ???? ????? ????? ??????? ?? ??? ????? SQL Server ??? ???? ??? ???????:
????? ????? 1
????? ???? ??? ?? ????? spid1s A ??? ???? ?? ????? ??????? ???? sql. ?? ???? ??? ??? ?????? ????? ????. ?????: 0 ?????. ?????? ????? (KB): 1086400? ?????? (KB): 2160928? ??????? ???????: 50%.
????? ????? 2
????? ???? ??? ?? ????? spid1s A ??? ???? ?? ????? ??????? ???? sql. ?? ???? ??? ??? ?????? ????? ????. ?????: 315 ?????. ?????? ????? (KB): 410156? ?????? (KB): 2201296? ??????? ???????: 18 ?? ??????.
????? ????? 3
????? ???? ??? ?? ????? spid1s A ??? ???? ?? ????? ??????? ???? sql. ?? ???? ??? ??? ?????? ????? ????. ?????: 646 ?????. ?????? ????? (KB): 901904? ?????? (KB): 2215752? ??????? ???????: 40%.

??? ???? ???? ??? Microsoft SQL Server ????? ??? ?????? ?? ????????? ???? ?? ??????? ?? ??? ????? SQL Server ?? ?? ????? ????? Windows. ??? ??????? ??? ????? ??????:
2009-05-05 15:43:56.01 Server      Resource Monitor (0x13c43) Worker 0x0412C1E8 appears to be non-yielding on Node 0. Memory freed: 34152 KB. Approx CPU Used: kernel 171 ms, user 140 ms, Interval: 125093.

2009-05-05 12:54:52.18 Server      * *******************************************************************************
2009-05-05 12:54:52.18 Server      * BEGIN STACK DUMP:
2009-05-05 12:54:52.18 Server      *   05/05/08 12:54:52 spid 0
2009-05-05 12:54:52.18 Server      * Non-yielding Resource Monitor
2009-05-05 12:54:52.18 Server      * *******************************************************************************

2009-06-10 09:13:53.44 Server      * *******************************************************************************
2009-06-10 09:13:53.44 Server      * BEGIN STACK DUMP:
2009-06-10 09:13:53.44 Server      *   06/10/09 09:13:53 spid 0
2009-06-10 09:13:53.44 Server      * Non-yielding IOCP Listener
2009-06-10 09:13:53.44 Server      * *******************************************************************************

2009-06-10 09:13:55.85 spid2s      LazyWriter: warning, no free buffers found.

2009-07-15 13:27:45.35 spid4s      AppDomain xx (SQLCLR.dbo[runtime].xx) is marked for unload due to memory pressure.
2009-07-15 13:27:45.35 spid4s      AppDomain xx (SQLCLR.dbo[runtime].xx) unloaded.

2009-07-15 13:37:51.42 Logon       Error: 17189, Severity: 16, State: 1.
2009-07-15 13:37:51.42 Logon       SQL Server failed with error code 0xc0000000 to spawn a thread to process a new login or connection. Check the SQL Server error log and the Windows event logs for information about possible related problems. [CLIENT: xx.xxx.xx.xx]

Event Type:	Error
Event Source:	SQLBrowser
Event ID:	8
Description: The SQLBrowser service was unable to process a client request. 
?? ???? ????? ??? ?????? ?? ??????? ??? ?? ????? "??? ???? ?? ????? ??????? ?????? sql ??? ?? ?????" ?????. ??? ??? ?????? ????? ??? ?????? ?? ??????? ??? ?? ???? ???? ??? ??? ?? ????? ?????.

??? ????? ???? ????? ????? ?? ??????? ???? ?? ???? ???????? SQL Server ???? ?????? ????? ?????? ?? ??? ??????? ???? ??????? ???????? ???? ??? ????? ??????. ?? ??? ????? ????? ??? ?????? ?? ??????? ??? ???? ????? ?????? ?? ????? ????.

?????

???? ??? ??????? ??? ????? ???? ??????? Windows ???? ?????? ????? ?????? ?????? SQL Server.

??? ????? ????? ????? ??? ????? ??? ?????? ????? ?????? ?????? SQL Server ??? 50 ?? ?????? ?? ??? ?? ??????? ???? ????? ?????? SQL Server. ????? ??????? ????? ????? ??? ?????? ?????? ???? SQL Server ????? ?????? ??? ?? ???? ??? ????? ???? ??????? Windows ???? ?????? ????? ?????? ?????? SQL Server. ???????? ??? ???? ??? ????? ????? ????? ??? ?? ??? ????? ???? ??? 30 ?????. ??? ??? 30 ?????? ????? ????? ????? ????? ??? ??? ?????? ???? ???? ?????? ???? ????.

??? ???? ??? ???????? ?? ????? ?? ?????? ??? ?? ??????? ???? ??? ?????? ?? ???? ????? ?? ??? ????? ??????.
????? ?? ?????????? ?? ?????? ???? Microsoft ?????? ??? ?????:
http://blogs.msdn.com/psssql/archive/2007/05/31/the-sql-server-working-set-message.aspx
???????? ??? ???? ???? ????? ?????? ?? SQL Server ???? ?? ???? ???? ????? ????? ???. ??? ????? ????? ????? ?? ??? ????? SQL Server ????? ????? ??? ????? ???? SQL. ?? ???? ????? ????? ??? ?????. ?????? ?? ?? ???? ??? ?? ?????? ????? ????? ??? ??????. ????? ?? ?????????? ?? ?????? ???? Microsoft ?????? ??? ?????:
http://blogs.msdn.com/psssql/archive/2009/05/12/sql-server-reports-working-set-trim-warning-message-during-early-startup-phase.aspx

???? ??????

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

??? ?????? ??? ???????? ????? ??? ???? ??????? Windows ?? ????? ????? ??????? ???? ?????? ?????? ?????? SQL Server ?????? ??????? ??????? ????? ?????? ?????? ?? ??????? ???????. ????? ??????? ?? ???? ????? ?? ???????? ????? ??????? ?? ??????? ????? ???????? ???? ??? ???????? ????? ??? ??????? ????? SQL Server.

?????? ??????? ????????? 64 ?? ?? SQL Server? ??? SQL Server Enterprise Edition ??????? ???????? ????? ??????? ?? ??????? ??????. ???? ????? ? SQL Server 2005 [RTM SP1? SP2? SP3] ?? SQL Server 2008 [RTM ????? ?????? SP1]. SQL Server 2008 SP1 ???????? ????? 2 ? SQL Server 2005 SP3 ??????? ???????? 4 ????? ??? ??????? SQL Server ???????? ???????? ???????? ????? ??????? ?? ??????? ??????. ????? ?? ????????? ??? ??? ??????? ??????? ??? ????? 64 ??? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
970070 ????? "????? ???????" ??? ????? SQL Server 2005 ???????? ????? 64-?? ?????? SQL Server 2008 ???????? ??????? 64 ??
?????? ?? ???????? ????? ??????? ?? ??????? ? ???? ??? ???????:
  1. ???? ??? ????? ?? ???? ??? ?????? ??? gpedit.msc? ?? ???? ??? ?????.

    ?????? ???? ???? ?????? "??? ???????? ".
  2. ?? ?????? ???????????????????? ?? ?? ?????? ??????? Windows.
  3. ?? ?????? ??????? ??????? ?? ?? ??????????? ???????.
  4. ???? ??? ????? ???? ??????????? ?? ???? ????? ??????? ??? ????? ??????? ?????????.
  5. ?? ???? ?????? ??????? ??? ?????? ??????? ???? ??? ????? ?????? ?? ??????.
  6. ?? ???? ?????? ??? ???????? ?? ??????? ? ????? ???? ???? ????? ?????? ????? Sqlservr.exe? ??? ?? ???? ????????.
  7. ?? ?????? ???? ?????? " ??? ???????? ".
  8. ?? ?????? ????? ???? SQL Server.
??? ????? ?? ???????? ????? ??????? ?? ??????? ?????? ????? ???? SQL Server? ????? ??????? Windows ?? ??? ????? ???? ????? ???? ?????? ?????? ?? SQL Server ?????. ??? ???? ?? ???? ???? ??????? ?????? ???? ????? ???? nonbuffer ??? ????? SQL Server.

????? ?????? ?? ??????? ?? ???????? ????? SQL Server ??????? ?? ????? ??????? ??????? ?? ??? ????? SQL Server ??? ??? ???????:
??????? ??????? ??????? ???? ?????? ??????
??? ??????? ????? ??? ??? ??????? 64 ?? ?? SQL Server.For ???? ?? ????????? ??? ??? ??????? ?? ERRORLOG? ?? ?????? ???? Microsoft ?????? ??? ?????:
http://blogs.msdn.com/psssql/archive/2007/10/18/do-i-have-to-assign-the-lock-privilege-for-local-system.aspx
??? ???? ??????? ???? ??????? Windows ????? ???? nonbuffer? ?? ?? ???? ????? ?????? ?? ??????. ??? ???? ?? ???? ????? ????? ???????? ?? ??? "???????" ?? ??? ????? SQL Server. ???? ??? ?????? ??? ?????? ????? ?????? ?????? SQL Server ???? ?? ??? ??? 50 ?? ?????? ?? ??? ?? ??????? ?????????.

??????? ????

????? ??????? ????? ??? ??????? ????????.

??? ??? ???????? ???? ??????? ???????:
  1. ??? ???????? ???????? ???? ????? ?? ???? ??????? Windows ??? ???? ???? ?????? ??? ?? ????? SQL Server? ????? ????????? ??????? ??????? ?? ?????? "????? ????? Microsoft" ???????.

    ?????? ????????? ??????? ???????. ????? ????? ???? ?? ????? ???? ??? ????????? ??????? ?? ??? ??????? ??????.
    • ??? Microsoft ????? ?? ???? ??????? 64 ?? ?? SQL Server ?????? ??? ??????? ?????. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ????? Microsoft":
      905865 ?? ??? ???????? ????? ??????? ????? ???? ???????? ?? ???? ??? ???? ???? ??? ??????? "????? ?????? ???????" ?????? ?????? ??? ?? ????? ?????? ?? ???? ??????? ???? ???? ?????? Windows Server 2003
    • ???? ?? ???? ????? ????????? ???? ???? Windows Server 2003 ??????? ???? ??? ????? ??????? ??????? ???? ??? ??? ???? ????? ????? ???????/??????? ??????? ??? ????? ??? ???. ???? ??? ?????? ?????? ????? ?? SQL Server ???? ????????. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ????? Microsoft":
      920739 ?? ????? ?????? ?? ?????? ????? ?????? ????? ???? ???? ??????? ???? ???? ????? ?? 500 ???? ???? ?????? ?? Windows Server 2003 S ?? ?? Windows Server 2003 S
    • ?? ??? ???????? SQL Server ?????? ????? ??? ??????? ??? ??????? TCP ???????? ?? ??????. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ????? Microsoft":
      942861 ???? ????? ??? ??? ????? ???? ????? SQL ??? ???? ???? ?????? Windows Server 2003: "??? ???? ??????? ??????"? "??? ??? ???????" ?? "??? ?? ????? ?????"
    • ??? ???? ??????? ????? ????????? ???? ???? ?????? Windows Server 2003? ?? ?????? ????? ?????? ???? ????? ?????? ????????. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ????? Microsoft":
      942486 ?? ?????? ????? ?????? ???? ????? ?????? ???????? ??? ???? ??????? ????? ????????? ???? ???? ?????? Windows Server 2003
  2. ??? ??? ?????? ????? ???? ?????? ???????????????????????? ????? ??? ???? ????? ?????? ???????????????????? ??????? ??? ??? ?? 4 ???????? (GB)? ?? ???? ???? ??????? ???? ?????? ????? ?????? ?????? SQL Server 64 ??. ??? ??? ???????? ???? ????? ?????? ????? ?????? ??????? ?????? ???????. ?????? ??? ????? ?? ????? ??????? ???? ????? ?????? ???? ?????? "???????? ???????" ?? ????? "????? ????? Microsoft" ???????:
    2121098 ??????? "???? ???????" ?????? ??????? ?????? SQL Server ?????? ???
  3. ???? ????????? ?? ?????? ??? ??????? ??? ????? ??? ????????? ???????? ????? ????? ???? Windows ???? ??? ?? ??? ?????? ????? ??? ?????. ????? ?? ?????????? ???? ??? ????? ???????? ??????? ???? ???????? ?? ????? ????? Microsoft:
    938486 ???? ??????? ????? ??? Windows Server 2003 ?? ????????? ???? ????? ?????? ???? ????? ???? ???? ????? ??? ????? ????? ?????? ?? ???????
    956341 ???? ??????? ????? ??? Windows Server 2003 ?? ????????? ???? ??? ????? ????? ???????
    ????? ????? ?????? ????? ???? ?? ????? ???????? ?? ???? ???? ??????? ???? ?????? ??? ?? ??????? ????. ??? ??????? ?????? Windows ???? ?? ??????? "???? ???????" ????? ?? ?????? ????? ?????? ???? ???? ???????. ????? ?? ????????? ??? ?????? ??????? ?????? ???? ???? ?????? ?????? ??????? ?????? ???? ????? MSDN "????? ????? ??????? ???? ??? ????? ??????? ???????."
  4. ????????? ??????? ????? ??????? ?????? ?????? ??? ????? ????? ????? ?? ????? ??????? ??????. ????????? ??????? ?? ????? ??????? ??????? ????? ?????? ???? ?????? ??? ?? ????? SQL Server ?? ????????? ??????. ?? ???? ?????? ??? ???????? ????? ??????? ??? ????? ????? ??????? ?? ???????. ?????? ??? ??????? ?? ????? ????? ??????? ?????? ?????? ???? ???? ?? ?????? ?????? ?????/????? ????? ?? ???????. ??? ???? ??????? ????? ??????? ?????????????????????? ???? ? ?????????????????????? ???? ?????? ?? ????? ????? ??????? ?????? ?????? ???? ???? ?? ?????? ?????? ?????/????? ?????.

    ????? ??????? ???? ???? "???????" ???? ??? ?????? ?????? ?? ??? ?????? ?????? ?? ??? ??? ??????? ?????? ?????? ?????? ????? ?????? ?????? ?? ???????. ??? ???? ??????? ????? ??? ?????? ?????? ????? ??????? ?????? "?" ????? ?????? ??????? ?? ????? ??????? ?????? ??????. ????? ?? ????????? ??? ??? ???????? ?? ?????? ????? Microsoft ??????? ??? ?????:
    http://blogs.msdn.com/ntdebugging/archive/2007/11/27/too-much-cache.aspx

    http://blogs.msdn.com/ntdebugging/archive/2009/02/06/microsoft-windows-dynamic-cache-service.aspx

    http://support.microsoft.com/default.aspx?scid=kb;EN-US; 976618
    ????? ????? ???? "Microsoft ????? ????? ??????? ?????? ????? Windows" ?????? ?? ??????? ???? ??? ????????? ?? ??? ????? ??????? ??????.
  5. ??? ?? ????? ???? SQL ?? SAP R/3? ?? ?????? ????? ?????. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ????? Microsoft":
    931308 ?? ????? ????? ????? ??????? ??? ????? ?????? ??? ????? ?????? SAP R/3 ??? ???? ??????? ????? ??? Windows Server 2003
  6. ??? ??? ?????? SQL Server ??? Windows Server 2008? ??? ????? ??????? ???????? ???????? ???? ???? ?? ???? ??? ????? ?????? ???? ?? ??????? ??????? ?????? ??? ???????? ??????? ???? ??????? ??????. ????? ?? ?????????? ???? ??? ????? ???????? ??????? ???? ???????? ?? ????? ????? Microsoft:

    971442 ???? ???? ????? ???? ?????? ?? ?????? ??? ?????? ??? ??????? ?? ???? ???? ?????? Windows Vista ?? Windows Server 2008 ?? ???? ????

    974609 ???? ???? ??????? ???? ???? ?????? Windows Server 2008 ???????? ?? ????????? ??? ????? ????? ????

    971714 ?????? ???? ????? ????? ??????? ?? ????????? ??? ????? Perfmon.exe ?? ???? "????? ?????? ?????" ?????? ????? ??? ???? ???? ???? ???????? ??? Windows Server 2008
  7. ??? ??? ?????? SQL Server ??? Windows ???? 2008 R2? ??? ????? ??????? ???????? ???????? ???? ?? ???? ??? ?????? ??????? ?????. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
    979149 ???? ??????? ???? ????? ??????? Windows 7 ?? Windows Server 2008 R2 ???? ??? ??????? ??? ????? ????? ????

    2155311 ???? ??? ?????? ??? ???? ??????? ????? ??? ????????? ???? ????? ??? NUMA ????? ????? ??????? Windows 7 ?? Windows Server 2008 R2 ??? ??? ???? ????? ????? ?????? ?? ??????? ??? ??? 4 ???????? ?? ???????

    2468345 ????????? ???? ???? ???? ????? ?? ????? ?? ????????? ??? ??????? ?????? Storport ?? ???? ??????? Windows Server 2008 R2

????? ????? ??????? ????????? ?? ??? ??????? 64 ?? ?? SQL Server

????? ??????? "?????? ??????" ???? ???? ??????? ????????? ?? ??? ??????? 64 ?? ?? SQL Server. ?????? ????? ?????? ?????? ?????? ???????:
???? ??????: ???????
??????: ???????/???????
????? ?? ????????? ??? ????? ??????? ??? ?????? ?????? ???? ???????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
889654 ????? ????? ??? ??? ????? ??????? ???????? ????????? 64 ?? ?? Windows Server 2003 ?? ???? ??????? Windows XP
???????? ??? ???? ????? ???? ????? ????? ??????? ??? ??????? 64 ?? ?? SQL Server ??????? ?????? ?????? ???????:
???? ??????: ?????
??????: ????? ?????? ??????
????: sqlservr

???? ??????: ?????
??????: ?????? ?????
????: sqlservr
???? ?????? Bytes ???? ??????? ???? ????? ?????. ???? ?????? "?????? ?????" ??????? ??????? ???? ?????? ????? ???????. ??????? 64 ?? ?? SQL Server ???? ??????? ?????? ?????? ??????? ???? ??????? ???? ?????? ???? ?????? ??????:
???? ??????: ????? ???????: ???? SQL
??????: ?????? ?????? memory (kb)
?????? ??? ??? ???? ??????? 64 ?? ?? SQL Server ???? ????? ??? ???? ?????? ?? ???:
MSSQL$??? ??????: ????? ???????
??? ???? ???? ?????? "?????? ?????" ??? ?? ???? ?????? "????? memory (kb) ??????"? ?? ????? ??? ????? ??? ??????? ???? ?? ???? ?????? ?????? ?? SQL Server ?????? ?????.

??? ????? ?? ???????? ????? ??????? ?? ??????? ?????? ????? ???? SQL Server? ???? ?????? ?????? ?????? SQL Server ?? ???? ?????? ??????? ???? ????? ???????? ? ???? ???? ???? ?? ???? ??????? ???? ???????. ??? ???? ?? ???? ???? ?????? ????? ??????? ???? ?????? ?????? ???? ??? ?????? ?? ??????? ?? ?????? ?????? ???????:
  • ????? ?????? ?????? ?????? ??????? "?????? ?????" ?? "?????? ??????"
  • ??????? ????? ?????? ?? ????? ???????? ?? ????? ??????
??? ?? ??? ????? ??? ???????? ?????? ?????? ??? ???? ?????? ????? ??????? ???? ????? SQL Server ????? ?? ?????? ??? ???????? ???? ?????? ??????. ???? ?????? ?????? ?????? memory (kb) ????? ?????? ????? ???????: ???? SQL ???? ??????? ???? ?? ??????? ????? ?????? ??????.

???????? ???? ??? ????? ???????? "????? ??????? ?? ???????" ?????? ????? ????? 64 ?? ?? SQL Server

???? ?? ???? ???????? ?????? ??? ????? ????? ??????? ?? ??????? ???????? ??????. ??? ??? ?????? ??? ???????? ?? ??? ??????? ???? ?? ??????? ???? ??? ????? ?? ??????? ?????? ?? ???? ?????? ???? ?????? ??????. ???????? ??? ???? ?? ??? ????? ??? ???? 333 ?? ??? ???????.

??? ????? ????? ??? ??????? ?? Microsoft "(CSS) ???? ???????? ?? ?????? ????????? CSS ?????? ?? ???????? ??? ????? ???????? ???? ??? ???????? ????? ??? ????? ???? SQL Server. ?? ???? ??? ?????? ?????? ???? ?????? ?????? ?????? ???? ???? ?? ???????? ?????? CSS ??????? ???????? ?????? ???????? ????? SQL ?????????? ?????? ???? ??? ??????? ??? ??????. ??? ????????? CSS ??? ?????? ??????? ????? ????? ????? ??????? ?? ??????? ???????? ?????? ??? ???? ??? ????? ???? SQL Server.

??? ????? ?? ???????? ????? ??????? ?? ??????? ? ???? ?? ??? ????? ?????? ??? "?????? ??????" ?????? ??????? ??????? ?????? ????????? ???????? ???? ?? ??????? ??? ??????. ????? ??? ????????? ???? SQL Server. ?????? ??????? ???????? ???? ????????? ???????? ???????:
  • ???? ?? ????? ???? ????? ?????? ???? ?????? ? ???? ?????? ????? ?????? ???? ????. ??? ???????? ???? ??????? ????? ???? ?????? ?????? ?????? SQL Server. ??? ???? ??? ???????? ??????? ???? ?? ??????? ???????? ?????? ???? ????? SQL Server. ????? ??? ???????? ???????:
    • ?????? ????? ?????? SQL Server
    • ???? ????? ??????? ?? ????? ??????? ?? SQL Server
    • DLLs ????????? ???? ???? ?????? ????? SQL Server ???? ????? ????? ??????? SQL Server ??????
    • ?????? ????? ????????? ??????????
  • DLLs ??????? ????? ????? ????? OLE DB? ????????? ??????? ???????? ?????? Microsoft COM ???? ?????? ??????? sp_OACreate ????? ????????? ?????? SQL Server CLR. ??????? ???? ?? ??????? ???? ???????? ??? ??? ????? ???? nonbuffer ????? ????? ??????? SQL Server. ?????? ???? ?????? ?????? ??????? ???? ???? ??????? SQL Server ??????? ??????? ????? ?????? ??? ?? ???? ???? ??????? ???? ?? ??????? ???????? ???? ?? ?????? ???? ?????? ?????? ?? ?????? ??????? ???? ???? ????? SQL Server ????????. ???? ???? ????? ??????? ?????? ???????? ?????? ???? ????? ?????? ??? ???? . ??? ????? ???? ????? ?????? ???? ?????? ? ???? ?????? ????? ?????? ? ??? ???? ?????? ??????? "????? ?????? ??????? ??????" ?? "??? SQL Server ??? ??????" ??????.
  • ????? ??????? ??????? ????????? ?????? ??????? ???? ??????? Windows. ?? ????? ??????? SQL Server ???????? ??????? ??? ???? ??????? ???? SQL Server ?????? ????? ???????? ???? SQL ????? ?????? SQL Server? ?????? ????? SQL Server? ????? ????? SQL Server ???? ???? ?????? ? SQL Server. ?? ?????? ????????? ???? ???? ?????? ?????? ????? ????????? ??????? ??? ??????? ?? ???????. ?? ???? ???????? ?????? ??? "???? ???????" ?????? ?????? ????? ??? ???????/???????. ??? ?????? ??????? ??????? ??? ????????? ????? ???? ?????? ???? ?????? ????? ?????? ???? ?????? ??????? ????? ?????? ????? . ????? ??????? ????? ?????? ?????? ?????? ????? "?????? ?????" ??? ???? ??????? ??? ????? ?????? ??????? ??????? ?? ??? ????? ?????.
  • ???? ???????? ????? ?????? ?? ????? ?? ???????? ????? ??????? ?? ??????? ????? "?????? ??????" ??????. ????? ?? ?????????? ?? ?????? ???? Microsoft ?????? ??? ?????:
    http://blogs.msdn.com/psssql/archive/2007/10/18/do-i-have-to-assign-the-lock-privilege-for-local-system.aspx
  • ??? ??? ?????? ???? ?????? Windows ????? ????? ???????? SQL Server ?? ???? ??? ????? ???? ???????? ???? ?? ??????? ???????? ????? "??? ????????". ?? ?????? ????? SQL Server 32-?? ??? ?????? ????? ??? ???????. ??? ???? ????? ??? ?????? ?? ???????? ????? ??????? ?? ??????? ?????? ???? ?????? ??? ?????? ???????? (AWE). ????? ?? ?????????? ???? ??????? "????? ???? ????? ?? ??????? ??? SQL Server" ?? "??? SQL Server ??? ??????".
  • ??? ????? ???? ????? ?????? ???? ?????? ? ???? ?????? ????? ?????? ?????? ?? ?????? SQL Server? ?? ???? ???????? ??????? ????? ???? nonbuffer ??? ???? ?? SQL Server. ?? ?? ?????? ??? ???????? ??? ???? ?? SQL Server.
????? ?????? ????? ??? ??? ????????? ?????? ????? ???? ???????. ????? ????? ????? ??????? ??????? ????????? ????????? ???????? ???? ????? ??????. ????? ??????? ??????? ?? ???? ??? ???? ???? ????? ??????? ?????????? ???? ??? ??????? ??? ??????.

????? ??????? ????????? ?? ??????? ??????? ?????? SQL Server ?????? ?????? ??????? ????? ???? ???????

????? ??????? ????????? ?? ??????? ??????? ?????? SQL Server ?????? ?????? ??????? ??? ?????? ????? ???? ???????. ????? ??????? ?????? ??? ??? ???????? ????? ?????? ?????? ??? ??? ?????????.
SELECT CONVERT (varchar(30), GETDATE(), 121) as runtime,
DATEADD (ms, -1 * (sys.ms_ticks - a.[Record Time]), GETDATE()) AS Notification_time,  
 a.* , sys.ms_ticks AS [Current Time]
 FROM 
 (SELECT x.value('(//Record/ResourceMonitor/Notification)[1]', 'varchar(30)') AS [Notification_type], 
 x.value('(//Record/MemoryRecord/MemoryUtilization)[1]', 'bigint') AS [MemoryUtilization %], 
 x.value('(//Record/MemoryRecord/TotalPhysicalMemory)[1]', 'bigint') AS [TotalPhysicalMemory_KB], 
 x.value('(//Record/MemoryRecord/AvailablePhysicalMemory)[1]', 'bigint') AS [AvailablePhysicalMemory_KB], 
 x.value('(//Record/MemoryRecord/TotalPageFile)[1]', 'bigint') AS [TotalPageFile_KB], 
 x.value('(//Record/MemoryRecord/AvailablePageFile)[1]', 'bigint') AS [AvailablePageFile_KB], 
 x.value('(//Record/MemoryRecord/TotalVirtualAddressSpace)[1]', 'bigint') AS [TotalVirtualAddressSpace_KB], 
 x.value('(//Record/MemoryRecord/AvailableVirtualAddressSpace)[1]', 'bigint') AS [AvailableVirtualAddressSpace_KB], 
 x.value('(//Record/MemoryNode/@id)[1]', 'bigint') AS [Node Id], 
 x.value('(//Record/MemoryNode/ReservedMemory)[1]', 'bigint') AS [SQL_ReservedMemory_KB], 
 x.value('(//Record/MemoryNode/CommittedMemory)[1]', 'bigint') AS [SQL_CommittedMemory_KB], 
 x.value('(//Record/@id)[1]', 'bigint') AS [Record Id], 
 x.value('(//Record/@type)[1]', 'varchar(30)') AS [Type], 
 x.value('(//Record/ResourceMonitor/Indicators)[1]', 'bigint') AS [Indicators], 
 x.value('(//Record/@time)[1]', 'bigint') AS [Record Time]
 FROM (SELECT CAST (record as xml) FROM sys.dm_os_ring_buffers 
 WHERE ring_buffer_type = 'RING_BUFFER_RESOURCE_MONITOR') AS R(x)) a 
CROSS JOIN sys.dm_os_sys_info sys
ORDER BY a.[Record Time] ASC

?????? ??? ????????? ??? ???? ??? ?? SQL Server 2005 ? SQL Server 2008.

????? ????????? ?? ????????? ???? ??? ??????? ?? sys.dm_os_process_memory ????? ??? ????? ???? ???? ?? ??? ??? ?????? ????? ???? ??????? ????????. ????? ?? ?????????? ???? ???? ??? SQL Server 2008 ?? ???? Msdn ??????:
http://msdn.microsoft.com/en-us/library/bb510747.aspx
???? SQL Server 2008 R2 ???? ????????? (SQL Server 2008 R2 ????? ??? ?????) ???? ????? ?????? ????? ?? ??????? ???? ???? ?? ???? ????? ?????? ?????? ?? ????? SQL Server. ????? ??? ????? SQL Server 2008 R2 ???? SQL Server 2008 ? SQL Server 2008 R2.

?? ??? ??????????? ??? ??????
????? ???????????? ?????????? ?????????????? ???????? ???? ??? ????? ???????
???? SQL Server 2008 R2 ???? ????????? (SQL Server 2008 R2 ???)
??????? ??????? SQL Server ??? ?????


?? ???? ????? ?????? ????? ??? ????? ????? ??????? "???? ????? ??????-??????? ??? ?????? ????? SQL Server" ????? ??? ?????? ?? ????? ????? ?????? ??? ???? ???? ?????? ?? SQL Server ????? ??????? ?? ?????? "???????? ???? ??? ????? ????????' ????? ??????? ?? ??????? '?? ????? ?? ????? 64 ?? ?? SQL Server" ?? ??? ???????.SQL Server 2008
SQL Server 2008 R2


???? SQL Server 2008 R2 ???? ????????? (SQL Server 2008 R2 ???)????? ????? ????? ??????? ?????? ???? ??????? ??????? ?????? ??????? ???? ????? ?????? ????? ??? ????? ?????? ?????? "???? ????? ??????-????? ???? ??????? ?????? ??????? ????? ????? ????? ???????? ??????" ????? ??? ?????? ???? ????????? ???? ??? ???????? ?? ????? "?? ???????" ?? ??? ??????? ????????.
SQL Server 2008
SQL Server 2008 R2

???? SQL Server 2008 R2 ???? ????????? (SQL Server 2008 R2 ???)??? ???? ?? ????? SQL Server ??? ?? ?????
??? ??? ?????? ?????? ????? ??? ????? ?????? ??? "???? ????? ??????-??? ???? ?? SQL Server ????? ?????" ????? ??? ?????? ??????? "????" ? "???? ??????" ?? ??? ??????? ?????? ??????? ???????.
SQL Server 2008
SQL Server 2008 R2


??????? ?? Windows Server 2008 ??? Windows Server 2008 R2


Windows Server 2008 ? Windows Server 2008 R2 ????? ???? ????? ??????? ???????. ???? ??? ??????? Windows Server 2008 ? Windows Server 2008 R2 ????? ????????? ??????? ???? ?????? ??? ????????? ??? ?? ?? ??? ???? ????? ??????? ???????.

?????? ??? ????????? ?? ??????? ?????? Microsoft "????? ?? ??????? ??????? ?? Windows":

??? ?? ???? ????? ????? ??????? ??????? ?????? ?? Windows Server 2008. ??? ??? ????? ??????? ??????? ?? ??????? ?? ???? ??? ????? ??????? ???? ???? ???? ???????? ???????? ???? ??? ??? ?????? ????? ?? ????? ?????? ???????/???????. ???????? ??? ???? ?????? ?? ????? ???? ?? ????? ? ??? ?????? kernel ?????? ?????? ????? ?????? ?????? ??? ???? ????-?? ???? ???????? ?????????. ????????? ???? ?? ??????? ??????? ????? ???? ??? ?? ?? ??? ?? ???????. ???????? ??? ????? ?????? ??? ??? ???????? ??? ?????.
???? ??????? ?????? "????? ?? ??????? ??????? ?? Windows"? ?? ?????? ???? Microsoft ?????? ??? ?????:
http://download.microsoft.com/download/9/c/5/9c5b2167-8017-4bae-9fde-d599bac8184a/MemMgt.docx
????? ?? ?????????? ?? ?????? ????? Microsoft ??????? ??? ?????:
http://blogs.msdn.com/psssql/archive/2008/03/03/sql-server-working-set-trim-problems-consider.aspx
http://support.microsoft.com/kb/2001745
?????? ??? ???? ??????? ????? ??? Windows Server 2008? ??? ????? SQL Server Service Pack 2 (SP2) ?? "???? ?????? ?? SQL Server" ??????.

?????? ??? ?????? ???? ??????? ??? ??????? ????? ?????? ?????? ?? Microsoft. ?? ???? Microsoft ?? ????? ???? ?????? ?? ?????? ????? ???? ?? ???? ?????? ?? ??? ????????.

???????

???? ???????: 918483 - ????? ??? ??????: 24/?????/1435 - ??????: 2.0
????? ???
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Enterprise
????? ??????: 
kbsqlsetup kbsql2005engine kbexpertiseadvanced kbinfo kbmt KB918483 KbMtar
????? ????
???: ??? ????? ??? ??????? ???????? ????? ?????????? ??????? ?????? ??? ??????? ?? ??? ??????? ?? ??????? ??? ??? ?? ???? ????????? ???? ??????? ???????(CTF) ?? ?? ???? ????? ????. ???? ?? ???? ?????????? ??? ???????? ???????? ???? ??? ?? ???????? ??????? ?? ??? ??????? ???????? ?? ??? ??????? ??????? ??? ?????? ?? ?????? ??? ???? ???????? ???????? ?? ????? ??????? ????? ????? ??????. ??? ?? ???????? ???????? ?? ????? ??? ????? ?? ???????? ?? ???? ????? ?? ?????. ?????? ??? ???? ?????????? ???? ?????? ?? ??? ????? ?? ??? ??? ?? ??????? ?? ??? ????? ?? ???? ????? ????? ?? ????? ??????? ???? ?? ???????? ?? ??? ???????.
???? ??? ????? ??????? ?????? ??????????918483

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

 

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