Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ServerÓÅ»¯¶þ

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ÓÅ»¯( ÒýÓà )



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



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

SQL Server 2008 r2 °²×°¹ý³Ì¼Ç¼

×òÍí£¬µ½Î¢Èí¹Ù·½ÏÂÁËÒ»¸ö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,½á¹ûÕûÕûÔËÐÐÁËÁ½¸ ......

Ò»¸öÏîÄ¿ÖÐÓõ½µÄ50¸öSQLÓï¾ä

ÕâÊÇCSDNÂÛ̳ÀïÃæµÄÒ»¸öÌû×Ó£¬×÷ÕßÊÇ°®Ð¾õÂÞ.ع»ª¡£¸Ð¾õ±È½ÏÈ«Ã棬¾ÍÕûÀíÏÂÀ´ÁË£¬Áô×÷ÒÔºó²Î¿¼±¸Óá£ÔÚ´Ë£¬Ôڴ˸Ðл±¾ÎĵÄ×÷Õß¡£
/*
±êÌ⣺һ¸öÏîÄ¿Éæ¼°µ½µÄ50¸öSqlÓï¾ä(ÕûÀí°æ)
×÷Õߣº°®Ð¾õÂÞ.ع»ª(Ê®°ËÄê·çÓ꣬ÊصñùɽѩÁ«»¨¿ª)
ʱ¼ä£º2010-05-10
µØµã£ºÖØÇ캽ÌìְҵѧԺ
˵Ã÷£ºÒÔÏÂÎåÊ®¸öÓï¾ä¶¼°´ÕÕ²âÊÔÊý¾Ý½øÐ ......

SQL Server BI Step by Step SSIS 1 ×¼±¸

SQL Server 2005 ºÍ2008ÌṩÁ˺ܶàеĺÍÔöÇ¿µÄÉÌÎñÖÇÄܹ¦ÄÜ,°üÀ¨ÀûÓü¯³É·þÎñ(SSIS)ÕûºÏ¶àÖÖÊý¾ÝÔ´;ÀûÓ÷ÖÎö·þÎñ(SSAS)ʹÊý¾ÝÄÚÈݸü·á¸»²¢ÇÒ½¨Á¢¸´ÔÓµÄÉÌÒµ·ÖÎö; ÒÔ¼°ÀûÓñ¨±í·þÎñ(SSRS)±à¼­,¹ÜÀí,ºÍÌá½»·á¸»µÄ±¨±í. Èç¹ûÄãÏÖÔÚ»¹²»Çå³þÕâЩ¹¦ÄÜ,ÄÇô½ÓÏÂÀ´Ò»ÏµÁеĽéÉÜ»áÈÃÄã¶ÔSQL ServerÏÖÔÚµÄÉÌÎñÖÇÄÜÖ§³Ö´ó³ÔÒ»¾ª.²»¹ý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ