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

ÈçºÎ¿ªÆô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ϵͳÏÂsqlServer 2000ÖÐ1433¶Ë¿Ú´ò²»¿ªµÄÎÊÌâ

 ÎÒ×°µÄÊÇXpϵͳ£¬µ±ÎÒ×°Sql Server2000Êý¾Ý¿âºó£¬ÓÃJava³ÌÐòÀ´½øÐÐÊý¾Ý¿âÁ¬½Óʱ³ö´íÁË£¬·¢ÏÖÊÇ1433¶Ë¿ÚûÓдò¿ª£¬ÔÚÍøÉÏÕÒÁËЩ½â¾ö°ì·¨£¬·½·¨ËµµÄ²»ÊǺÜÇå³þ£¬»¹ÓеãÂÞàÂÁË¡£ÎÒ½â¾öºó·¢ÏÖ°ì·¨ÊÇ£ºÊ×ÏÈÊDz鿴ÄãµÄ°æ±¾£¬¿ÉÒÔÓÃselect @@versionÀ´²é¿´¡£×°ÍêSql Server 2000 1433¶Ë¿ÚÓÐÊÇûÓдò¿ª£¬¿ÉÒÔÓÃnet -an -p tcp ......

ÓÃasp.net»¹Ô­Óë»Ö¸´sqlserverÊý¾Ý¿â

  
ÉÏ´Î×öÁ˸öÏîÄ¿£¬Éæ¼°µ½Êý¾Ý¿âµÄ»¹Ô­ºÍ»Ö¸´£¬µ½ÍøÉÏÕÒÁËһϣ¬ÊÇÀûÓÃSQLDMOʵÏֵģ¬Ö»ÒªÌí¼ÓSQLDMOÒýÓþͺÃÁË£¬È»ºóÀûÓÃϱߵÄÀàµÄ·½·¨¾Í¿ÉÒÔʵÏÖÁË¡£
ÎÒ°ÑÔ­×÷ÕßµÄÀàÀ©³äÁËһϣ¬¿ÉÒÔ×Ô¶¯Ê¶±ðweb.configÀï µÄÊý¾Ý¿âÁ¬½Ó×Ö·û´®£¬¿ÉÒÔͨ¹ý±äÁ¿ÉèÖû¹Ô­»Ö¸´µÄÐÅÏ¢¡£
ÐèҪעÒâµÄʱ»¹Ô­£¬»¹Ô­µÄʱºòÎÊÌ ......

ɾ³ýSQLServer²éѯ·ÖÎöÆ÷ÖеÄÁ¬½Ó¼Ç¼

SQLSERVER 2000
ÿ´Î´ò¿ªSQLServer²éѯ·ÖÎöÆ÷ºó£¬ÔÚÁ¬½Ó´°¿ÚÀïµÄSQLServer·þÎñÆ÷Ñ¡ÔñÏÂÀ­¿òºÍµÇ¼Óû§ÃûÊäÈë¿òÀﶼ»áÁôÓÐÀúÊ·µÇ¼µÄ¼Ç¼£¬ÓÐʱºòÎÒÃÇÊDz»Ï£ÍûÕâÑùµÄ£¬±ÈÈçÔÚÒ»¸ö·Ç˽ÓÐÁìµØ×öÁËÔÝʱµÄ¿ª·¢ºó£¬²»ÏëÁôÏÂÈκÎÁ¬½ÓÔ¶³ÌÊý¾Ý¿âµÄ¼Ç¼£¬ÈçºÎɾ³ýÄØ£¿»¹ÊÇ×¢²á±í£¬ÕÒµ½ÒÔÏ·¾¶£º
HKEY_CURRENT_USER\Software\Micr ......

ÈçºÎ»ñµÃsqlserverÊý¾Ý¿âÖÐÕ¼ÓøßcpuÓû§µÄ»î¶¯ÄÚÈÝ


ÈçºÎ»ñµÃ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ÖоßÌåÏß³ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ