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

ÀûÓÃtypeperf¹¤¾ßÊÕ¼¯SQL ServerÐÔÄÜÊý¾Ý

Ò»£®ÀûÓÃTypePerf.exeÃüÁîÐй¤¾ß°ÑWindows²Ù×÷ϵͳµÄÐÔÄܼÆÊýÆ÷Êý¾Ý¼Ç¼µ½Êý¾Ý¿âÖÐ
 
¿ÉÒÔÔÚ×÷ÒµÖн¨Á¢ÒÔϽű¾
1.ÆôÓÃxp_cmdshell
--ĬÈÏÇé¿öÏÂ,sql server2005°²×°Íêºó,xp_cmdshellÊǽûÓõÄ(¿ÉÄÜÊǰ²È«¿¼ÂÇ),Èç¹ûҪʹÓÃËü,¿É°´ÒÔϲ½Öè
 
-- ÔÊÐíÅäÖø߼¶Ñ¡Ïî
EXEC sp_configure 'show advanced options', 1
GO
-- ÖØÐÂÅäÖÃ
RECONFIGURE
GO
-- ÆôÓÃxp_cmdshell
EXEC sp_configure 'xp_cmdshell', 1
GO
--ÖØÐÂÅäÖÃ
RECONFIGURE
GO
 
2.¶¨Ê±¿ªÆô,¿ªÊ¼¼Ç¼ÐÔÄܼÆÊýÆ÷ÈÕÖ¾
--ʵÏֵŦÄÜ£º½«“MyCounters.txt”ÎļþÖÐÁгöµÄ¼ÆÊýÆ÷£¬°´ÕÕÿÃëÖÓµÄʱ¼ä¼ä¸ô£¬¼Ç¼µ½SQLÊý¾Ý¿âÖÐ,"SQL:SystemLog!TestSystemLog"ΪODBCÊý¾ÝÔ´½¨Á¢µÄϵͳDSN
EXEC xp_cmdshell 'typeperf -cf c:\MyCounters.txt -si 5 -f SQL -o SQL:SystemLog!TestSystemLog'
 
--"MyCounters.txt"¿ÉÒÔÀûÓÃÏÂÃæµÄÃüÁîÔÚCMDÃüÁî´°¿ÚÖÐÖ´ÐкóÉú³É
TYPEPERF -qx "Processor" >>c:\MyCounters.txt
 
3. ¶¨Ê±¹Ø±Õ
--½áÊøtypeperf.exeµÄ½ø³Ì
EXEC xp_cmdshell 'tskill typeperf'
 
4.¹Ø±Õxp_cmdshell
--ÓÃÍêºó,Òª¼ÇµÃ½«xp_cmdshell½ûÓÃ(³öÓÚ°²È«¿¼ÂÇ)
-- ÔÊÐíÅäÖø߼¶Ñ¡Ïî
EXEC sp_configure 'show advanced options', 1
GO
-- ÖØÐÂÅäÖÃ
RECONFIGURE
GO
-- ½ûÓÃxp_cmdshell
EXEC sp_configure 'xp_cmdshell', 0
GO
--ÖØÐÂÅäÖÃ
RECONFIGURE
GO
 
5.ÀûÓÃÊý¾Ý¿âÖмǼµÄÈÕÖ¾·ÖÎöÐÔÄÜÊý¾Ý
 
¶þ£®´øÀ´µÄºÃ´¦£º
1.  ¿ÉÒÔ¸ù¾Ý¼Æ»®¶¨Ê±×¥È¡·þÎñÆ÷ÐÔÄÜÊý¾Ý°üÀ¨CPU¡¢ÄÚ´æºÍ´ÅÅÌÀûÓÃÂÊÒÔ¼°SQL ServerÌØ¶¨Êý¾Ý¡£ÎªÊý¾Ý¿â·þÎñÆ÷µÄÐÔÄÜ·ÖÎöÌṩ°ïÖú¡£
 
2.  ¿ÉÒÔ¸ù¾ÝÊý¾Ý¿âÖмǼµÄÈÕÖ¾½áºÏReporting Service»æÖÆÐÔÄÜ·ÖÎöµÄ±¨±í¡£
 
3.  ¿ÉÒÔ¶¨ÖÆ×÷ҵʵÏÖ×Ô¶¯»¯
 
 
Èý£®´øÀ´µÄÓ°Ï죺
1.  »áÔö¼Ó·þÎñÆ÷µÄ¸ºÔØ£¬ÔÚ²âÊÔʱ¹Û²ìÁËÒ»ÏÂÕâ¸öÃüÁîµÄ¿ªÏú£¬»ù±¾ÉÏÆô¶¯ºó8M×óÓÒµÄÄÚ´æÔËÐУ¬¿ªÏú±È½ÏС
 
ÁíÍ⣺Èç¹û¿¼ÂÇʵʩµÄ»°£¬¿ÉÒÔн¨Ò»¸öÊý¾Ý¿â£¨×¨ÃÅÓÃÓÚ¼à¿Ø·þÎñÆ÷ÐÔÄÜµÈµÄ±í£©£¬±ãÓÚά»¤ºÍ¹ÜÀí
0
0
0
(ÇëÄú¶ÔÎÄÕÂ×ö³öÆÀ¼Û)


Ïà¹ØÎĵµ£º

Ò»¸ö¶à±íǶÌײéѯµÄsqlÓï¾ä

select batch_no "Åú´ÎºÅ",get_id "·ÖÀà" from (
select(
select plan1.batch_no from product_plan plan1 where plan1.item_no=(select head1.product_code from wo_head head1 where head1.order_no =bbb)) batch_no, 
(select decode(get_id,'BUY','Í⹺¼þ','MAK','×ÔÖÆ¼þ','MB','䶨') from item where item_ ......

ÒÔ¿ìÕÕ¸´ÖÆÎªÀý SQL SERVER 2005 ͬ²½¸´ÖƼ¼Êõ

SQL SERVER 2005 ͬ²½¸´ÖƼ¼Êõ
ÒÔÏÂʵÏÖ¸´ÖƲ½Ö裨ÒÔ¿ìÕÕ¸´ÖÆÎªÀý£©
ÔËÐÐÆ½Ì¨SQL SERVER 2005
Ò»¡¢×¼±¸¹¤×÷£º
1£®½¨Á¢Ò»¸ö WINDOWS Óû§£¬ÉèÖÃΪ¹ÜÀíԱȨÏÞ£¬²¢ÉèÖÃÃÜÂ룬×÷Ϊ·¢²¼¿ìÕÕÎļþµÄÓÐЧ·ÃÎÊÓû§¡£
2£®ÔÚSQL SERVERÏÂʵÏÖ·¢²¼·þÎñÆ÷ºÍ¶©ÔÄ·þÎñÆ÷µÄͨÐÅÕý³££¨¼´¿ÉÒÔ»¥·Ã£©¡£´ò¿ª1433¶Ë¿Ú£¬ÔÚ·À»ðǽÖÐÉèÌØÀ ......

SQL²éѯ´ð°¸

Ò»¡¢µ¥±í²éѯÁ·Ï°
1¡¢²éѯ<ѧÉúÐÅÏ¢±í>£¬²éѯѧÉú"ÕÅÈý"µÄÈ«²¿»ù±¾ÐÅÏ¢
Select *
from A_studentinfo
where sname='ÕÅÈý'
 
2¡¢²éѯ<ѧÉúÐÅÏ¢±í>£¬²éѯѧÉú"ÕÅÈý"ºÍ”ÀîËÄ”µÄ»ù±¾ÐÅÏ¢
Select *
from A_studentinfo
where sname='ÕÅÈý'
or sname='ÀîËÄ'
 
3¡¢²éѯ<ѧÉú ......

SQL´¥·¢Æ÷Óï·¨²Î¿¼

ת×Ôhttp://www.tzwhx.com/newOperate/Html/3/31/311/16609.html
Óï·¨
CREATE TRIGGER trigger_name
ON { table | view }
[ WITH ENCRYPTION ]
{
    { { FOR | AFTER | INSTEAD OF } { [ INSERT ] [ , ] [ UPDATE ] }
        [ WITH APPEND ]
   ......

SQLÈÕÆÚ¸ñʽ»¯Ó¦ÓôóÈ«

Sql Server ÖÐÒ»¸ö·Ç³£Ç¿´óµÄÈÕÆÚ¸ñʽ»¯º¯Êý
Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AM
Select CONVERT(varchar(100), GETDATE(), 1): 05/16/06
Select CONVERT(varchar(100), GETDATE(), 2): 06.05.16
Select CONVERT(varchar(100), GETDATE(), 3): 16/05/06
Select CONVERT(varchar(100), GE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ