Thread: IIS Hang

    #1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2004
    Posts
    1
    Rep Power
    0

    Unhappy IIS Hang


    Hi,

    I have a web program (asp) which using the dll (Visual Basic) as the backend program.

    The dll is written in VB and accessing the MS SQL.

    If I run the asp in one client computer, it works fine (it took about 2 to 3 minutes to complete the task in the dll). But when I run it simultaneously from two PC, it just take indefinately to run until the IIS hang.

    Can anyone help me on this? Is this my dll problem or the MS SQL problem? FYI, the dll program access the MS SQL heavily (open, update and also add new record).

    Is there any tools that i can monitor or debug the IIS problem?

    Thanks in advance.

    ringo
    Last edited by ringo; March 24th, 2004 at 11:46 PM. Reason: Add smilies
  2. #2
  3. No Profile Picture
    Grumpier old Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2003
    Posts
    14,445
    Rep Power
    4539
    You might use the sql server profilier. If you're using odbc there is a trace function you can turn on, but don't forget to turn it back off.

    You probably could debug your vb dll from within the vb ide

    You can set up performance monitors that look at many aspects of iis, asp, etc.
    ======
    Doug G
    ======
    Bartender to Rene Descartes "have another beer?" Descartes: "I think not" and he vanished.
    --Alfred Bester

IMN logo majestic logo threadwatch logo seochat tools logo