ÀûÓÃ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
(ÇëÄú¶ÔÎÄÕÂ×ö³öÆÀ¼Û)
Ïà¹ØÎĵµ£º
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
Ò»¡¢×¼±¸¹¤×÷£º
1£®½¨Á¢Ò»¸ö WINDOWS Óû§£¬ÉèÖÃΪ¹ÜÀíԱȨÏÞ£¬²¢ÉèÖÃÃÜÂ룬×÷Ϊ·¢²¼¿ìÕÕÎļþµÄÓÐЧ·ÃÎÊÓû§¡£
2£®ÔÚSQL SERVERÏÂʵÏÖ·¢²¼·þÎñÆ÷ºÍ¶©ÔÄ·þÎñÆ÷µÄͨÐÅÕý³££¨¼´¿ÉÒÔ»¥·Ã£©¡£´ò¿ª1433¶Ë¿Ú£¬ÔÚ·À»ðǽÖÐÉèÌØÀ ......
Ò»¡¢µ¥±í²éѯÁ·Ï°
1¡¢²éѯ<ѧÉúÐÅÏ¢±í>£¬²éѯѧÉú"ÕÅÈý"µÄÈ«²¿»ù±¾ÐÅÏ¢
Select *
from A_studentinfo
where sname='ÕÅÈý'
2¡¢²éѯ<ѧÉúÐÅÏ¢±í>£¬²éѯѧÉú"ÕÅÈý"ºÍ”ÀîËÄ”µÄ»ù±¾ÐÅÏ¢
Select *
from A_studentinfo
where sname='ÕÅÈý'
or sname='ÀîËÄ'
3¡¢²éѯ<ѧÉú ......
ת×Ô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 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 ......