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
Ïà¹ØÎĵµ£º
1.Ó¦¾¡Á¿±ÜÃâÔÚ where ×Ó¾äÖжÔ×ֶνøÐÐ null ÖµÅжϣ¬·ñÔò½«µ¼ÖÂÒýÇæ·ÅÆúʹÓÃË÷Òý¶ø½øÐÐÈ«±íɨÃ裬È磺
select id from t where num is null
¿ÉÒÔÔÚnumÉÏÉèÖÃĬÈÏÖµ0£¬È·±£±íÖÐnumÁÐûÓÐnullÖµ£¬È»ºóÕâÑù²éѯ£º
select id from t where num=0
2.Ó¦¾¡Á¿±ÜÃâÔÚ where ×Ó¾äÖÐʹÓÃ!=»ò<>²Ù×÷·û£¬·ñÔò½«ÒýÇæ·ÅÆúÊ ......
SQLÓÅ»¯²éѯ
ÊÕ²Ø
Êý¾Ý¿âµÄ²éѯÓÅ»¯¼¼Êõ
Êý¾Ý¿âϵͳÊǹÜÀíÐÅϢϵͳµÄºËÐÄ£¬»ùÓÚÊý¾Ý¿âµÄÁª»úÊÂÎñ´¦Àí£¨OLTP£©ÒÔ¼°Áª»ú·ÖÎö´¦Àí(OLAP)ÊÇÒøÐС¢ÆóÒµ¡¢Õþ¸®µÈ²¿ÃÅ×îΪÖØÒªµÄ¼ÆËã»úÓ¦
ÓÃÖ®Ò»¡£´Ó´ó¶à ......
×òÍí£¬µ½Î¢Èí¹Ù·½ÏÂÁËÒ»¸ö32°æ±¾µÄTrial°æ±¾¡£ÎļþÃûΪSQLFULL_x86_ENU.exe¡£Îļþ´óСΪ1.30G×óÓÒ¡£ÒòΪֻÓÐ32λһ¸ö°æ
±¾£¬±ÈSQL Server 2008ÄǸö3GµÄҪС¶àÁË¡£ºÇºÇ¡£
http://www.microsoft.com/sqlserver/2008/en/us/R2Downloads.aspx
ÏÂ
ÔØÍê³Éºó£¬ÏÈжÔØÔÀ´µÄSQL Server 2008¡¡sp2,½á¹ûÕûÕûÔËÐÐÁËÁ½¸ ......
ÕâÊÇCSDNÂÛ̳ÀïÃæµÄÒ»¸öÌû×Ó£¬×÷ÕßÊÇ°®Ð¾õÂÞ.ع»ª¡£¸Ð¾õ±È½ÏÈ«Ã棬¾ÍÕûÀíÏÂÀ´ÁË£¬Áô×÷ÒÔºó²Î¿¼±¸Óá£ÔÚ´Ë£¬Ôڴ˸Ðл±¾ÎĵÄ×÷Õß¡£
/*
±êÌ⣺һ¸öÏîÄ¿Éæ¼°µ½µÄ50¸öSqlÓï¾ä(ÕûÀí°æ)
×÷Õߣº°®Ð¾õÂÞ.ع»ª(Ê®°ËÄê·çÓ꣬ÊصñùɽѩÁ«»¨¿ª)
ʱ¼ä£º2010-05-10
µØµã£ºÖØÇ캽ÌìְҵѧԺ
˵Ã÷£ºÒÔÏÂÎåÊ®¸öÓï¾ä¶¼°´ÕÕ²âÊÔÊý¾Ý½øÐ ......
SQL Server 2005 ºÍ2008ÌṩÁ˺ܶàеĺÍÔöÇ¿µÄÉÌÎñÖÇÄܹ¦ÄÜ,°üÀ¨ÀûÓü¯³É·þÎñ(SSIS)ÕûºÏ¶àÖÖÊý¾ÝÔ´;ÀûÓ÷ÖÎö·þÎñ(SSAS)ʹÊý¾ÝÄÚÈݸü·á¸»²¢ÇÒ½¨Á¢¸´ÔÓµÄÉÌÒµ·ÖÎö; ÒÔ¼°ÀûÓñ¨±í·þÎñ(SSRS)±à¼,¹ÜÀí,ºÍÌá½»·á¸»µÄ±¨±í. Èç¹ûÄãÏÖÔÚ»¹²»Çå³þÕâЩ¹¦ÄÜ,ÄÇô½ÓÏÂÀ´Ò»ÏµÁеĽéÉÜ»áÈÃÄã¶ÔSQL ServerÏÖÔÚµÄÉÌÎñÖÇÄÜÖ§³Ö´ó³ÔÒ»¾ª.²»¹ý ......