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µÄÅäÖÃ:
1.ÈçºÎÐÞ¸ÄtomcatµÄ¶Ë¿Ú
2.ÈçºÎÉèÖÃÐéÄâĿ¼
3.ÈçºÎ¸øtomcatµÄ¹ÜÀíÔ±ÉèÖÃÃÜÂë
4.ÈçºÎÉèÖÃÊý¾ÝÔ´ºÍÁ¬½Ó³Ø(¹«Ë¾³£ÓÃ!)
(¶þ)ÈçºÎÐÞ¸ÄtomcatµÄ¶Ë¿Ú
ÔÚijЩÇé¿öÏ£¬¿ÉÄÜÐèÒªÐÞ¸Ätomcat¼àÌýµÄ¶Ë¿Ú8080 £¬±ÈÈ磺
¡ôÐèÒªÆô¶¯Á½·Ýtomcat·þÎñÆ÷
¡ôij¸ö·þÎñÕ¼ÓÃÁË8080¶Ë¿Ú
(Èý)ÈçºÎÐÞ¸ÄtomcatµÄ¶Ë¿Ú
ÐÞ¸Ätomca ......
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 ......
±¾ÎÄ×ªÔØÓÚ£ºhttp://www.javaeye.com/topic/185385
ѧϰÊý¾Ý¿â²éѯµÄʱºò¶Ô¶à±íÁ¬½Ó²éѯµÄÓÐЩ¸ÅÄ±È½ÏÄ£ºý¡£¶øÁ¬½Ó²éѯÊÇÔÚÊý¾Ý¿â²éѯ²Ù×÷µÄʱºò¿Ï¶¨ÒªÓõ½µÄ¡£¶ÔÓڴ˸ÅÄî
ÎÒÓÃͨË×һЩµÄÓïÑÔºÍÀý×ÓÀ´½øÐн²½â¡£Õâ¸öÀý×ÓÊÇÎÒ½²¿ÎµÄʱºò¾³£²ÉÓõÄÀý×Ó¡£
Ê×ÏÈÎÒÃÇ×öÁ½ÕÅ±í£ºÔ±¹¤ÐÅÏ¢±íºÍ²¿ÃÅÐÅÏ¢±í£¬ÔÚ´Ë£¬±íµ ......
¾¹ýÁ˼¸´ÎµÄ²âÊÔÖÕÓڳɹ¦ÁË
declare @Year Int,
@Month int,
@Day int,
@Temp_No varchar(12),
@NeedNo varchar(4),
......