June 16, 2008 at 4:09 am
Hi experts,
We have a production server(sql server 2005) and so many machines are connectiong to the server,the problem is that the client machines are some time not able to connect to the server.Whatever happens to the serrver is unknown at that time but the connecting machines got hang.This occurs at peak time.
What all this i have to check related to SQL Server???
Please Help
TIA
June 16, 2008 at 6:02 am
If nobody is able to connect to Sql Server 2005 try connecting using the \DAC (Dedicated admin connection) and see what process is currently running. You can query the sys.dm_exec_sessions dmv for more info regarding the processes. Check the Sql Server error log, agent log and event viewer for more clues.
[font="Verdana"]- Deepak[/font]
June 16, 2008 at 6:21 am
Deepak thanks for replying..
The problem is that the issue occured 3 days back and i checked the error logs and server logs but didnt find anything unusual.
My finding when i checked the server is that.
!)Databases in simple recovery model
2)Compatability level is 2000 (Server is 2005)
3)No service pack installed.
What are all the thinks i have to check other than this???
June 17, 2008 at 9:36 am
Is you local environment just a LAN or do you also have WAN connectivity ?
If you have a LAN/WAN environment are only WAN connections affected ?
Are only a specific subgroups users by location only affected ?
Have you contacted your network team to see if there were any outages or issues ?
Have you checked with your WIndows admins ?
Were there any DNS issues ?
Were there any DHCP issues
Were there any AD issues ?
These are just a few relevant questions. Each and every one of them could be responsible or play a contributing role to the type of situation that you have recently encountered. I have found in the pas that 90% of the type of outage you are speaking about is not a SQL Server caused issue.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply