ÈçºÎ¿ªÆôSQLSERVERÊý¾Ý¿â»º´æÒÀÀµÓÅ»¯ÍøÕ¾ÐÔÄÜ
ÈçºÎ¿ªÆôSQLSERVERÊý¾Ý¿â»º´æÒÀÀµÓÅ»¯ÍøÕ¾ÐÔÄÜ
Êý¾Ý¿â, »º´æ, SQLSERVER, ÐÔÄÜ
ºÜ¶àʱºò£¬ÎÒÃÇ·þÎñÆ÷µÄÐÔÄÜÆ¿¾±»áÊÇÔÚ²éѯÊý¾Ý¿âµÄʱºò£¬ËùÒÔ¶ÔÊý¾Ý¿âµÄ»º´æ·Ç³£ÖØÒª£¬ÄÇôÓÐûÓÐÒ»ÖÖ·½·¨£¬¿ÉÒÔʵÏÖSQL SERVERÊý¾Ý¿âµÄ»º´æ£¬µ±Êý¾Ý±íûÓиüÐÂʱ£¬¾Í´Ó»º´æÖжÁÈ¡£¬µ±ÓиüеÄʱºò£¬²Å´ÓÊý¾Ý±íÖжÁÈ¡ÄØ£¬´ð°¸Êǿ϶¨µÄ£¬ÕâÑùµÄ»°ÎÒÃǶÔһЩ³£ÓõĻù´¡Êý¾Ý±í¾Í¿ÉÒÔ»º´æÆðÀ´£¬±ÈÈç×öÐÂÎÅϵͳµÄÐÂÎÅÀà±ðµÈ£¬Ã¿´Î¾Í²»ÐèÒª´ÓÊý¾Ý¿âÖжÁÈ¡ÁË£¬¼Ó¿ìÍøÕ¾µÄ·ÃÎÊËٶȡ£
ÄÇôÈçºÎ¿ªÆôSQLSERVERÊý¾Ý¿â»º´æÒÀÀµ£¬·½·¨ÈçÏ£º
µÚÒ»²½£ºÐÞ¸ÄWeb.ConfigµÄ<system.web>½ÚµÄÅäÖ㬴úÂëÈçÏ£¬ÈÃÍøÕ¾ÏîÄ¿ÆôÓÃSqlCacheDependency¡£×¢ÒâÏÂÃæ´úÂëÖеÄconnectionStringName,¾ÍÊÇÖ¸¶¨µÄ<connectionStrings>½ÚÖеÄÊý¾Ý¿âÁ¬½Ó×Ö·û´®±äÁ¿Ãû³Æ¡£nameÔòÊÇΪ¸ÃSqlCacheDependencyÆðµÄÃû×Ö£¬Õâ¸öÃû×Ö½«ÔÚµÚÈý²½ÖÐÓõ½¡£SqlCacheDependencyÀà»á×Ô¶¯Íê³É¶Ô´ËÅäÖýÚÐÅÏ¢µÄ¶ÁÈ¡ÒÔ½¨Á¢ºÍÊý¾Ý¿âÖ®¼äµÄÁªÏµ¡£
view source
< id="highlighter_422634_clipboard" title="copy to clipboard" classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" width="16" height="16" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,0,0" type="application/x-shockwave-flash">
print?
01.<system.web>
02.<httpHandlers>
03.<add verb="*" path="*.aspx"
04.type="URLRewriter.RewriterFactoryHandler, URLRewriter" />
05.<add verb="*" path="*.shtml"
06.type="URLRewriter.RewriterFactoryHandler, URLRewriter" />
07.<add verb="*" path="*.bobo"
08.type="URLRewriter.RewriterFactoryHandler, URLRewriter" />
09.
10.</httpHandlers>
11.<!-->ÒÔÏÂ<SPAN class=t_tag onclick=tagshow(event) href="tag.php?name=%C9%E8%D6%C3">ÉèÖÃ</SPAN>Êý¾Ý¿â»º´æÒÀÀµ·½Ê½-->
12.<caching>
13.<sqlCacheDependency enabled="true" pollTime="6000">
14.<databases>
15.<add name="YD_JWC_JAKE" connectionStringName="cachestr"/>
16.</databases>
17.</sqlCacheDependency>
18.</caching>
19.<!--
20.ÉèÖà compilation debug="true" ½«µ÷ÊÔ·ûºÅ²åÈë
21.ÒÑ<SPAN class=t_t
Ïà¹ØÎĵµ£º
ÎÒ×°µÄÊÇXpϵͳ£¬µ±ÎÒ×°Sql Server2000Êý¾Ý¿âºó£¬ÓÃJava³ÌÐòÀ´½øÐÐÊý¾Ý¿âÁ¬½Óʱ³ö´íÁË£¬·¢ÏÖÊÇ1433¶Ë¿ÚûÓдò¿ª£¬ÔÚÍøÉÏÕÒÁËЩ½â¾ö°ì·¨£¬·½·¨ËµµÄ²»ÊǺÜÇå³þ£¬»¹ÓеãÂÞàÂÁË¡£ÎÒ½â¾öºó·¢ÏÖ°ì·¨ÊÇ£ºÊ×ÏÈÊDz鿴ÄãµÄ°æ±¾£¬¿ÉÒÔÓÃselect @@versionÀ´²é¿´¡£×°ÍêSql Server 2000 1433¶Ë¿ÚÓÐÊÇûÓдò¿ª£¬¿ÉÒÔÓÃnet -an -p tcp ......
ÉÏ´Î×öÁ˸öÏîÄ¿£¬Éæ¼°µ½Êý¾Ý¿âµÄ»¹ÔºÍ»Ö¸´£¬µ½ÍøÉÏÕÒÁËһϣ¬ÊÇÀûÓÃSQLDMOʵÏֵģ¬Ö»ÒªÌí¼ÓSQLDMOÒýÓþͺÃÁË£¬È»ºóÀûÓÃϱߵÄÀàµÄ·½·¨¾Í¿ÉÒÔʵÏÖÁË¡£
ÎÒ°ÑÔ×÷ÕßµÄÀàÀ©³äÁËһϣ¬¿ÉÒÔ×Ô¶¯Ê¶±ðweb.configÀï µÄÊý¾Ý¿âÁ¬½Ó×Ö·û´®£¬¿ÉÒÔͨ¹ý±äÁ¿ÉèÖû¹Ô»Ö¸´µÄÐÅÏ¢¡£
ÐèҪעÒâµÄʱ»¹Ô£¬»¹ÔµÄʱºòÎÊÌ ......
SQLSERVER 2000
ÿ´Î´ò¿ªSQLServer²éѯ·ÖÎöÆ÷ºó£¬ÔÚÁ¬½Ó´°¿ÚÀïµÄSQLServer·þÎñÆ÷Ñ¡ÔñÏÂÀ¿òºÍµÇ¼Óû§ÃûÊäÈë¿òÀﶼ»áÁôÓÐÀúÊ·µÇ¼µÄ¼Ç¼£¬ÓÐʱºòÎÒÃÇÊDz»Ï£ÍûÕâÑùµÄ£¬±ÈÈçÔÚÒ»¸ö·Ç˽ÓÐÁìµØ×öÁËÔÝʱµÄ¿ª·¢ºó£¬²»ÏëÁôÏÂÈκÎÁ¬½ÓÔ¶³ÌÊý¾Ý¿âµÄ¼Ç¼£¬ÈçºÎɾ³ýÄØ£¿»¹ÊÇ×¢²á±í£¬ÕÒµ½ÒÔÏ·¾¶£º
HKEY_CURRENT_USER\Software\Micr ......
ÈçºÎ»ñµÃsqlserverÊý¾Ý¿âÖÐÕ¼ÓøßcpuÓû§µÄ»î¶¯ÄÚÈÝ
1¡¢´Ó΢ÈíÕ¾µãÉÏÏÂÔØqslice_setup.exe
2¡¢´ò¿ªQuery Analyzer£¬ÔËÐÐÒÔÏÂÓï¾ä£º
declare @a int
while (1<2)
begin
select @a=1
end
½«»á·¢ÏÖcpuÂíÉÏ´ïµ½100%
3¡¢´ò¿ªqlice.exe£¬½«·¢ÏÖsqlserver.exeµÄcpuÕ¼ÓÃÂʺܸߣ¬Ë«»÷½øÈ룬³öÐÐsqlserver.exeÖоßÌåÏß³ ......