SQL SERVER DBCCÃüÁî½âÊÍ
SQL SERVER DBCCÃüÁî½âÊÍ
°ËµãÖÓÆð´²Ò»Ö±¸ãµ½ÏÖÔÚ£¬ºÃ¶à»¹²»Ì«¼ÇµÃ£¬ÏÈ·ÅÉÏÀ´ÒÔºóÂýÂýÐÞ¸Ä
2007-05-01 12:56:28
---------------------
--1 dbcc trraceon DBCC TRACEOFF
--¶ÔÓÚÊý¾Ý¿âËÀËø£¬Í¨³£¿ÉÒÔͨ¹ýTRACE FLAG 1204¡¢1205¡¢1206£¬¼ì²éERRORLOGÀïÃæµÄÊä³ö£¬ºÍ·ÖÎöSQLTRACEµÄÖ´ÐÐÉÏÏÂÎÄÅжÏËÀËøÎÊÌâµÄÀ´ÓÉ¡£
--TRACEONº¯ÊýµÄµÚÈý¸ö²ÎÊýÉèÖÃΪ-1£¬±íʾ²»µ¥µ¥Õë¶Ôµ±Ç°connection£¬
--¶øÊÇÕë¶ÔËùÓаüÀ¨Î´À´½¨Á¢µÄconnection¡£ÕâÑù£¬²Å¹»ÍêÈ«£¬·ñÔòÖ»ÊǼàÊÓµ±Ç°ÒѾ½¨Á¢µÄÊý¾Ý¿âÁ¬½ÓÁË¡£
--Ö´ÐÐÏÂÃæµÄ»°¿ÉÒÔ°ÑËÀËø¼Ç¼µ½ErrorlogÖУº
dbcc traceon (1204, 3605, -1)
go
dbcc tracestatus(-1)
go
--˵Ã÷£º
--260£º´òÓ¡¹ØÓÚÀ©Õ¹´æ´¢¹ý³Ì¶¯Ì¬Á´½Ó¿âµÄ°æ±¾ÐÅÏ¢
--444£ºÍ£Ö¹auto-parameterization
--1200£ºÊä³öËøÐÅÏ¢
--1204£º´«»Ø²ÎÓëËÀËøµÄSQL SERVERÏà¹Ø³ÌÐòÖ®ÔËÐÐÊý¾Ý
--1211£ºÍ£Ö¹lock escalation£¨ËøÉý¼¶£©
--1252£ºÏÔʾ¶¯Ì¬Ñ¡ÔñËøµÄÏà¹ØÐÅÏ¢
--2528£ºÍ¨¹ý DBCC CHECKDB¡¢DBCC CHECKFILEGROUP ºÍ DBCC CHECKTABLE ½ûÓöÔÏóµÄ²¢Ðмì²é¡£
--ĬÈÏÇé¿öÏ£¬²¢ÐжÈÓɲéѯ´¦ÀíÆ÷×Ô¶¯È·¶¨¡£×î´ó²¢ÐжȵÄÅäÖ÷½Ê½Óë²¢ÐвéѯÏàͬ¡£
--Óйظü¶àÐÅÏ¢£¬Çë²Î¼û max degree of parallelism Ñ¡Ïî¡£
-- ͨ³£Çé¿öÏ£¬Ó¦½«²¢ÐÐ DBCC ±£ÁôΪÆôÓÃ״̬¡£Ö´ÐÐ DBCC CHECKDB ʱ£¬
-- ²éѯ´¦ÀíÆ÷ÖØÐÂÆÀ¹ÀºÍ×Ô¶¯µ÷Õû²¢Ðжȣ¬²¢¼ì²éÿ¸ö±í»òÒ»Åú±í¡£
--ÓÐʱ£¬¼ì²é¿ÉÄÜÔÚ·þÎñÆ÷´¦ÓÚʵ¼Ê¿ÕÏÐ״̬ʱ½øÐС£Èç¹û¹ÜÀíÔ±ÖªµÀÔÚ¼ì²é½áÊøÇ°¸ººÉ½«¼Ó´ó£¬
--¿ÉÄÜÏ£ÍûÊÖ¹¤¼õС»ò½ûÓò¢Ðжȡ£
-- µ«ÊÇ£¬½ûÓò¢Ðмì²é»áµ¼ÖÂÊý¾Ý¿âµÄ×ÜÌåÐÔÄܽµµÍ¡£½µµÍ²¢ÐжȽ«Ôö¼Ó±ØÐëɨÃèµÄÊÂÎñÈÕÖ¾Á¿¡£
--Õâ·´¹ýÀ´Ôö¼ÓÁË¶Ô tempdb ¿Õ¼äµÄÐèÇ󣬲¢µ¼Ö dbcc Íê³É¼ì²éËùÐèµÄʱ¼ä·ÇÏßÐÔÔö¼Ó¡£
--Èç¹ûÔËÐÐ DBCC ʱÆôÓÃÁË TABLOCK ¹¦Äܲ¢¹Ø±ÕÁ˲¢Ðжȣ¬Ôò±í¿ÉÄܱ»Ëø¶¨¸ü³¤Ê±¼ä¡£
--3205£ºÄ¬ÈÏÇé¿öÏ£¬Èç¹û´Å´øÇý¶¯Æ÷Ö§³ÖÓ²¼þѹËõ£¬Ôò DUMP »ò BACKUP Óï¾ä»áʹÓøù¦ÄÜ¡£
-- ÀûÓô˸ú×Ù±ê¼Ç£¬¿ÉÒÔ½ûÓôŴøÇý¶¯³ÌÐòµÄÓ²¼þѹËõ¡£
-- ±¾ÏîÔÚÒªÓë²»Ö§³ÖѹËõµÄÆäËüÕ¾µã»ò´Å´øÇý¶¯Æ÷½»»»´Å´øʱÓÐÓá£
--3604£
Ïà¹ØÎĵµ£º
×öÊý¾Ý¿â¿ª·¢»ò¹ÜÀíµÄÈ˾³£Òª´´½¨´óÁ¿µÄ²âÊÔÊý¾Ý£¬¶¯²»¶¯¾ÍÐèÒªÉÏÍòÌõ£¬Èç¹ûÒ»ÌõÒ»ÌõµÄ¼È룬ÄÇ»áÀË·Ñ´óÁ¿µÄʱ¼ä£¬±¾ÎĽéÉÜÁËOracleÖÐÈçºÎͨ¹ýÒ»ÌõSQL¿ìËÙÉú³É´óÁ¿µÄ²âÊÔÊý¾ÝµÄ·½·¨¡£
²úÉú²âÊÔÊý¾ÝµÄSQLÈçÏ£º
SQL> select rownum as id,
2 &nbs ......
SQL ODBC connection strings
Standard Security:< br> "Driver={SQLServer};Server=Your_Server_Name;Database=Your_Database_Name;Uid=Your_Username;Pwd=Your_Password;"
Trusted connection:< br> "Driver={SQLServer};Server=Your_Server_Name;Database=Your_Database_Name;Trusted_Connection=yes;"
......
1.Óû§¹ÜÀí
£¨1£©½¨Á¢Óû§£¨Êý¾Ý¿âÑéÖ¤£©
CREATE USER smith
IDENTIFIED BY smith_pwd
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp
QUOTA 5m ON users;
£¨2£©ÐÞ¸ÄÓû§
ALTER USER smith
QUOTA 0 ON SYSTEM;
£¨3£©É¾³ýÓû§
DROP USER smith;
DROP USER ......
1. ¶¨ÒåÓα궨Òå
ÓαêÓï¾äµÄºËÐÄÊǶ¨ÒåÁËÒ»¸öÓαê±êʶÃû£¬²¢°ÑÓαê±êʶÃûºÍÒ»¸ö²éѯÓï¾ä¹ØÁªÆðÀ´¡£DECLAREÓï¾äÓÃÓÚÉùÃ÷Óα꣬Ëüͨ¹ýSELECT²éѯ¶¨ÒåÓαê´æ´¢µÄÊý¾Ý¼¯ºÏ¡£Óï¾ä¸ñʽΪ£º
DECLARE ÓαêÃû³Æ [INSENSITIVE] [SCROLL]
CURSOR FOR selectÓï¾ä
[FOR{READ ONLY|UPDATE[OF ÁÐÃû×Ö±í]}]
²ÎÊý˵Ã÷£º
INSENSITIVEÑ¡Ï ......