By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,652 Members | 1,694 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,652 IT Pros & Developers. It's quick & easy.

SQL 2000 Server Hangs...!

P: n/a
Hi,

The SQL server 2000 Server hangs some times. It is not periodic. It is
not specific in any queries, which are taking more time to execute.
Because, it is occurring for different types of applications on the
same server on different machines. For the same applications when we
had the SQL Server 7.0 we didn't have any problem.

O/S: Windows 2000 advanced server
Server: Dell power edge 2600 4 way server with 2 GB RAM
DB: SQL 2000 - Enterprise edition (Normal default installation)- No
service packs.

Are there any server settings to be done...?

Thanks in advance..

Regards
Seni
Jul 20 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
I had similar problem in the past few days - make sure you don't have
the msblast.exe virus floating about your network. The bandwidth
consumption will slow down your queries. After we cleaned it - all
went back to normal. Check all machines, not just the SQL server.
Also - upgrade the service packs. :-)
Alexey

se******@yahoo.com (Senthuran) wrote in message news:<9c**************************@posting.google. com>...
Hi,

The SQL server 2000 Server hangs some times. It is not periodic. It is
not specific in any queries, which are taking more time to execute.
Because, it is occurring for different types of applications on the
same server on different machines. For the same applications when we
had the SQL Server 7.0 we didn't have any problem.

O/S: Windows 2000 advanced server
Server: Dell power edge 2600 4 way server with 2 GB RAM
DB: SQL 2000 - Enterprise edition (Normal default installation)- No
service packs.

Are there any server settings to be done...?

Thanks in advance..

Regards
Seni

Jul 20 '05 #2

P: n/a
Thanks Alexy,

I have verified this situation in the network... And the ms balster
has already been cleared.

But specifically, Our application which connects to the database logs
the exception as "Timout Expired" when the server hangs. So, shouldn't
it be a delay in server instead of any network delay...? But still
this timeout expired is not specific for a particular scenario... but
for all queries on the particular time when server hangs.

Rgds
Seni
Al***************@coanetwork.com (Alexey Aksyonenko) wrote in message news:<14*************************@posting.google.c om>...
I had similar problem in the past few days - make sure you don't have
the msblast.exe virus floating about your network. The bandwidth
consumption will slow down your queries. After we cleaned it - all
went back to normal. Check all machines, not just the SQL server.
Also - upgrade the service packs. :-)
Alexey

se******@yahoo.com (Senthuran) wrote in message news:<9c**************************@posting.google. com>...
Hi,

The SQL server 2000 Server hangs some times. It is not periodic. It is
not specific in any queries, which are taking more time to execute.
Because, it is occurring for different types of applications on the
same server on different machines. For the same applications when we
had the SQL Server 7.0 we didn't have any problem.

O/S: Windows 2000 advanced server
Server: Dell power edge 2600 4 way server with 2 GB RAM
DB: SQL 2000 - Enterprise edition (Normal default installation)- No
service packs.

Are there any server settings to be done...?

Thanks in advance..

Regards
Seni

Jul 20 '05 #3

P: n/a
Yes, you would get the timeout error. To be honest, I am not sure why
this virus slows down even queries running locally on a non-infected
server. I think it has something to do with hitting the DC for
licensing info. But we were experiencing same timeout issues, they
appeared right after the virus attack, and disappeared after it was
contained.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.