none
SQL Server2005asp查询慢 RRS feed

  • 问题

  • 服务器:win2003+iis6.0+SQL Server2005 sp3

    症状:以前很正常,这几天开始涉及到数据库的操作,网站就会很慢,只打开静态网页或asp网页都很快,就是与数据库有关的操作就会慢很明显,

    在本地就没有问题,配置和服务器一样,软件安装一样的,程序没有问题,在服务器上就数据库查询很慢

    请教解决方案!拜谢!

    2011年3月30日 2:53

全部回复

  • Tried run same queries on sql server directly? Are they slow there? Did you check execution plans? How often do you reindex/update stats in sql? Have detail of sql server and involved db?
    2011年3月30日 3:26
  • 肯定需要实际监测,猜是猜不中的
    Try SQL Server 2008 QQ:315054403 dgdba@hotmail.com
    2011年3月30日 3:38
  • 肯定需要实际监测,猜是猜不中的
    Try SQL Server 2008 QQ:315054403 dgdba@hotmail.com


    这是日志,请帮忙看一下:

    日期,源,严重性,消息
    03/30/2011 13:11:19,spid51,未知,Using 'xplog70.dll' version '2005.90.5000' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
    03/30/2011 13:11:18,spid51,未知,Using 'xpstar90.dll' version '2005.90.5000' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
    03/30/2011 13:11:17,spid51,未知,Using 'xpsqlbot.dll' version '2005.90.5000' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
    03/30/2011 13:11:12,spid5s,未知,Recovery is complete. This is an informational message only. No user action is required.
    03/30/2011 13:11:12,spid5s,未知,Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) has completed. This is an informational message only. No user action is required.


    dnon
    2011年3月30日 6:28
  • It doesn't tell performance issue.

    2011年3月30日 14:08
  • 经过几番折腾,把2005卸载了,装上了2008,现在速度快了,虽然没有找出什么原因,谢谢大家
    dnon
    2011年4月1日 0:51
  • 如果是同样的查询突然变慢了,会不会是数据库里面写了很多的操作日志?SQL 2005是可以删除日志的,这样可以提高一些速度,问题虽然解决了,但是找出问题一样很重要。

    是啊,但是怎么找到问题呢
    dnon www.zxwh.com
    2011年4月25日 9:17
  • Did you do anything people suggested above?
    2011年4月25日 13:20
  • Did you do anything people suggested above?

    <object id="tts_flash" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" width="18" height="18" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" setsoundstopcb="function () { return eval(instance.CallFunction("<invoke name=\""+name+"\" returntype=\"javascript\">" + __flash__argumentsToXML(arguments,0) + "</invoke>")); }" stopplayingsound="function () { return eval(instance.CallFunction("<invoke name=\""+name+"\" returntype=\"javascript\">" + __flash__argumentsToXML(arguments,0) + "</invoke>")); }" startplayingsound="function () { return eval(instance.CallFunction("<invoke name=\""+name+"\" returntype=\"javascript\">" + __flash__argumentsToXML(arguments,0) + "</invoke>")); }" setdirrtl="function () { return eval(instance.CallFunction("<invoke name=\""+name+"\" returntype=\"javascript\">" + __flash__argumentsToXML(arguments,0) + "</invoke>")); }" setsound="function () { return eval(instance.CallFunction("<invoke name=\""+name+"\" returntype=\"javascript\">" + __flash__argumentsToXML(arguments,0) + "</invoke>")); }"> <param name="_cx" value="476" /> <param name="_cy" value="476" /> <param name="FlashVars" /> <param name="Movie" value="http://www.gstatic.com/translate/sound_player2.swf" /> <param name="Src" value="http://www.gstatic.com/translate/sound_player2.swf" /> <param name="WMode" value="Transparent" /> <param name="Play" value="0" /> <param name="Loop" value="-1" /> <param name="Quality" value="High" /> <param name="SAlign" /> <param name="Menu" value="-1" /> <param name="Base" /> <param name="AllowScriptAccess" value="always" /> <param name="Scale" value="ShowAll" /> <param name="DeviceFont" value="0" /> <param name="EmbedMovie" value="0" /> <param name="BGColor" /> <param name="SWRemote" /> <param name="MovieData" /> <param name="SeamlessTabbing" value="1" /> <param name="Profile" value="0" /> <param name="ProfileAddress" /> <param name="ProfilePort" value="0" /> <param name="AllowNetworking" value="all" /> <param name="AllowFullScreen" value="false" /> </object>
    Re-installed the mssql,I did not find reasons
    dnon www.zxwh.com
    2011年4月26日 3:47