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

SQL ServerÈçºÎÌá¸ßÊý¾Ý¿â±¸·ÝµÄËÙ¶È

¶ÔÓÚÒ»¸öÊý¾Ý¿âÍêÕû±¸·ÝÀ´Ëµ£¬±¸·ÝµÄËٶȺܴó³Ì¶ÈÉÏÈ¡¾öÓÚÏÂÃæÁ½¸öÒòËØ£º¶Á´ÅÅÌÊý¾Ý¡¢ÈÕÖ¾ÎļþµÄÍÌÍÂÁ¿£¬Ð´´ÅÅÌÊý¾ÝÎļþµÄÍÌÍÂÁ¿¡£
ÏÂͼÊDZ¸·Ý¹ý³ÌÖдÅÅ̵ı仯Çé¿ö£º

¶ÁÍÌÍÂÁ¿
¶ÁÍÌÍÂÁ¿µÄ´óСȡ¾öÓÚ´ÅÅ̶ÁÈ¡Êý¾ÝµÄËÙ¶È£¬¶ø´ÅÅ̶ÁÈ¡µÄËÙ¶ÈÓÖÈ¡¾öÓÚÊý¾ÝÎļþÔÚ´ÅÅÌÖеÄλÖá£Òò´Ë£¬Î»ÓÚ²»Í¬ÅÌ·ûÉϲ»Í¬Êý¾Ý¿âÎļþµÄ¶ÁÈ¡Ëٶȶ¼²»Ïàͬ¡£
²âÁ¿¶ÁÍÌÍÂÁ¿µÄÒ»¸ö·½·¨¾ÍÊǽøÐÐÒ»´ÎÊý¾Ý¿âÍêÕû±¸·Ý£¬È»ºóʹÓÃWindowsÐÔÄÜ¼à¿ØÆ÷(perfmon)À´¼à¿ØÊý¾Ý¿âÎļþËùÔÚ´ÅÅ̵ÄRead bytes/sec ÐÔÄܼÆÊýÆ÷¡£±£´æ±¸·ÝÎļþµÄ´ÅÅÌÓ¦¸ÃÔÚÎïÀíÉÏÇø±ðÓÚÊý¾Ý¿âÎļþËùÔڵĴÅÅÌ£¬·ñÔò²âÁ¿¾«¶È»á²»×¼È·¡£µ±È»±¸·ÝͬʱҲӦ¸Ã»áÓÐÁíÍâһЩÀ´×Ôϵͳ»òÊÇÆäËûÓ¦ÓóÌÐò¶Ô´ÅÅ̵ĶÁÈ¡²Ù×÷¡£
×¢Ò⣺Èç¹ûÄãʹÓÃÍêÕû±¸·ÝÀ´¼à²â´ÅÅ̶ÁдÍÌÍÂÁ¿µÄ»°£¬ÄÇôÕâ¸ö²âÊÔÓõı¸·ÝÎļþÓ¦¸ÃºÍÆäËû³£¹æ±¸·Ý·ÅÔÚÒ»Æð£¬ÒÔ±ã»Ö¸´Ê±Ê¹Óá£Ò²¾ÍÊÇ˵£¬Èç¹ûÄãÔÚ²âÊÔ±¸·ÝÎļþÖ®ºóÓÖ½øÐÐÁ˳£¹æ²îÒ챸·Ý£¬ÄÇôÕâЩ²îÒ챸·Ý¾Í»áÒÔÕâ¸ö²âÊÔ±¸·ÝΪ»¹Ô­µÄÆðʼµã¡£
¼ÙÉèÊý¾Ý¿âËùÓÐÎļþµÄ´óС¶¼ÊÇÏàµÈµÄ£¬ÄÇôÄã»ñÈ¡µÄ×îС²âÁ¿Öµ¾ÍÊÇÄãÖ¸¶¨Êý¾Ý¿âÔÚϵͳÖÐ×î´óµÄ±¸·ÝÍÌÍÂÁ¿ÁË¡£
ÁíÒ»¸ö²âÁ¿¶ÁÍÌÍÂÁ¿µÄ·½·¨ÊÇÔÚNULÉ豸ÉÏÖ´Ðб¸·Ý£¬ÈçÏ£º
BACKUP DATABASE AdventureWorks TO DISK = 'NUL' WITH COPY_ONLY
×¢ÒâÎÒÃÇʹÓÃÁËCOPY_ONLYÑ¡ÏÕâ¸öÑ¡Ïî½ö½öÔÚSQL Server 2005¼°ÒÔÉϰ汾ÖвÅÌṩ¡£Äã¿ÉÒÔÔÚSQL Server2000ÉÏÖ´ÐÐÏàͬµÄ±¸·Ý£¬Ö»ÊÇÒªºöÂÔÕâ¸öÑ¡Ïµ«ÊÇÒ»¶¨ÒªÐ¡ÐÄ¡£ÒòΪ±¸·Ýµ½NULÉ豸Ҳ»á±»ÈÏΪÊÇÒ»¸öÓÐЧ±¸·Ý£¬Õâ¾ÍÒâζ×ŵ±ÄãÖ´Ðб¸·Ýµ½NULÉ豸ºó£¬ÄãºóÐøµÄËùÓвîÒ챸·Ý¶¼½«²»¿ÉÓ㬳ý·ÇÄãÔÚÖ´Ðб¸·Ýµ½NULÉ豸ºó£¬ÔÙÖ´ÐÐÒ»´Î³£¹æµÄÊý¾Ý¿âÍêÕû±¸·Ý¡£¼ÙÈçÄãÖ´ÐÐÊÂÎñÈÕÖ¾±¸·Ýµ½NULÉ豸£¬ÄÇôÄã½«ÆÆ»µÈÕÖ¾»Ö¸´Á´£¬µ¼ÖºóÐøÊÂÎñÈÕÖ¾±¸·Ý²»¿ÉÓá£
Èç¹ûÄã±ØÐëÔÚSQL Server 2000ÉÏÖ´Ðб¸·Ýµ½NULÉ豸µÄ»°£¬Ò»¶¨Òª×öºÃ±¸ÔÖ»Ö¸´µÄ×¼±¸¡£
¼ÙÉèÎÒÏÖÔÚÒѾ­²âÁ¿³öÎÒµÄAdventureWorks¶ÁÍÌÍÂÁ¿Îª46MB/sec¡£Õâ¾ÍÊÇ˵£¬46MB/secÊÇ×î´óµÄ±¸·ÝÍÌÍÂÁ¿ÁË£¬Ò²ÊÇÎҵĴÅÅÌÄÜÌṩ¸øSQL Server±¸·Ý¶ÁÏß³Ì×î¿ìµÄËÙ¶ÈÁË¡£ÄÇÎÒÃÇÈçºÎÌá¸ßÕâ¸öËÙ¶ÈÄØ£¿Ê¹Óøü¿ìµÄ´ÅÅ̿϶¨ÊÇÒ»ÖÖ·½·¨¡£ÁíÍâµÄ·½·¨¾ÍÊǰÑÊý¾Ý¿âÎļþ·ÖÉ¢µ½¶à¸öÎïÀí´ÅÅÌÉÏ£¬ÒÔ±ãÓÚÔÚ¶ÁÊý¾Ýʱ¿ÉÒÔͬ²½´´½¨¶à¸ö¶ÁÏ̡߳£¼õСÊý¾Ý¿âÎļþµÄË鯬¼¶±ðÒ²¿ÉÒÔÌá¸ßÍÌÍÂÁ¿£¬ÌرðÊǵ±Êý¾Ý¿âÎļþÓдóÁ¿Ë鯬´æÔÚʱ¡£
дÍÌÍÂÁ¿
ÏÖÔÚ¿ªÊ¼ËµËµÐ´ÍÌÍÂÁ¿¡£Ö´ÐÐÒ»¸öÎļþ±¸·Ý£¬ÔÚÎÒµÄϵͳÖУ¬Îҵõ½ÁËÈçϵÄ


Ïà¹ØÎĵµ£º

tomcat sql Á¬½Ó³ØÅäÖà Rubicon

tomcatµÄÅäÖÃ:
1.ÈçºÎÐÞ¸ÄtomcatµÄ¶Ë¿Ú
2.ÈçºÎÉèÖÃÐéÄâĿ¼
3.ÈçºÎ¸øtomcatµÄ¹ÜÀíÔ±ÉèÖÃÃÜÂë
4.ÈçºÎÉèÖÃÊý¾ÝÔ´ºÍÁ¬½Ó³Ø(¹«Ë¾³£ÓÃ!)
(¶þ)ÈçºÎÐÞ¸ÄtomcatµÄ¶Ë¿Ú
ÔÚijЩÇé¿öÏ£¬¿ÉÄÜÐèÒªÐÞ¸Ätomcat¼àÌýµÄ¶Ë¿Ú8080 £¬±ÈÈ磺
¡ôÐèÒªÆô¶¯Á½·Ýtomcat·þÎñÆ÷
¡ôij¸ö·þÎñÕ¼ÓÃÁË8080¶Ë¿Ú
(Èý)ÈçºÎÐÞ¸ÄtomcatµÄ¶Ë¿Ú
ÐÞ¸Ätomca ......

ÓÃSQLÓï¾ä¶Ï¿ªÄ³¸öÊý¾Ý¿âµÄËùÓлÁ¬½Ó

use master
go
if exists(select * from dbo.sysobjects where id = object_id(N'[dbo].[P_KillConnections]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[P_KillConnections]
GO
create proc P_KillConnections
@dbname varchar(200)
as
declare @sql nvarchar(500)
declare @spid nvar ......

SQL ×óÓÒÁ¬½Ó

 ±¾ÎÄ×ªÔØÓÚ£ºhttp://www.javaeye.com/topic/185385
ѧϰÊý¾Ý¿â²éѯµÄʱºò¶Ô¶à±íÁ¬½Ó²éѯµÄÓÐЩ¸ÅÄ±È½ÏÄ£ºý¡£¶øÁ¬½Ó²éѯÊÇÔÚÊý¾Ý¿â²éѯ²Ù×÷µÄʱºò¿Ï¶¨ÒªÓõ½µÄ¡£¶ÔÓڴ˸ÅÄî
ÎÒÓÃͨË×һЩµÄÓïÑÔºÍÀý×ÓÀ´½øÐн²½â¡£Õâ¸öÀý×ÓÊÇÎÒ½²¿ÎµÄʱºò¾­³£²ÉÓõÄÀý×Ó¡£
Ê×ÏÈÎÒÃÇ×öÁ½ÕÅ±í£ºÔ±¹¤ÐÅÏ¢±íºÍ²¿ÃÅÐÅÏ¢±í£¬ÔÚ´Ë£¬±íµ ......

SQLÉú³ÉÁ÷Ë®ºÅ

¾­¹ýÁ˼¸´ÎµÄ²âÊÔÖÕÓڳɹ¦ÁË
declare @Year Int,
        @Month int,
        @Day int,
        @Temp_No varchar(12),
        @NeedNo varchar(4),
   ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ