October 10, 2008 at 7:30 am
Can some one please help me to find out why this happend:)
October 10, 2008 at 8:16 am
What this query is doing is looking at various table names as selected from the database's metadata, and then checking a portion of the table name against what appears to be spid data in the master database, and I don't have sufficient knowledge to know why one would want or need to do that. However, if the server where the script is running is locking up, then it may be that the timeout value for the command object in the VBScript is set to either never time out, or to a rather large value, such that if the WHILE loops in this code run into blocking, or can somehow become infinite loops due to conditions not foreseen when the code was written, that MIGHT be a cause. I always get a little scared of code with WHILE (1=1) in it, as that represents an infinite loop unless you can guarantee that the condition necessary to reach the BREAK statement will ALWAYS occur at some point in the process. Unless you can get your DBA to determine exactly what this code is doing, and whether or not existing conditions would cause this code to go into an infinite loop, you may never know for sure.
One way to tackle that is to determine how long that script takes when it doesn't cause a lockup, and monitor it's run-time until you see it lock up Server 1 again, and then see how long it was running before the server locked up. If it's significantly longer than the usual run, then I would suspect that the conditions necessary to create the infinite loop are present.
Hope that helps...
Steve
(aka smunson)
:):):)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
October 10, 2008 at 8:23 am
How do I run profile?
October 10, 2008 at 8:59 am
Start | Programs | SQL Server | Profiler (I think that's the path on a 2000 server).
Connect to your SQL Server, start a new trace, choose the defaults. It will trace activity against the server. If you have lots of people on this server, you can change the properties of the trace to limit the data to one login, choose a unique login and run the VBS as that user (log in as that user).
You can run this from your workstation, running from any computer simulates the connection when running from the server. Can you post the way it's run from the server? Is it a shceduled task? Does someone click on the VBS or is there some batch file?
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply