ÎÄÕ | ÎÄÕÂÁбí>> |
2008-07-20 14:14:35
Àà±ð£ºÎ´·ÖÀà |
ÔĶÁÈ«ÎÄ(30) |
»Ø¸´(0)
2008-06-17 11:04:41
Àà±ð£ºÎ´·ÖÀà |
ÔĶÁÈ«ÎÄ(71) |
»Ø¸´(0)
2008-04-18 11:41:31
Àà±ð£ºÎ´·ÖÀà |
ÔĶÁÈ«ÎÄ(54) |
»Ø¸´(0)
2008-04-18 09:09:20
Àà±ð£ºÎ´·ÖÀà |
ÔĶÁÈ«ÎÄ(45) |
»Ø¸´(0)
2008-03-24 09:19:02
°²×°SQL SERVER 2000Óöµ½µÄ¶þ¸öÎÊÌâ
===========================================================
×÷Õß: wqbi(http://wqbi.itpub.net)
·¢±íÓÚ: 2005.12.03 17:19
·ÖÀà: SQL ServerÖ®ÂÃ
³ö´¦: http://wqbi.itpub.net/post/2966/47546
---------------------------------------------------------------
×î½üÒª×ö±ÏÒµÉè¼ÆºÍÒ»¸öѧÉúÐÅÏ¢¹ÜÀíϵͳ£¬ÒªÇóÓÃSQL SERVER 2000,ËäÈ»ÒÔǰҲÓùý£¬ºóÀ´Ã»ÓÐÓøÄÓÃMYSQL£¬¾ÍɾÁË¡£½ñÌì֨װÁË£¬ºöÈ»³öÏÖÁ˶þ¸öºÜÓôÃÆÎÊÌ⣡ÏÖÔÚ°ÑËü¼ÇÏÂÀ´¡£
1. ¸Õ¿ªÊ¼×°ÊdzöÏÖ£º"ÒÔǰµÄij¸ö³ÌÐò°²×°ÒÑÔÚ°²×°¼ÆËã»úÉÏ´´½¨¹ÒÆðµÄÎļþ²Ù×÷¡£ÔË×÷°²×°³ÌÐò֮ǰ±ØÐëÖØÐÂÆô¶¯¼ÆËã»ú¡£ÖØÐÂÆô¶¯»úÆ÷ûÓÐ×÷ÓÃ."Õâ¸ö´íÎóÌáʾ£¬»¹ÒÔÎªÖØÐÂÆô¶¯¼ÆËã»ú»áºÃµÄ£¬µ«ÊÇÖØÆôҲûÓá£
¼ÇµÃÒÔǰҲװ¹ý£¬ºÃÏóÊÇûÓÐ×°³É¹¦£¬É¾ÁË¡£¿ÉÄÜÊdzåÍ»ÎÊÌâ°É¡£Ö»ºÃµ½ÍøÉÏÒ»ËÑ£¬ÎÊÌâ¾Í½â¾öÁË¡£
½â¾ö·½·¨£º´ò¿ª×¢²á±í, ÕÒµ½hkey_local_machinesystemcurrentcontrolsetcontrolsession manager, ÕÒµ½'PendingFileRenameOperations' Öµ, ²¢É¾³ýÆäÖÐËùÓÐÊý¾Ý, Ö®ºóÄã¾Í¿ÉÒÔ°²×°SQL Server 2000ÁË.
2.һ·nextÏÂÀ´£¬ÓÖ³öÏÖÁËÒ»¸öÎÊÌ⣺"ÎÞ·¨ÕÒµ½¶¯Ì¬Á´½Ó¿âS..
===========================================================
×÷Õß: wqbi(http://wqbi.itpub.net)
·¢±íÓÚ: 2005.12.03 17:19
·ÖÀà: SQL ServerÖ®ÂÃ
³ö´¦: http://wqbi.itpub.net/post/2966/47546
---------------------------------------------------------------
×î½üÒª×ö±ÏÒµÉè¼ÆºÍÒ»¸öѧÉúÐÅÏ¢¹ÜÀíϵͳ£¬ÒªÇóÓÃSQL SERVER 2000,ËäÈ»ÒÔǰҲÓùý£¬ºóÀ´Ã»ÓÐÓøÄÓÃMYSQL£¬¾ÍɾÁË¡£½ñÌì֨װÁË£¬ºöÈ»³öÏÖÁ˶þ¸öºÜÓôÃÆÎÊÌ⣡ÏÖÔÚ°ÑËü¼ÇÏÂÀ´¡£
1. ¸Õ¿ªÊ¼×°ÊdzöÏÖ£º"ÒÔǰµÄij¸ö³ÌÐò°²×°ÒÑÔÚ°²×°¼ÆËã»úÉÏ´´½¨¹ÒÆðµÄÎļþ²Ù×÷¡£ÔË×÷°²×°³ÌÐò֮ǰ±ØÐëÖØÐÂÆô¶¯¼ÆËã»ú¡£ÖØÐÂÆô¶¯»úÆ÷ûÓÐ×÷ÓÃ."Õâ¸ö´íÎóÌáʾ£¬»¹ÒÔÎªÖØÐÂÆô¶¯¼ÆËã»ú»áºÃµÄ£¬µ«ÊÇÖØÆôҲûÓá£
¼ÇµÃÒÔǰҲװ¹ý£¬ºÃÏóÊÇûÓÐ×°³É¹¦£¬É¾ÁË¡£¿ÉÄÜÊdzåÍ»ÎÊÌâ°É¡£Ö»ºÃµ½ÍøÉÏÒ»ËÑ£¬ÎÊÌâ¾Í½â¾öÁË¡£
½â¾ö·½·¨£º´ò¿ª×¢²á±í, ÕÒµ½hkey_local_machinesystemcurrentcontrolsetcontrolsession manager, ÕÒµ½'PendingFileRenameOperations' Öµ, ²¢É¾³ýÆäÖÐËùÓÐÊý¾Ý, Ö®ºóÄã¾Í¿ÉÒÔ°²×°SQL Server 2000ÁË.
2.һ·nextÏÂÀ´£¬ÓÖ³öÏÖÁËÒ»¸öÎÊÌ⣺"ÎÞ·¨ÕÒµ½¶¯Ì¬Á´½Ó¿âS..
Àà±ð£ºÎ´·ÖÀà |
ÔĶÁÈ«ÎÄ(206) |
»Ø¸´(0)
2008-03-17 12:07:23
Àà±ð£ºÎ´·ÖÀà |
ÔĶÁÈ«ÎÄ(407) |
»Ø¸´(0)
2008-03-17 09:54:35
Àà±ð£ºÎ´·ÖÀà |
ÔĶÁÈ«ÎÄ(31) |
»Ø¸´(0)
2008-02-28 20:30:26
Àà±ð£ºÎ´·ÖÀà |
ÔĶÁÈ«ÎÄ(43) |
»Ø¸´(0)
2008-02-28 17:00:51
Àà±ð£ºÎ´·ÖÀà |
ÔĶÁÈ«ÎÄ(122) |
»Ø¸´(0)
2008-02-23 10:51:59
Àà±ð£ºÎ´·ÖÀà |
ÔĶÁÈ«ÎÄ(341) |
»Ø¸´(0)
2008-02-16 15:51:48
Àà±ð£ºÎ´·ÖÀà |
ÔĶÁÈ«ÎÄ(49) |
»Ø¸´(0)
2008-02-16 15:36:14
Àà±ð£ºÎ´·ÖÀà |
ÔĶÁÈ«ÎÄ(267) |
»Ø¸´(0)
2008-02-03 00:51:02
Àà±ð£ºÎ´·ÖÀà |
ÔĶÁÈ«ÎÄ(73) |
»Ø¸´(0)
2008-02-03 00:41:35
Àà±ð£ºÎ´·ÖÀà |
ÔĶÁÈ«ÎÄ(392) |
»Ø¸´(0)
2008-02-02 22:37:25
Àà±ð£ºÎ´·ÖÀà |
ÔĶÁÈ«ÎÄ(466) |
»Ø¸´(0)
2008-02-01 22:13:28
Àà±ð£ºÎ´·ÖÀà |
ÔĶÁÈ«ÎÄ(109) |
»Ø¸´(0)
2008-02-01 20:17:06
oracle10ÔÚlinuxµÄ°²×°
À´Ô´£ºwww.wooln.cn ×÷Õߣºcomerwang
oracleµÄ°²×°ÓõÄÊÇ×î¼òµ¥µÄ·½·¨¡£Ö»ÇóÄÜ×°³É¹¦£¬ÄÜÅÜÆðÊý¾Ý¿â£¬ÄÜʵÏÖ»ù±¾µÄµÄSQL²Ù×÷¡£
[root@Enterprise ~]# cat /etc/issue
Red Hat Enterprise Linux AS release 4 (Nahant Update 4)
[root@Enterprise ~]# uname -a
Linux Enterprise 2.6.9-42.EL #1 Wed Jul 12 23:16:43 EDT 2006 i686 i686 i386 GNU/Linux
»ù±¾µÄһЩ²¹¶¡¾Í²»ÅäÖÃÁË¡£¸Ð¾õÕâ¸ö°æ±¾¶¼¿ÉÒÔ¡£
´ÅÅ̺ÍÄÚ´æÒªÇó
ËùÐè×îС RAM Ϊ 512MB£¬¶øËùÐè×îС½»»»¿Õ¼äΪ 1GB¡£
¶ÔÓÚ RAM СÓÚ»òµÈÓÚ 2GB µÄϵͳ£¬½»»»¿Õ¼äӦΪ RAM ÊýÁ¿µÄÁ½±¶£»¶ÔÓÚ RAM ´óÓÚ 2GB µÄϵͳ£¬½»»»¿Õ¼äӦΪ RAM ÊýÁ¿µÄÒ»µ½Á½±¶¡£
ÀýÈ磺
# grep MemTotal /proc/meminfo
MemTotal:512236 kB
# grep SwapTotal /proc/meminfo
SwapTotal:1574360 kB
£¨±¾È˳¢ÊÔ¹ý300¶àMÄÚ´æÒ²Ò»Ñù¿ÉÒÔ×°¡££©
OS²ÎÊýÒªÇóvi /etc/sysctl.conf , ÔÚÐÐÄ©Ìí¼ÓÒÔÏÂÄÚÈÝ
#use for oracle
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 1..
À´Ô´£ºwww.wooln.cn ×÷Õߣºcomerwang
oracleµÄ°²×°ÓõÄÊÇ×î¼òµ¥µÄ·½·¨¡£Ö»ÇóÄÜ×°³É¹¦£¬ÄÜÅÜÆðÊý¾Ý¿â£¬ÄÜʵÏÖ»ù±¾µÄµÄSQL²Ù×÷¡£
[root@Enterprise ~]# cat /etc/issue
Red Hat Enterprise Linux AS release 4 (Nahant Update 4)
[root@Enterprise ~]# uname -a
Linux Enterprise 2.6.9-42.EL #1 Wed Jul 12 23:16:43 EDT 2006 i686 i686 i386 GNU/Linux
»ù±¾µÄһЩ²¹¶¡¾Í²»ÅäÖÃÁË¡£¸Ð¾õÕâ¸ö°æ±¾¶¼¿ÉÒÔ¡£
´ÅÅ̺ÍÄÚ´æÒªÇó
ËùÐè×îС RAM Ϊ 512MB£¬¶øËùÐè×îС½»»»¿Õ¼äΪ 1GB¡£
¶ÔÓÚ RAM СÓÚ»òµÈÓÚ 2GB µÄϵͳ£¬½»»»¿Õ¼äӦΪ RAM ÊýÁ¿µÄÁ½±¶£»¶ÔÓÚ RAM ´óÓÚ 2GB µÄϵͳ£¬½»»»¿Õ¼äӦΪ RAM ÊýÁ¿µÄÒ»µ½Á½±¶¡£
ÀýÈ磺
# grep MemTotal /proc/meminfo
MemTotal:512236 kB
# grep SwapTotal /proc/meminfo
SwapTotal:1574360 kB
£¨±¾È˳¢ÊÔ¹ý300¶àMÄÚ´æÒ²Ò»Ñù¿ÉÒÔ×°¡££©
OS²ÎÊýÒªÇóvi /etc/sysctl.conf , ÔÚÐÐÄ©Ìí¼ÓÒÔÏÂÄÚÈÝ
#use for oracle
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 1..
Àà±ð£ºÎ´·ÖÀà |
ÔĶÁÈ«ÎÄ(111) |
»Ø¸´(0)
2008-02-01 20:11:43
Àà±ð£ºÎ´·ÖÀà |
ÔĶÁÈ«ÎÄ(52) |
»Ø¸´(0)
2008-01-31 23:23:52
Àà±ð£ºÎ´·ÖÀà |
ÔĶÁÈ«ÎÄ(247) |
»Ø¸´(0)
2008-01-31 23:20:28
Àà±ð£ºÎ´·ÖÀà |
ÔĶÁÈ«ÎÄ(80) |
»Ø¸´(0)
51CTOÍÆ¼ö²©ÎÄ | ¸ü¶à.. |


zhanghonghai µÄBLOG
²©¿Íͳ¼ÆÐÅÏ¢
×îÐÂÆÀÂÛ
ÓÑÇéÁ´½Ó
ÎÄÕÂ
51CTOÍÆ¼ö²©ÎÄ
¹«¸æ
ÈÈÃÅÎÄÕÂ
51CTOÍÆ¼ö²©¿Í