March 24th, 2004, 11:39 PM
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.
Last edited by ringo; March 24th, 2004 at 11:46 PM.
Reason: Add smilies
March 26th, 2004, 11:26 PM
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.
I've never been able to appreciate the sublime arrogance of folks who feel they were put on earth just to save other folks from themselves .." - Donald Hamilton