???? ??? ?????? SQL ????? ?? 64-??? ??????? ??? ?????? ?? ?? ???? ?? ??? ????

• ?????? SQL ????? ????????? ?? ????? ??? ?? ???? ???? ??????
• ?????? ??????? ????? ????? i/O ?????????? ?? ?? ???? ?? ??? ?????? ??? ?????? ???? ???

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

• SQL ????? ?? ??????????? ?? ????? ????? ???
• SQL ????? ?? ??? ?? ?? ???????? ?? ?? ??? ?? ??? ??????????? ???? ??? ?? ???? ???
• ????????? ?? SQL ????? ?? ?????? ???? ?? ??? ???? ????-??? ???? ???
• ???????? ?? ???? ?? ?? ?????? ???? ????? ?? ?????? ?? ??????????? ?? ????? ?????

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. 

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

1. ????? ???? ??????? ????, ????? ???? ?????, ?????? gpedit. msc, ?? ??? ????? ???? ???.
   
   ??? ,???? ???? ????? ????? ????? ???? ???
2. ??????? ???? ???????? ????????????, ?? ??? ?? ??????? ???? Windows ??????.
3. ??????? ???? ??????? ????????, ?? ??? ?? ??????? ??????????? ????.
4. ????? ???? ?????????? ?????? ?????, ?? ??? ??? ????? ???? ??????? ???? ????? ??????.
5. ??? ??????? ??????? ???? ??????????? ????? ???, ????? ???? ?????????? ?? ???? ??????.
6. ??? ?????????? ?? ???? ?? ??? ???? ????? ????? ???, Sqlservr.exe ????? ?????, ?? ???? ??? ?? ??? ?????? ?? ???? ?????????.
7. ??? ???? ???? ???? ????? ??????
8. SQL ????? ???? ?? ???????? ?????

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

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

1. SQL ????? ????????? ?? ????? ??? ????? ???? ?? ??? Windows ???????? ?????? ?? ???? ????? ???????? ?? ?? ???? ?? ???, ????? Microsoft ???????? ????? ??? ?????? ???????? ???? ???? ????
   
   ??? ???????? ????? ???? ???? ?? ???????? ?? ??? ?? ??????? ?? ???????? ?? ?????? ??????? ????
   • Microsoft ??????? ??? ?? 64-??? ??????? SQL ????? ?? ???? ?? ???? ?? ?? ?????? ???? ?? ????? ???? ???? ??????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
     905865  (http://support.microsoft.com/kb/905865/ ) ??? ??????????? ????? ???? ??? ????? ??? ?? ???? ????? ??? ?? ???? ??? ?? ??? ?? ?? Windows Server 2003 ??? ??? ???????? ?? ??? ??? ???? ?? ??? ?? ??????? ?????? ?? ????? ???? ???
   • ???????? ?? ?? ??? ??? Windows Server 2003 ?? ???? ???? ???? ?? ?? ??? ??? ??? ????????? i/o buffered ??????, ???? ??? ????? ?? ??? ??? ???? ?? ??? ?? ???? ???? ???????? ?? ????????? ?????? ?? ??????? ??????? ??? ?? ????? ??? ?? ???? ?? ??? SQL Server ??? ???? ?? ???? ???? ???? ??????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
     920739  (http://support.microsoft.com/kb/920739/ ) ?? ?? ???? 500 MB Windows ????? 2003 S ?? Windows Server 2003 S ?? ???? ??????? ?? ????????? ??? ??? ??? ?? ????? ?????? ???????? ??? ??? ????? ?? ???? ???
   • ??????? ??? SQL ????? ?? ????? ??? ?? ???? ?? ?? ?????? TCP ??? ????? ???????? ?? ????? ???? ??? ???? ??????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
     942861  (http://support.microsoft.com/kb/942861/ ) ?? Windows Server 2003 ??? ??? ???? ????? ?? ???? ????????? SQL ????? ?? ?????? ???? ??? ?? ?????? ?????: "??????? ??????? ??????" "????? ???? ??????", ?? "??????????? ???? ??????"
   • Windows Server 2003 ??? ??? ??????????? ???????? ??, ?????? ????????? ?????? ?????? ?? ??????? ?? ???? ??? ???? ??????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
     942486  (http://support.microsoft.com/kb/942486/ ) ?????? ????????? Windows Server 2003 ??? ??? ???? ??????????? ???????? ?? ?????? ?????? ?? ??????? ?? ???? ??
2. ???? ?????? ??????? ?? ????? ???? ?? MmAllocateContiguousMemory ???????, ?? ?? ?? ??? ??? ???? ?? HighestAcceptableAddress ???????? ?? ?? 4 ???????? (GB) ???? ?? ???, Windows ???????? ?????? ?? 64-??? SQL ????? ????????? ??????? ??? ?? ???? ????? ?? ???? ??? ?? ?????? ?? ?? ???? ?? ???, ??????? ???????? ?? ??? ?????? ??????? ?? ???????? ?? ?????? ????? ??? ???????? ? ?? ????????? ?? ?? ???? ?? ???, "???? ??????????" ?????? ??? ????? Microsoft ???????? ???? ?????:
   2121098 (http://support.microsoft.com/default.aspx?scid=kb;en-US;2121098) ???????? ?????? ????????? ?????? ?? SQL ????? ??????? ?? ??? ???????
3. ?? ???????? ???? ???? ?? ??? ?? ??? ?? ?? ???????? ??? ??, ?? ????????? ????? ????? ???????? ?? ?????? ?? ????? ???? ?? Windows ???????? ???? ???? ???? ???? ??????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????:
   938486  (http://support.microsoft.com/kb/938486/ ) Windows Server 2003-?????? ???????? ?????? ?? ?????? ???? ??, ?? ?? ???????? ??????? ?????? ??????? ?? ?? ?? ?? ?????? ??????? trimming ???????? ?? ???? ?????????? ?? ???? ??
   956341  (http://support.microsoft.com/kb/956341/ ) Windows Server 2003-?????? ???????? ?? ???? ?????? ????? ?????? ?? ???? ?????????? ?? ???? ??
   ?????? ??????? ?????? ?????? ???? ?? ?????? ???? ???, ?? Windows ???????? ?????? ??????? ??? ???? ??????????? ?? ???? ????? ?? ???? ??? Windows ?? ???????? ?? ????? ?????? ?????? ?? ?????? ??????? ?????? ?? ??? ????? ???? ???? ??? ??????? ??? trimming ??????? ?? ??????? ??????? ?? ???? ??? ???? ??????? ?? ??? MSDN ???? ?????"?????? ?????? ?????? ??????? ????? (http://msdn.microsoft.com/en-us/library/ff190924(VS.85).aspx) ."
4. ????????? ?????? ??? ?? ????? ???? ???? ?? ???? ??, ?? ?? ???? ?????? ?????? ??? ?? ???? ?? ???? ??? ?????? ??? ?? ?????? ???? ?? ??? ??????????? ???? ?? ???, ?????? ??? ??????? ??? SQL ????? ????????? ?? ???? ??????????? ?? ????? ?? ?????? ?? ????? ???? ???, ?? ???? ????????? ??? ??? ?????? ??????? ??????? ????? ?? ???? ???? ????? i/O ???????? ??? ????????? ?? ????? ?? ???? ??? ?????? ??? ????? ?? ???????? ?????????? ?????? ?? ???, ?? ????? ?? ???? ??? SetSystemFileCacheSize ??????? ?? GetSystemFileCacheSize ????? i/O ???????? ?? ????? ?? ???? ??? ?????? ??? ????? ?? ????????? ???? ?? ??? ??????
   
   ?? ?????? ??? ??????? ??? ???? ???? ?????? ?? ????? ???? ?? ????????? ???? ?? ??? ?? ???????? ??? ??????? ?????? ?? ??? ?? ????? ?? ??? ?? ?????? ????? ???????? ???????? ?? ????? ?? ???? ???? ?????? ?? ???, ?? ??? ?????? ?? ?????? Resident ?????? ??? ?????? ??? ???? ???? ?? ???? ?? ???? ??? ???? ??????? ?? ???, ????? Microsoft ??? ?????? ?? ????:
   http://blogs.msdn.com/ntdebugging/archive/2007/11/27/too-much-cache.aspx (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://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 (http://support.microsoft.com/default.aspx?scid=kb;EN-US;976618)
   ?? ??????? ?? ??????? "Microsoft Windows ???????? ??? ?????? ??? ?? ??? ?????? ?? ????????? ???? ?? ??? ????" ?? ???? ????
5. SAP R/3 ?? ??? SQL ????? ?? ??? ??, ?? ?? ?? ?????? ?????? ????? ?? ???? ???? ???? ??????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
   931308  (http://support.microsoft.com/kb/931308/ ) SAP R/3 ????????? Windows Server 2003-?????? ???????? ?? ???? ???? ?? ????? ????? ?? ??? ???? ??? ?????? ?? ????? ?? ???? ??
6. ??? ?? SQL ????? ?? Windows Server 2008 ??? ??? ???, ?? ?? ???? ???????? ?????? ????? ?????? ??? trimming ?? ???????? ??????? ?????? ??? ??? ???? ?? ??? ?? ?? ???? ??? ????? ???????? ?? ??? ???????? ???? ???? ?????? ???? ??????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????:
   
   971442  (http://support.microsoft.com/kb/971442/ ) ??????? Windows Server 2008 ?? Windows Vista ??? ??? ???? ????? ?? ?? ??????? ?? ?????? ?? ????????? ???? ?? ?????? ???? ??? ?? ?????? ??????????? ????? ?? ???? decreased ?? ???? ??
   
   974609  (http://support.microsoft.com/kb/974609/ ) ????? Windows Server 2008 ??? ??? ???????? ???? ????????? ????? ?? ??????????? ???? ??? ?? ???? ??
   
   971714  (http://support.microsoft.com/kb/971714/ ) ??????? ??????? ????????? Windows Server 2008-?????? ????? ???????? ?? ??????? ??????? ???? ?? ??? ?????? ?????????? ????? ???????? ?? ??? Perfmon.exe ????? ?? ??????????? ???? ??? ?? ???? ??
7. ??? ?? Windows ?? ??? 2008 R2 ?? SQL ????? ??? ??? ???, ?? ?? ??? trimming ??? ???? ?? ??? ?? ?? ???? ??? ????? ???????? ?? ??? ???????? ???? ???? ?????? ???? ??????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????:
   979149  (http://support.microsoft.com/kb/979149/ ) ?? ???? ????????? ????? ?? Windows Server 2008 R2 ?? Windows 7 ??? ??? ???????? ?????????? ?? ???? ??
   
   2155311  (http://support.microsoft.com/kb/2155311/ ) ???? ???????? ???????? NUMA-?????? ?? ?? ?? Windows Server 2008 R2 ?? Windows 7 ?? ???? 4 GB ?? ?????? ?????? ????? ?????? ????? ?? ??? ??? ???????? ?? ???? ??
   
   2468345  (http://support.microsoft.com/kb/2468345/ ) ???????? ???? ???? ??? ?? ???? ?? ?? ??????????? Storport ??????? Windows Server 2008 R2 ??? ????? ???? ???? ?? ???? ??? ?? ???? ??

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

?????? 64-??? ????????? SQL ????? ?????? ????? ???? ???? ?? ?? ????????? ???? ?? ??? ????

• ???? ?????? ?????? ?? ????? ??? ?????? ??? ??????????? ???????
• , ??? ????? ????? ?? ??????????? ??? ????? ???????

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

SQL ????? ?? 64-??? ??????? ?? ?? ????? ?? ??? ???? ?? "????? ?????? ??? ???????" ?????????? ????? ???? ?? ???? ?????????? ?????

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

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

?????? ????????? ?? ?????? ???? ?? ????????? ???? ?? ??? 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 ????? 2008 R2 BPA ???????

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

??????

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

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

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