DB Connetion Errors

M

Matteo

Dear all,
I am facing with this big problem difficult to troubleshoot, sometime, the
user connection to the PWA is not receiving the webpage requested (any page
can respond like that) "Impossible connect to the db, check connections
credentials and check server up and running" all of them are true.

Actually I cannot understand what is happenning, the eventviewer is full of
this events but they are not really full of meaning or the meaning is not
really clear:
3355
5000
5586
6398
6482
6615
6772
6875
7076
7658
7682
7698
7702
7703
7704
7718
7758
7761
7772
7786
7797
7838
7851
7888
10036
27745

It happen sometime the connection to the db it's not available, I tried with
performance monitor to log:
Current Disk Queue Length
Packets Outbound Errors
Packets Received Errors
Output Queue Length
Memory\Pages/sec
% Processor Time
in both servers (SQL 2005 and WSS3.0- PROJECT SERVER 2007 servers) but
nothing is outside ranges except for 1 second(where %processor increase to
80% or queue reach 15) and not in relation to moment where pages does not
render and say connectiont to the db not available.

Waiting for any help, thank you all.

Matteo
 
J

James Fraser

Dear all,
I am facing with this big problem difficult to troubleshoot, sometime, the
user connection to the PWA is not receiving the webpage requested (any page
can respond like that) "Impossible connect to the db, check connections
credentials and check server up and running" all of them are true. [details removed...]

Waiting for any help, thank you all.

Matteo
Click to expand...

Have you checked the network connectivity between the two servers? Use
somthing like ping and see if there is continuous network
connectivity. If that is fine, then make sure there is continuous
connectivity to the SQL service. Use Query Analyzer on a remote
machine.
( http://articles.techrepublic.com.com/5100-6346_11-5109812.html )

This sounds like you have a significant problem with either the SQL
server or your network. Maybe failing hardware on the network?


James Fraser
 
M

Matteo

Thank you James,
I did not know the existence of query analyzer I will try today, I tried
ping it for days without packets loss.

I'll post results.

Thank you again.

Matteo

James Fraser said:
Dear all,
I am facing with this big problem difficult to troubleshoot, sometime, the
user connection to the PWA is not receiving the webpage requested (any page
can respond like that) "Impossible connect to the db, check connections
credentials and check server up and running" all of them are true. [details removed...]

Waiting for any help, thank you all.

Matteo
Click to expand...

Have you checked the network connectivity between the two servers? Use
somthing like ping and see if there is continuous network
connectivity. If that is fine, then make sure there is continuous
connectivity to the SQL service. Use Query Analyzer on a remote
machine.
( http://articles.techrepublic.com.com/5100-6346_11-5109812.html )

This sounds like you have a significant problem with either the SQL
server or your network. Maybe failing hardware on the network?


James Fraser
Click to expand...
 
Top