Computer lazy after error on programming with SQL

Question

Computer lazy after error on programming with SQL

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

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

dig SSC-Addicted Points: 435 More actions · Answer 1

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

5409045121009-7368 SSCoach Points: 15740 More actions · Answer 2

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.

dig SSC-Addicted Points: 435 More actions · Answer 3

5409045121009

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

Thanks!

Dalton

eholsinger Mr or Mrs. 500 Points: 525 More actions · Answer 4

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...

dig SSC-Addicted Points: 435 More actions · Answer 5

eholsinger

My IIS is already the 5.0.

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

Dalton