Post reply

Computer lazy after error on programming with SQL

  • May 14, 2003 at 4:56 am

    #457082

    Well Simple......

    I would not look in SQL server for a start. But in the page.

    To see if the sluggishness of the system is really caused by IIS. Try IISRESET.

    Thie will stop and strat all IIS related stuff.

    If it is fast then you know you got a problem on your ASP page.....

  • May 14, 2003 at 1:31 pm

    #457167

    well0549

    Well (again), it's quite an expertise!

    I fetched some literature from http://www.iis-resources.com/modules/news/article.php?storyid=7 (and hope not to need to use it...)

    Thank You very much!

    Dalton

  • May 14, 2003 at 11:07 pm

    #457204

    What I find a less 'intrusive' method is to fire up SQL Profiler and intially track only the sp:completed and rpc:completed events. Then run the sp's manually by copy and past it into Query Analyzer from Profiler. If sluggish then drill into stored procedures / db side else tackle the IIS page. Sometimes sp is fast enough, dataset just to big.

  • May 15, 2003 at 10:29 am

    #457319

    5409045121009

    I wrote it down, and will (try to) implement it, through my limited knowledge!

    Thanks!

    Dalton

  • May 16, 2003 at 1:11 pm

    #457513

    upgrade your IIS to 5.0, at a minimum and this will probably go away if it's not an infinite loop - IIS4.0 and below have stack errors that can't be fixed...

  • May 16, 2003 at 6:34 pm

    #457545

    eholsinger

    My IIS is already the 5.0.

    Nevertheless, the solution of my problem came through the IISRESTART suggestion, by well0549!

    Dalton

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply