SQL ServerË÷Òý¹ÜÀíÖ®Áù´óÌúÂÉ
ÔÎÄת×Ô:http://tech.it168.com/a2009/0218/265/000000265868.shtml
Ë÷ÒýÊÇÒÔ±íÁÐΪ»ù´¡µÄÊý¾Ý¿â¶ÔÏó¡£Ë÷ÒýÖб£´æ×űíÖÐÅÅÐòµÄË÷ÒýÁУ¬²¢ÇҼͼÁËË÷ÒýÁÐÔÚÊý¾Ý¿â±íÖеÄÎïÀí´æ´¢Î»Öã¬ÊµÏÖÁ˱íÖÐÊý¾ÝµÄÂß¼ÅÅÐò¡£Í¨¹ýË÷Òý£¬¿ÉÒÔ¼Ó¿ìÊý¾ÝµÄ²éѯËٶȺͼõÉÙϵͳµÄÏìӦʱ¼ä;¿ÉÒÔʹ±íºÍ±íÖ®¼äµÄÁ¬½ÓËٶȼӿ졣
µ«ÊÇ£¬²»ÊÇÔÚÈκÎʱºòʹÓÃË÷Òý¶¼Äܹ»´ïµ½ÕâÖÖЧ¹û¡£ÈôÔÚ²»Ç¡µ±µÄ³¡ºÏÏ£¬Ê¹ÓÃË÷Òý·´¶ø»áÊÂÓëԸΥ¡£ËùÒÔ£¬ÔÚSQL ServerÊý¾Ý¿âÖÐʹÓÃË÷ÒýµÄ»°£¬»¹ÊÇÐèÒª×ñÊØÒ»¶¨µÄ¹æÔò¡£
ÌúÂÉÒ»£ºÌìÏÂûÓÐÃâ·ÑµÄÎç²Í£¬Ê¹ÓÃË÷ÒýÊÇÐèÒª¸¶³ö´ú¼ÛµÄ
Ë÷ÒýµÄÓŵãÓÐÄ¿¹²¶Ã£¬µ«ÊÇ£¬È´ºÜÉÙÓÐÈ˹ØÐĹý²ÉÓÃË÷ÒýËùÐèÒª¸¶³öµÄ³É±¾¡£ÈôÊý¾Ý¿â¹ÜÀíÔ±Äܹ»¶ÔË÷ÒýËùÐèÒª¸¶³öµÄ´ú¼ÛÓÐÒ»¸ö³ä·ÖµÄÈÏʶ£¬Ò²¾Í²»»áÄÇÃ´ËæÒâµ½´¦½¨Á¢Ë÷ÒýÁË¡£
×ÐϸÊýÊý£¬Æäʵ½¨Á¢Ë÷ÒýµÄ´ú¼Û»¹ÊÇÂù´óµÄ¡£Èç´´½¨Ë÷ÒýºÍά»¤Ë÷Òý¶¼ÐèÒª»¨·Ñʱ¼äÓ뾫Á¦¡£ÌرðÊÇÔÚÊý¾Ý¿âÉè¼ÆµÄʱºò£¬Êý¾Ý¿â¹ÜÀíԱΪ±íÖеÄÄÄЩ×Ö¶ÎÐèÒª½¨Á¢Ë÷Òý£¬Òªµ÷ÑС¢ÒªÐµ÷¡£Èçµ±½¨ÓÐË÷ÒýµÄ±íÖеļͼÓÖÔö¼Ó¡¢É¾³ý¡¢Ð޸IJÙ×÷ʱ£¬Êý¾Ý¿âÒª¶ÔË÷Òý½øÐÐÖØÐµ÷Õû¡£ËäÈ»Õâ¸ö¹¤×÷Êý¾Ý¿â×Ô¶¯»áÍê³É£¬µ«ÊÇ£¬ÐèÒªÏûºÄ·þÎñÆ÷µÄ×ÊÔ´¡£µ±±íÖеÄÊý¾ÝÔ½¶à£¬Õâ¸öÏûºÄµÄ×ÊÔ´Ò²¾ÍÔ½¶à¡£ÈçË÷ÒýÊÇÊý¾Ý¿âÖÐʵ¼Ê´æÔڵĶÔÏó£¬ËùÒÔ£¬Ã¿¸öË÷Òý¶¼»áÕ¼ÓÃÒ»¶¨µÄÎïÀí¿Õ¼ä¡£ÈôË÷Òý¶àÁË£¬²»µ«»áÕ¼ÓôóÁ¿µÄÎïÀí¿Õ¼ä£¬¶øÇÒ£¬Ò²»áÓ°Ïìµ½Õû¸öÊý¾Ý¿âµÄÔËÐÐÐÔÄÜ¡£
¿É¼û£¬Êý¾Ý¿â¹ÜÀíÔ±ÈôÒª²ÉÓÃË÷ÒýÀ´Ìá¸ßϵͳµÄÐÔÄÜ£¬×ÔÉíÈÔÈ»ÐèÒª¸¶³ö²»ÉٵĴú¼Û¡£Êý¾Ý¿â¹ÜÀíÔ±ÏÖÔÚÒª¿¼ÂǵľÍÊÇÈçºÎÔÚÕâÁ½¸öÖ®¼äÈ¡µÃÒ»¸ö¾ùºâ¡£»òÕß˵£¬ÕÒµ½Ò»¸ö»Ø±¨ÓëͶÈëµÄÁÙ½çµã¡£
ÌúÂɶþ£º¶ÔÓÚ²éѯÖкÜÉÙÉæ¼°µÄÁлòÕßÖØ¸´Öµ±È½Ï¶àµÄÁУ¬²»Òª½¨Á¢Ë÷Òý
ÔÚ²éѯµÄʱºò£¬Èç¹ûÎÒÃDz»°´Ä³¸ö×Ö¶ÎÈ¥²éѯ£¬ÔòÔÚÕâ¸ö×Ö¶ÎÉϽ¨Á¢Ë÷ÒýÒ²ÊÇÀË·Ñ¡£ÈçÏÖÔÚÓÐÒ»ÕÅÔ±¹¤ÐÅÏ¢±í£¬ÎÒÃÇ¿ÉÄܰ´Ô±¹¤±àºÅ¡¢Ô±¹¤ÐÕÃû¡¢»òÕß³öÉíµØÈ¥²éѯԱ¹¤ÐÅÏ¢¡£µ«ÊÇ£¬ÎÒÃÇÍùÍù²»»á°´ÕÕÉí·ÝÖ¤ºÅÂëÈ¥²éѯ¡£ËäÈ»Õâ¸öÉí·ÝÖ¤ºÅÂëÊÇΨһµÄ¡£´Ëʱ£¬¼´Ê¹ÔÚÕâ¸ö×Ö¶ÎÉϽ¨Á¢Ë÷Òý£¬Ò²²»Äܹ»Ìá¸ß²éѯµÄËÙ¶È¡£Ïà·´£¬Ôö¼ÓÁËϵͳά»¤Ê±¼äºÍÕ¼ÓÃÁËϵͳ¿Õ¼ä¡£Õâ¼òÖ±¾ÍÊǰáÆðʯͷÔÒ×Ô¼ºµÄ½Åѽ¡£
ÁíÍ⣬ÈçÉÏÃæµÄÔ±¹¤ÐÅÏ¢±í£¬ÓÐЩ×Ö¶ÎÖØ¸´Öµ±È½Ï¶à¡£ÈçÐÔ±ð×Ö¶ÎÖ÷Òª¾ÍÊÇ“ÄД¡¢“Å®”;ְλ×Ö¶ÎÖÐÒ²ÊÇÓÐÏ޵öÄÚÈÝ¡£´Ëʱ£¬ÔÚÕâЩ×Ö¶ÎÉÏÌí¼ÓË÷ÒýÒ²²»»áÏÔÖøµÄÔö¼Ó²éѯËÙ¶È£¬¼õÉÙÓû§ÏìӦʱ¼ä¡£
Ïà¹ØÎĵµ£º
ÈçºÎÔ¶³ÌÅжÏOracleÊý¾Ý¿âµÄ°²×°Æ½Ì¨
¡¡¡¡select * from v$version;
¡¡¡¡²é¿´±í¿Õ¼äµÄʹÓÃÇé¿ö
¡¡¡¡select sum(bytes)/(1024*1024) as free_space,tablespace_name
¡¡¡¡from dba_free_space
¡¡¡¡group by tablespace_name;
¡¡¡¡SELECT A.TABLESPACE_NAME,A.BYTES TOTAL,B.BYTES ......
//--Ìí¼Ó·þÎñÆ÷
EXEC sp_addlinkedserver
@server='LQXLSJ-600A5A60',--±»·ÃÎʵķþÎñÆ÷±ðÃû
@srvproduct='',
@provider='SQLOLEDB',
@datasrc='LQXLSJ-600A5A60' --Òª·ÃÎ ......
--> Title : SQL ServerÊÓͼÖг£見ÏÞÖÆÌõ¼þ
--> Author : wufeng4552
--> Date : 2010-03-01
(1): ÊÓͼÊý¾Ý¸ü¸ÄµÄ³£見ÏÞ¶¨
µ±Óû§¸üÐÂÊÓͼÖеÄÊý¾Ýʱ,Æäʵ¸ü¸ÄµÄÊÇÆä¶ÔÓ¦µÄÊý¾Ý±íµÄÊý¾Ý.ÎÞÂÛÊǶÔÊÓͼÖеÄÊý¾Ý½øÐиü¸Ä,»¹ÊÇÔÚÊÓͼÖвåÈë»òÕßɾ³ýÊý¾Ý,¶¼ÊÇÀàËÆµÄµÀÀí.µ«ÊÇ,² ......
MSSQL»¹ÔÊý¾Ý¿âʧ°Ü£¬ÌáʾÈçÏ£º »¹Ô¶ÔÓë·þÎñÆ÷ ʧ°Ü¡£(Microsoft.SqlServer.Smo) ÆäËüÐÅÏ¢£º ©§ ©»¡úÖ´ÐÐTransact-SQLÓï¾ä»òÅú´¦Àíʱ·¢ÉúÒì³£¡££¨Microsoft.SqlServer.ConnectionsInfo£© ©§ ©»¡ú²»ÄÜÑ¡ÔñÎļþ»òÎļþ×é¡°¡¡¡±ÓÃÓڴ˲Ù×÷¡£ RESTORE DATABASE ÕýÔÚÒì³£ÖÕÖ¹¡££¨Microsoft SQL Server, ´íÎó£º3219£© ³öÏÖ´Ë ......
Ò»°ãʹÓÃSQL ServerµÄ¼¯³ÉÈÏ֤ʱ£¬¶¼ÐèÒªµÇ½½øÓò£¬ÏÂÃæ½éÉÜÒ»ÖÖ²»ÐèÒªµÇ½Óò¾Í¿ÉÒÔʹÓÃÓòÓû§µÇ½SQL ServerµÄ·½·¨¡£
SQL Server Management Studio 2005ºÍ2008µÄ¿ì½Ý·½Ê½ÈçÏÂͼ£º
SQL Server 2008 x64: "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"
SQL ......