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ÌṩÁËËÄÖÖÄ£ºýÆ¥Å䷽ʽ
1£¬%£º±íʾÈÎÒâ0¸ö»ò¶à¸ö×Ö·û¡£¿ÉÆ¥ÅäÈÎÒâÀàÐͺͳ¤¶ÈµÄ×Ö·û£¬ÓÐЩÇé¿öÏÂÈôÊÇÖÐÎÄ£¬ÇëÔËÓÃÁ½¸ö°Ù·ÖºÅ£¨%%£©±íʾ¡£
±ÈÈç SELECT * from [user] WHERE u_name LIKE '%Èý%'
½«»á°Ñu_nameΪ“ÕÅÈý”£¬“ÕÅèÈý”¡¢“Èý½Å蔣¬“ÌÆÈý²Ø”µÈµÈÓГÈý& ......
ÕâÊÇCSDNÂÛ̳ÀïÃæµÄÒ»¸öÌû×Ó£¬×÷ÕßÊÇ°®Ð¾õÂÞ.ع»ª¡£¸Ð¾õ±È½ÏÈ«Ã棬¾ÍÕûÀíÏÂÀ´ÁË£¬Áô×÷ÒÔºó²Î¿¼±¸Óá£ÔÚ´Ë£¬Ôڴ˸Ðл±¾ÎĵÄ×÷Õß¡£
/*
±êÌ⣺һ¸öÏîÄ¿Éæ¼°µ½µÄ50¸öSqlÓï¾ä(ÕûÀí°æ)
×÷Õߣº°®Ð¾õÂÞ.ع»ª(Ê®°ËÄê·çÓ꣬ÊصñùɽѩÁ«»¨¿ª)
ʱ¼ä£º2010-05-10
µØµã£ºÖØÇ캽ÌìְҵѧԺ
˵Ã÷£ºÒÔÏÂÎåÊ®¸öÓï¾ä¶¼°´ÕÕ²âÊÔÊý¾Ý½øÐ ......
ÓÉÓÚÖÖÖÖÔÒò£¬ÎÒÃÇÈç¹ûµ±Ê±½ö½ö±¸·ÝÁËmdfµµ£¬ÄÇô»Ö¸´ÆðÀ´¾ÍÊÇÒ»¼þºÜÂé·³µÄÊÂÇéÁË¡£
Èç¹ûÄúµÄmdfµµÊǵ±Ç°×ÊÁÏ¿â²úÉúµÄ£¬ÄÇôºÜ½ÄÐÒ£¬Ò²ÐíÄãʹÓÃsp_attach_db»òÕßsp_attach_single_file_db¿ÉÒÔ»Ö¸´×ÊÁϿ⣬µ«ÊÇ»á³öÏÖÀàËÆÏÂÃæµÄÌáʾ×ÊѶ
É豸Æô¶¯´íÎó¡£ÎïÀíµµ°¸Ãû 'C:\Program Files\Microsoft SQL S ......