SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 SSMS 2012 crashes quite often...
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Cowski
Starting Member

USA
29 Posts

Posted - 06/25/2013 :  15:58:09  Show Profile  Send Cowski an ICQ Message  Reply with Quote
I just started working at a new company. I'm coming from SQL Server 2008 and this company is running Microsoft SQL Server Management Studio 11.0.3128.0.

At least 5+ times a day it crashes with the following error results:

Problem signature:
Problem Event Name: BEX
Application Name: Ssms.exe
Application Version: 2011.110.3000.0
Application Timestamp: 5081c1cd
Fault Module Name: StackHash_0a9e
Fault Module Version: 0.0.0.0
Fault Module Timestamp: 00000000
Exception Offset: 4d83f04d
Exception Code: c0000005
Exception Data: 00000008
OS Version: 6.1.7601.2.1.0.256.1
Locale ID: 1033
Additional Information 1: 0a9e
Additional Information 2: 0a9e372d3b4ad19135b953a78882e789
Additional Information 3: 0a9e
Additional Information 4: 0a9e372d3b4ad19135b953a78882e789





My manager says "Welcome to SSMS 2012' memory leak." and says not much he's been able to find to do about it. I thought I'd just look to be proactive about it.

Has anyone else encountered this with 2012?? If they have, do you know of a fix?

Thanks!!

tkizer
Almighty SQL Goddess

USA
35951 Posts

Posted - 06/25/2013 :  16:24:35  Show Profile  Visit tkizer's Homepage  Reply with Quote
I don't have any issues with SSMS 2012 crashing, and I'm running it on lots of different machines. Perhaps you should try installing SP1 and the latest CU?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Cowski
Starting Member

USA
29 Posts

Posted - 06/26/2013 :  08:55:44  Show Profile  Send Cowski an ICQ Message  Reply with Quote
We're on the latest & greatest. v11.0.3128.0 I've tried running the CU but it won't run because it says I'm on the latest & greatest. I did a repair to see if this fixes it. If not, I'm wondering if a uninstall/reinstall could fix it?
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3323 Posts

Posted - 06/26/2013 :  10:21:02  Show Profile  Reply with Quote
Not exactly a useful suggestion to solve your problem, but in case it will add anything to the puzzle:

I am using exactly the same version, and I use it all day without any issues problems - no crashes, no freeze ups. So I am suspecting that it may be the interaction of some other software - antivirus, provirus (aka virus), other software etc. that is causing your crashes.
Go to Top of Page

lfagetti
Starting Member

USA
1 Posts

Posted - 07/09/2013 :  10:07:40  Show Profile  Reply with Quote
I have the same problem.
Here is a detail that may help:
After installing SQL2012 I had to install VS2010 SP1 to be able to interface with TFS 2012 (it seems that the VS shell coming with SQL 2012 is not sufficient to handle the TFS add-in).
I did not work much in SSMS before the VS2010 install, therefore I cannot say with certainty that the problem was already existing or not.



Go to Top of Page

Cowski
Starting Member

USA
29 Posts

Posted - 07/09/2013 :  12:18:06  Show Profile  Send Cowski an ICQ Message  Reply with Quote
Good afternoon, all!!

I think I discovered what my problem was. Wasn't SSMS 2012 at all. Turned out to be a add-on from APEXSQL called "ApexSQL Complete". It's a rather robust, free, intellisense add-on I tried. It has more bells & whistles than what is built into SSMS. I uninstalled that and <knock on wood> haven't had an issue since! It's been well over a week.

Thank you to all that replied to this thread! Hopefully this will help someone else in the future.


Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35951 Posts

Posted - 07/10/2013 :  19:06:20  Show Profile  Visit tkizer's Homepage  Reply with Quote
Glad you got it sorted. Have used ApexSQL in the past but don't currently have it installed.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

xyvyx
Starting Member

USA
6 Posts

Posted - 09/03/2013 :  16:37:16  Show Profile  Reply with Quote
Yeah, I'm having similar issues. In my case, I thought maybe the RedGate plugins were causing some sort of instability... and perhaps they were. I removed all 3rd-party add-ins to SSMS, un-installed & re-installed SSMS. For a while, it WAS more stable! I've been using the 2012 SQL tools for just over 3 weeks without a crash! Anyway, it tanked again today. Luckily, I'd saved my work... I mean, one gets in the habbit when the application you use most and rely on becomes the most unstable too in your arsenal.

I submitted some minidump files to Walter Jokiel & Charles Gagnon based on the following post:
https://connect.microsoft.com/SQLServer/feedback/details/770754/sql-server-2012-management-studio-crashes



"If we can put it into a table, we can kill it"
-Ahnold Sequelnator
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000