Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SAP ʹÓÃSQL Trace£¨ST05£©

SAP ʹÓÃSQL Trace£¨ST05£©
SAP R/3 Ìṩ±ê×¼ABAP SQL ¸ú×Ù¹¤¾ß¡£Ê¹ÓÃT-Code:ST05 ¿ÉÒÔ½øÈë×·×ÙÉ趨»­Ã棺
 
         ÔÚTrace Modes ÇøÓòÖÐÑ¡ÔñÐèÒªÔÚSAP R/3 Server ÉÏtrace µÄ·¶Î§£º
         SQL Trace: ×·×Ù¸ÃAP Server ÉÏÒѹýÂ˵ÄSQL Óï¾ä¡£
         Enqueue Trace: ×·×ÙEnqueue Server ÉϵĶÓÁС£
         RFC Trace: ×·×Ù¸ÃAP Server ÉÏRFC ÐÐΪ¡£
         Buffer Trace: ×·×Ù¸ÃAP Server ÉÏBuffer ÖеÄÐÐΪ¡£
 
         ÕâÀïÈôҪ׷×ÙSQL ÔòֻҪѡÖÐSQL Trace¡£È»ºóÔÚTrace Requests ÇøÓòÖеãÑ¡ Trace on with Filter ½øÐÐÊä³ö¹ýÂË:
 
 
 
         ÕâÀï½ö×·×ÙSBA Õ˺ŶÔÓÚMB03 ËùÓеÄSQL²Ù×÷¡£Ò²¿ÉÒÔÌîÈë³ÌÐòÃû³ÆÉõÖÁAP Server ÉϵĽø³Ì´úºÅÀ´×·×Ù¡£»¹¿ÉÒÔÔÚTable name ÇøÓòÑ¡¶¨°üº¬/ÅųýµÄ±íÃû¡£µã»÷¶Ô¹³Ö®ºó¼´Æô¶¯×·×Ù¡£
 
         ÔÚÐèÒª²é¿´×·×Ù½á¹ûʱÐèÒªÏÈÍ£Ö¹×·×Ù(Trace off) È»ºóÔÙµã»÷Display trace ÏÔʾÈçÏ£º
 
 
          ÐèÒªÖØÐ¶Խá¹û½øÐйýÂË£¨ÒòΪSAP R/3Ö»ÓÐÒ»¸ö»òÁ½¸öLog Îļþ£¬ÏµÍ³²»»á×Ô¶¯·Ö½â¶ÔÓ¦³ÌÐòµÄLog ÐÅÏ¢£©¡£Trace modes ֻѡÔñSQL Trace ¡£SQL Trace Period ϵͳÒÑ×Ô¶¯ÉèÖúÃÎÞÐè¸ü¸Ä¡£User name ¿ÉÒÔ×ÔÐÐÉ趨£¬ÕâÀïÉ趨¿ÕÖµ±íʾÈκÎÕ˺ţ¨ÒòΪ¿ªÊ¼×·×Ùʱ½ö¹ýÂËÒ»¸öÕ˺ţ¬ËùÒÔÕâÀïÎÞÐè½øÒ»²½¹ýÂË£©¡£Objectname ±£ÁôϵͳÉ趨£¨ÕâÑù¿ÉÒÔÅųý×·×ÙLog ±¾ÉíËù²úÉúµÄLog ÐÅÏ¢£©¡£
         Duration: Ö´ÐÐÕâÌõ²Ù×÷ËùÏûºÄµÄʱ¼ä£¬µ¥Î»ÊÇ΢Ãë¡£1΢Ãë=1£¯1000000Ãë¡£
         Objectname: ָʾ¸ÃÌõ²Ù×÷µÄ¶ÔÏ󣬶ÔÓÚSQL Trace Ò»°ã¾ÍÊÇTable name¡£
         Op.: ָʾ¸ÃÌõ²Ù×÷µÄÀàÐÍ¡£ÆäÖжÔÓ¦OPENµÄÌõÄ¿¶ÔSQL ÐÔÄܾßÓкܴóµÄ²Î¿¼¼ÛÖµ¡£
   &nbs


Ïà¹ØÎĵµ£º

SQLÓÅ»¯( ÒýÓà )



 
SQLÓÅ»¯²éѯ
ÊÕ²Ø



Êý¾Ý¿âµÄ²éѯÓÅ»¯¼¼Êõ
Êý¾Ý¿âϵͳÊǹÜÀíÐÅϢϵͳµÄºËÐÄ£¬»ùÓÚÊý¾Ý¿âµÄÁª»úÊÂÎñ´¦Àí£¨OLTP£©ÒÔ¼°Áª»ú·ÖÎö´¦Àí(OLAP)ÊÇÒøÐС¢ÆóÒµ¡¢Õþ¸®µÈ²¿ÃÅ×îÎªÖØÒªµÄ¼ÆËã»úÓ¦
ÓÃÖ®Ò»¡£´Ó´ó¶à ......

¹¦ÄÜÇ¿´óµÄSQLÓï¾ä

1. ¸´ÖƱí½á¹¹
Sql´úÂë
   1. select * into B from A where 1=0;   
select * into B from A where 1=0;
 2.¸´ÖƱí¼Ç¼ ¸´ÖÆÄ³Ð©×Ö¶Î
Sql´úÂë
   1. insert into B(a, b, c) select d, e, f from A;   
insert into B(a, b, c) select d, e, f from A;
  ¸´Ö ......

SQLËÙ²éÊÖ²á

Ò»¡¢»ù´¡
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname
3¡¢ËµÃ÷£º±¸·Ýsql server
--- ´´½¨ ±¸·ÝÊý¾ÝµÄ device
USE master
EXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind_1.dat'
--- ¿ªÊ¼ ±¸·Ý
BACKUP DATABASE pubs TO testBac ......

SQL Server 2005µ¼Èëµ¼³ö´æ´¢¹ý³Ì

1. ¿ÉÒÔÓýű¾±¸·Ý
¡¡¡¡manger studio--ÓÒ¼üÄãµÄÊý¾Ý¿â--ÈÎÎñ--Éú³É½Å±¾
¡¡¡¡Ôڽű¾Éú³ÉÏòµ¼µÄ"Ñ¡Ôñ¶ÔÏóÀàÐÍ"²½ÖèÖÐ, ½«"´æ´¢¹ý³Ì"Ñ¡ÉÏ, ÔÚ½ÓÏÂÀ´µÄ"Ñ¡Ôñ´æ´¢¹ý³Ì"µÄ²½ÖèÖÐ, Ñ¡ÔñËùÓеĴ洢¹ý³Ì(»òÕßÄãÒª¸´ÖƵĴ洢¹ý³Ì)
¡¡¡¡Íê³Éºó, ËùÓд洢¹ý³ÌµÄ½Å±¾»áÉú³ÉÔÚÒ»¸öеIJéѯ´°¿ÚÖÐ, ¹ØµôÉú³É½Å±¾Ïòµ¼, ÔÚÉú³ÉµÄ´æ´¢¹ý³Ì ......

VS2010Öд´½¨×Ô¶¨ÒåSQL Rule£¨ºÂÏÜç⣩

VS2010ÒѾ­·¢²¼¼¸Ììʱ¼äÁË£¬Ò»Ð©ÐµÄÌØÐÔÌØ±ðÒýÈËעĿ£¬±ÈÈ磺 ÐÔÄܵÄÎȶ¨ºÍÌáÉý£¬±íÏÖÔÚWPF GUIºÍWPFÎı¾³ÊÏÖ¡£ Windows Azure ToolsÄ£°å¡£ ¶àÏÔʾÆ÷Ö§³Ö£¬Êä³ö´°¿Ú£¬Ààͼ´°¿Ú£¬´úÂ붨Òå´°¿ÚµÈÌṩ¸¨ÖúÐÅÏ¢µÄ´°¿Ú·ÅÖÃÔÚ¸±ÏÔʾÆ÷ÖС£ ¶Ô²¢ÐмÆË㿪·¢µÄ´óÁ¿Ö§³Ö¡£ °üº¬ÁËSharePointµÄÏîĿģ°åºÍµ÷ÊÔÖ§³Ö ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ