July 6, 2011 at 5:08 pm
I'm experiencing a rather unusual and disconcerting issue with SSMS 2008R2. When launching from the same box that the instance I'm trying to connect to is on, I am presented with one of two scenarios. Either Windows (Server 2008) will immediate throw up a message stating that the program isn't responding with the three choices of closing, looking for a solution, yadda yadda, or, after choosing to connect to the instance, it hangs perpetually. I've tried connecting to the instance from another server with the same version of SSMS and everything is hunky-dorey. I have tried uninstalling the Client Connectivity Tools and reinstalling, but that has had no effect. This issue started out of the blue a couple of days ago. SQL Activity logs show nothing out of the ordinary.
The one other unusual thing (at least, I believe it to be unusual) is that in perfmon, the sqlservr process is generating a healthy amount of page faults...averaging about 250/sec over the span of 5 minutes. No actual paging on the memory object, though.
Anyone have any ideas?
July 6, 2011 at 5:45 pm
Specs on the server?
Also, patching level of the OS and SQL Server?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 6, 2011 at 6:17 pm
4x Intel Xeon L7555 @ 1.87GHz (8-core)
160 GB RAM
Windows Server 2008 SP2 Enterprise, fully patched
SQL Server 2008R2 Developer Edition, fully patched
July 7, 2011 at 10:34 am
Errors in the event logs?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 7, 2011 at 10:35 am
Nope, nuttin'. Pretty weird.
July 7, 2011 at 10:38 am
The page faults on the server shouldn't matter to SSMS since it's a client program connecting the same as it would from another server.
Are you connecting with the same protocols and same address as from another machine? Meaning are you using "." or "(local)" instead of the name/IP?
July 7, 2011 at 10:46 am
Thanks Steve...I had a feeling that the page faults were a red herring, but they did seem unusual (especially because nothing else was hitting the instance), so I thought I'd include it. They've since subsided.
Yes, I'm using the same methods in accessing it from the other machine. For example, the instance name is the default on the server, DEVSQL10. I connect to DEVSQL10 using Windows Authentication on both the server that the instance resides on as well as the the other machine. I've tried running it as the Administrator, in Server 2003 compatibility mode, and have also had another user (a domain admin) attempt to log in. He was actually able to get SSMS to open and display the Object Explorer tree, but as soon as we tried to open up the Management subtree, it hung.
When SSMS hangs, the CPU is more or less idle, no hard faults occuring in memory. Looking at the server stats, you wouldn't think that anything abnormal was going on at all.
July 7, 2011 at 11:12 am
I'd run a trace to see where it hangs, but it almost sounds like a corrupt client tools issue. I might reinstall just the client tools
July 7, 2011 at 11:14 am
Steve Jones - SSC Editor (7/7/2011)
I'd run a trace to see where it hangs, but it almost sounds like a corrupt client tools issue. I might reinstall just the client tools
With that reinstall, uninstall the tools first - then reinstall the client tools and then reapply patches.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 7, 2011 at 11:17 am
I've reinstalled the client tools about 3 times now.
July 7, 2011 at 11:25 am
coronaride (7/7/2011)
I've reinstalled the client tools about 3 times now.
After uninstall of same tools?
If so, there may be something else running that is conflicting with the tools. What other apps are running?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 7, 2011 at 11:27 am
Yes, after the uninstall of the same tools. No other apps are running. I have a feeling that this might be OS-related. Going to see if we can run a repair install of Server 2008.
July 7, 2011 at 12:24 pm
Possibly something with SQL, but I wouldn't think so if other clients can connect. Unless it's a shared DLL somewhere.
It could be OS related, but it's definitely some call in SSMS that's freezing. Have you traced SSMS on here v another client to see where it hangs? Or use something like Process Explorer (Sysinternals) to debug it?
July 7, 2011 at 12:28 pm
I have not done that yet, Steve. Thanks for the suggestion.
June 18, 2012 at 3:23 pm
Hi ,
I am facing kind of same issue with same specs .. are you able to solve this ?
Can you share please?
Thanks
Viewing 15 posts - 1 through 15 (of 17 total)
You must be logged in to reply to this topic. Login to reply