sqlserver´íÎó - MS-SQL Server / ÒÉÄÑÎÊÌâ
sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬ sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º ÈÕÆÚ 2010-1-25 14:45:16 ÈÕÖ¾ SQL Server (µ±Ç° - 2010-1-25 14:45:00) Ô´ spid1s ÏûÏ¢ A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): 16796, committed (KB): 42420, memory utilization: 39%. ʵÔÚ²»ÖªµÀÓ¦¸ÃÔõô½â¾öÁË£¬ÄÄλ½Ó´¥¹ýÕâÀà´íÎóÌáÐÑÒ»ÏÂ
ûÅöµ½¹ý,¹À¼ÆÊÇSQL Server¶ËÓÐ×Ô¶¯±¸·Ý¹¦ÄÜ,µ¼ÖÂÄÚ´æÒæ´¦. ²»¶®Õâ¸ö °ï¶¥ ²»¶®£¬°ï¶¥...ÒýÓà ´Ó´íÎóÐÅÏ¢Àï¿´£¬SQL Server½ø³ÌµÄÄÚ´æ±»²Ù×÷ϵͳ·ÖÒ³µ½Ò³ÃæÎļþ¡£ SQL Serverͨ³£»á»ý¼«ÏìÓ¦²Ù×÷µÄϵͳµÄÄÚ´æÑ¹Á¦£¬¾¡Á¿±ÜÃâ±»page outµ½Ò³ÃæÎļþ¡£ ¿ÉÄܵÄÔÒò£º 1. ²Ù×÷ϵͳÓöµ½Í»È»µÄ»òÑÏÖØµÄÎïÀíÄÚ´æÑ¹Á¦£¬ÔÚSQL Server×ö³ö·´Ó¦Ö®Ç°ÒѾ°Ñ½«SQL ServerµÄÄÚ´æpage outÁË¡£ 2. ÄãµÄSQL ServerµÄ°æ±¾ÊÇʲô£¿Ä³Ð©°æ±¾µÄSQL ServerÊÇ¿ÉÒÔ½øÈëÒ»ÖÖidle serverµÄ״̬¡£ÀýÈ磺SQL Server Express£¬´ËʱSQL Server½ø³Ì¿ÉÄܸüÇãÏòÓÚÀûÓÃÒ³ÃæÎļþ¡£ Õâ¸öÊÇÊý¾Ý¿âÐÅÏ¢ Microsoft SQL Server Management Studio 9.00.3042.00 Microsoft Analysis Services ¿Í»§¶Ë¹¤¾ß 2005.090.3042.00 Microsoft Êý¾Ý·ÃÎÊ×é¼þ (MDAC) 2000.086.3959.00 (srv03_sp2_rtm.070216-1710) Microsoft MSXML 2.6 3.0 5.0 6.0 M
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ ÀýÈç£ ......
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð» ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡ ¹Ø×¢¡«¡« Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿ ......
³¡¾°ÈçÏ£º ¿Í»§°Ñ±¸·ÝºÃµÄÊý¾Ý¿â£¬·¢¸øÎÒ£¬ÎÒÔÚ±¾»ú»¹Ôºó£¬ÔËÐÐдºÃµÄ´æ´¢¹ý³Ì£¬±È½Ï¿ì£¬²¢ÇÒÔÚʵʩÄDZßÔËÐÐͬÑù±È½Ï¿ì¡£µ«Êǵ±ÊµÊ©ÔÚ¿Í»§ÄDZßÔËÐеÄʱºòËٶȾͷdz£µÄÂý£¬Ê±¼ä³¬³öÁ˳ÌÐòµÄʱ¼äÏÞÖÆ¡£Ô¶³ÌÔÚ¿Í»§ÄÇ ......
--drop table #T1 --drop table #T2 create Table #T1(ID int, QueryID nvarchar(20), ResultID1 nvarchar(20), ResultID2 nvarchar(20)) create Table #T2(SortNo int, QueryID nvarchar(20), ResultID1 nv ......
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡ Ëæ±ã¸ãÒ»D°æ°É£¬ ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓà 2000,2005¶¼ÕâÑù http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......