Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎÊ´ð£º

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

¹ØÓÚSQLSERVERµ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......

sqlÐÔÄÜÇóÖú - MS-SQL Server / ÒÉÄÑÎÊÌâ

³¡¾°ÈçÏ£º
¿Í»§°Ñ±¸·ÝºÃµÄÊý¾Ý¿â£¬·¢¸øÎÒ£¬ÎÒÔÚ±¾»ú»¹Ô­ºó£¬ÔËÐÐдºÃµÄ´æ´¢¹ý³Ì£¬±È½Ï¿ì£¬²¢ÇÒÔÚʵʩÄDZßÔËÐÐͬÑù±È½Ï¿ì¡£µ«Êǵ±ÊµÊ©ÔÚ¿Í»§ÄDZßÔËÐеÄʱºòËٶȾͷdz£µÄÂý£¬Ê±¼ä³¬³öÁ˳ÌÐòµÄʱ¼äÏÞÖÆ¡£Ô¶³ÌÔÚ¿Í»§ÄÇ ......

ÇóÒ»ÌõSQL - MS-SQL Server / ÒÉÄÑÎÊÌâ

--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 - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡

Ëæ±ã¸ãÒ»D°æ°É£¬

ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù

http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ