SQL 2000 Server Hangs...!

[Senthuran]

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

[Alexey Aksyonenko]

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

[Senthuran]

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

[Alexey Aksyonenko]

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!