Periodic Freezing

[l310564]

Hi,

I hope someone can come up with some suggestions because I'm completely flummoxed.

I have a relatively small network of about 7 PCs and a SQL server. They all run various applications that access the SQL database.

The problem is that it keeps freezing 2-3 times a day for up to 10 Mins and several more times a day for shorter periods. Originally i thought that the server was being over worked but when ever i look at it during these periods it is using a minimal amount of memory and CPU, about 3% CPU and 50-60% of the memory and the PCs, they aren't doing any work at all!

In my mind this has to be something to do with sql because you can run any un-sql related program without any trouble at all including accessing files on the SQL server over the network and Internet.

If anyone has any ideas it would be appreciated.

Cheers,

Hugh

 

[l310564]

Sorry forgot to say it is SQL 2000 running on a Windows server 2000 machine.

Hugh

 

[ptheriault]

When you are experiencing this problem can you query any database with query analyzer? Have you checked the SQL error logs?

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[l310564]

No there is nothing in the error logs. I haven't tried with query analyzer but Enterprise manager just hangs like the PCs and i would expect query analyzer to do the same.

Hugh

If knowlege can create problems it is not through ignorance that we will solve them

Isaac Asimov

 

[ptheriault]

I would start SQL profiler and let a trace run till the server hangs. This will provide you information on what is running.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[l310564]

Ok,

I have never used this before so do you know what specific events i should be monitoring.

Hugh

If knowlege can create problems it is not through ignorance that we will solve them.

Isaac Asimov

 

[ptheriault]

Well because we aren't sure what could be causing this problem you might want to collect everything. I would start it with the defaults. There will be alot of data to go through but it will be worth it if you can find the problem.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[l310564]

cheers, i'll let you know how i get on

hugh

If knowlege can create problems it is not through ignorance that we will solve them.

Isaac Asimov

 

[Catadmin]

Make sure to save the data to a trace file and/or a SQL table so you can reference it later on. Otherwise, the data will vanish if you stop & restart Profiler.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"