Sql Server Êý¾Ý¿âÁ¬½ÓÎÊÌâ
²Î¿¼ÎÄÏ×£ºhttp://www.cnblogs.com/chenxizhang/archive/2009/04/23/1441913.html
SQL ServerÌṩËÄÖÖ·½Ê½Á¬½ÓÊý¾Ý¿â·þÎñÆ÷:
1. share memory: Ö»ÊÊÓÃÓÚ¿Í»§¶ËºÍ·þÎñÆ÷¶ËÔÚͬһ̨»úÆ÷ÉÏ,²ÅÄܲÉÓõÄÁ¬½Ó
2. Named pipe:
ÔÚ¾ÖÓòÍø(LAN)ÄÚʵÏÖÁ¬½Ó,Ò»¸ö½ø³ÌʹÓÃÒ»²¿·ÖµÄÄÚ´æÀ´Ïò½ø³ÌµÄÁíÒ»¶Ë´«µÝÏûÏ¢,Ò»¸ö½ø³ÌµÄÊä³öÊÇÁíÍâÒ»¸ö½ø³ÌµÄÊäÈë.
3. TCP/IP: ÒòÌØÍøÉÏʹÓÃ,¿ÉÒÔÓÃÓÚ²»Í¬µÄÓ²¼þÌåϵ½á¹¹ºÍ²Ù×÷ϵͳµÄ¼ÆËã»úÍøÂçÖ®¼ä½øÐÐͨÐÅ(¶Ë¿ÚºÅ)
4. VIA:ÐéÄâ½Ó¿ÚÊÊÅäÆ÷£¬ÓëÒ»ÖÖÌØ¶¨Ó²¼þÒ»ÆðʹÓõÄרÃÅ»¯µÄÐÒ飬ÖÁ½ñûÓÐÓùý¡£¡£¡£¡£
µ±ÎÒÃÇʹÓÿͻ§¶ËÃüÁîÐй¤¾ßÈçsqlcmd.exe½øÐзÃÎÊʱ£¬²ÉÓÃÈçϵÄ˳Ðò½øÐнâÎö£º
Ê×ÏÈ£¬»áʹÓÃsqlcmd.exe ÃüÁîÐй¤¾ßÊäÈëµÄÁ¬½Ó×Ö·û´®ËùÃèÊöµÄÐÒé½øÐÐÁ¬½Ó
Æä´Î£¬Èç¹ûÔÚsqlcmd.exeÃüÁîÐÐûÓÐÃèÊöÓйصÄÐÒ飬Ôò²ì¿´¿Í»§¶ËÅäÖùÜÀíÆ÷Ïà¹ØµÄ±ðÃûÉèÖÃÖÐËùÃèÊöµÄÐÅÏ¢½øÐÐÁ¬½Ó
×îºó£¬Èç¹ûÔÚ±ðÃûÐÅÏ¢ÖÐûÓÐÌṩÏà¹ØµÄÉèÖÃÐÅÏ¢£¬Ôò»á¸ù¾Ý¿Í»§¶ËÉèÖõÄÐÒéµÄ˳Ðò£¬ÒÀ´Î³¢ÊÔÓë·þÎñÆ÷¶Ë½øÐÐÁ¬½Ó¡£
ÏÂÃæ½éÉÜÕâËÄÖÖ·½Ê½µÄÁ¬½ÓÃüÁ
ĬÈÏÇé¿öÏ£¬ÎÒÃÇÒ»°ãÓÃÈçÏÂÃüÁî½øÐÐÁ¬½Ó£º
sqlcmd -S HT-WINSERVER1 ----Á¬½ÓĬÈÏʵÀý
sqlcmd -S HT-WINServer1\mssql2k5 ----Á¬½Ó¸Ã·þÎñÆ÷ÉϵķÇĬÈÏʵÀý
sqlcmd -S 172.16.15.233
sqlcmd -S 172.16.15.233\mssql2k5
sqlcmd -S 172.16.15.233,1121 ----²ÉÓö˿ںŵÄÐÎÊÆ½øÐÐÁ¬½ÓÃüÃûʵÀý
sqlcmd -S 172.16.15.233,1433 ----²ÉÓö˿ںŵÄÐÎÊÆ½øÐÐĬÈÏʵÀý
sqlcmd -S HT-WINSERVER1,1121 ----²ÉÓö˿ںŵÄÐÎÊÆ½øÐÐÁ¬½ÓÌØ¶¨µÄÃüÃûʵÀý
ͨ¹ýÖ¸¶¨ÐÒéµÄ·½Ê½½øÐÐÁ¬½Ó(ÏÂÃæÊäÈëIPµÄµØ·½¶¼¿ÉÒÔÓÉ·þÎñÆ÷Ãû´úÌæ)£º
sqlcmd -S tcp£º172.16.15.233\mssql2k5, 1121 ----²ÉÓÃtcp/ip·½Ê½Á¬½Ó
sqlcmd -S tcp:172.16.15.233,1121
sqlcmd -S np:\\172.16.15.233\pipe\sql\query
-----²ÉÓÃÃüÃû¹ÜµÀ·½Ê½Á¬½Ó
sqlcmd -S np:\\172.16.15.233\pipe\MSSQL$mssql2k5\sql\query
sqlcmd -S
lpc:\172.16.15.233\mssql2k5
-----²ÉÓù²ÏíÄڴ淽ʽÁ¬½Ó
sqlcmd -S via:<computer
name>,<port
num>,<NIC number>
----ʹÓÃVIA·½Ê½Á¬½Ó
ÔÚSQL ServerÁ¬½ÓµÄ¹ý³ÌÖУ¬ÓÐʱÎÒÃÇͨ²Å²ÉÓò»ÊäÈë¶Ë¿ÚºÅµÄ·½Ê½½øÐÐÁ¬½Ó£¬Õâʱ¾ÍÐèÒªÒ»¸ö·þÎñÊÇÆô¶¯µÄ£¬¼´SQL Server
Browser£º
ÔÀí£º
Æô¶¯Ò»¸ö SQL Server ʵÀýºó£¬Èç¹ûΪ
SQL Server ÆôÓÃÁË TCP/IP »ò VIA ÐÒ飬·þÎñÆ÷
Ïà¹ØÎĵµ£º
1£®OracleΪ¿Í»§¶Ë¿ªÆô»á»°ÓÐÁ½ÖÖ·½Ê½£º¹²Ïí·þÎñºÍרÓ÷þÎñ¡£ÔÚרÓ÷þÎñÇé¿öÏ£¬¼àÌýÆ÷ΪÁ¬½ÓÇëÇó´´½¨Ð½ø³Ì£¨Unix»·¾³ÏÂÊÇProcess£¬WindowsÏÂÎÒÏëÓ¦¸ÃÊÇThread°É£©£»¹²Ïí·þÎñÇé¿öÏ£¬¼àÌýÆ÷½«¿Í»§ÇëÇ󽻸øDispatcher£¬ÓÉDispatcher°²ÅŶà¿Í»§µÄ×÷Òµ¡£SQL ServerÔÚĬÈÏÇé¿öÏÂ×Ô¶¯Îª¿Í»§¶ËÁ¬½Ó´´½¨Ị̈߳¬µ±Óзdz£¶àµÄ¿Í ......
×Ö·ûÀàÐÍ
Char: ¶¨³¤·ÇUnicodeµÄ×Ö·ûÐÍÊý¾Ý£¬×î´ó³¤¶ÈΪ8000
Varchar:±ä³¤·ÇUnicodeµÄ×Ö·ûÐÍÊý¾Ý£¬×î´ó³¤¶ÈΪ8000
Text(varchar(max)):±ä³¤·ÇUnicodeµÄ×Ö·ûÐÍÊý¾Ý£¬×î´ó³¤¶ÈΪ2G
Nchar:¶¨³¤UnicodeµÄ×Ö·ûÐÍÊý¾Ý£¬×î´ó³¤¶ÈΪ8000
Nvarchar:±ä³¤UnicodeµÄ×Ö·ûÐÍÊý¾Ý£¬×î´ó³¤¶ÈΪ8000
Ntext(nvarchar(max)):± ......
db2 µ÷ÓÃsql½Å±¾³£ÓÃÃüÁdb2 -tf d:\creat_table.sql Óë db2 -td$ -f d:\creat_table.sql
db2 -tf d:\creat_table.sql µ÷Óýű¾ÃüÁîÊÇddl²Ù×÷
µ±Óöµ½sqlÓï¾ä¹ý³¤£¬»òÌáʾ DB21007E ¶ÁÈ¡¸ÃÃüÁîʱÒѵ½´ïÎļþĩβ¡£¾ÍʹÓà db2 -td$ -f d:\creat_table.sql ÃüÁî
ʹÓøÄÃüÁîÐèÒªÔÚsql½Å±¾ÖÐÒÔ$½áÊ ......
Using Oracle Trace Analyzer (trcanlzr.sql)
Dave Moore: Author of Oracle Utilities
Oracle has provided another utility initially designed for performance tuning Oracle Applications. Trace Analyzer is provided in the form of a PL/SQL package (TRCA$ ). The Trace Analyzer utility i ......