March 1, 2012 at 3:05 am
Hi, I am a little new to SQL server, I have a client that is running MS SQL server 2008. The application they use (supplied by a third party) keeps locking up. The third party support says that it is because the client loses connection to the SQL server. I support the network and cannot find anything wrong with it to the extent that I have run a long cable directly to the switch used by the sql server from a pc ajacent to the server room. I have removed all startup programs (inculuding the anti-virus) from the PC and they are now asking that I stop the group policy update background service running on the PC. I find it defficult to believe that SQL server is this sensitive. Is there a way I could put some monitoring software on the PC or server to check the connectivity?
Any help or advice would be appreciated. The server is completley patched and SQL is on SP2
March 1, 2012 at 5:54 am
They are just assuming or they presented you a proof or measurement (error log, monitor report etc) that clearly shows connectivity is the problem ?
Google for sp_whoisactive from Adam Mechanic. You can see what sessions are active and what they are waiting for.
If there is really connectivity problem, you should not see any sessions (nobody is connected because network is the problem).
You could use SQLCMD utility to try to connect to sql server from application server:
http://msdn.microsoft.com/en-us/library/ms162773.aspx
You can make a mini-monitoring system with SQLCMD that periodically tries to connect to server.
In windows performance monitor (perfmon) you can view and log performance counters that shows:
- number of connections
- number of active connections
- number of connect's per second
- number of disconnect's per second
Good luck!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply