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