sql server - SSMS Not Responding in Object Explorer -


having issue whenever view/edit tables in server ssms becoming non-responsive. ssms fine until moment go view/edit object object explorer , locks up. smss remains @ 12% cpu, no increased ram consumption on time.

following aaron bertrand's post querying existing sessions, 4-5 entries follows:

g-- dbcc inputbuffer(58)    -- current task : ?    -- % complete : n/a    -- kill 58

if kill them, smss instance still hangs.

have update/uninstalled/reinstalled current version of ssms 2016: 

microsoft sql server management studio                      13.0.16106.4 microsoft analysis services client tools                        13.0.1700.441 microsoft data access components (mdac)                     10.0.14393.0 microsoft msxml                     3.0 6.0  microsoft internet explorer                     9.11.14393.0 microsoft .net framework                        4.0.30319.42000 operating system                        6.3.14393

have tried 17 rc same issue:

microsoft sql server management studio                      14.0.17028.0 microsoft analysis services client tools                        14.0.338.80 microsoft data access components (mdac)                     10.0.14393.0 microsoft msxml                     3.0 6.0  microsoft internet explorer                     9.11.14393.0 microsoft .net framework                        4.0.30319.42000 operating system                        6.3.14393

have un/reinstalled local db i'm connecting (2016 developer). queries application fine, it's browsing objects in smss that's causing grief. can open smss , query databases fine.

everything has been fine, recent system change migration vs2017 community (smss has been working ok since install). have uninstalled vs2017 safe.

any suggestions? have dev machine non-functional, not sure if quicker format.


Comments

Post a Comment

Popular posts from this blog

c# - Update a combobox from a presenter (MVP) -

i using mvp in project, new in mvp. have 2 comboboxes. when select option in combobox, combobox should filled new data. this action in presenter. view 'view1' in presenter, , introduced combobox1 , combobox2 properties in 'view1', because need 'datasource', 'displaymember', 'valuemember' , 'refresh()' in method below. but, when using pattern, enough send property like public string combobox2 { { return combobox1.selectedvalue.tosstring(); } } into presenter not whole combobox. how can solve problem? public void onselectedindexchangedcombobox1() { if (view1.combobox1.selectedindex == -1) { return; } datatable dt = tools.getdatatable("a path"); var query = (from o in dt.asenumerable() o.field<string>("afield") == farmerview.combobox1.selectedvalue.tostring() orderby o.field<string>("anotherfield") select...
Read more

How to understand 2 main() functions after using uftrace to profile the C++ program? -

i trying uftrace profile following simple c++ program: #include <iostream> class { public: a() {std::cout << "a created" << std::endl;} ~a() {std::cout << "a destroyed" << std::endl;} }; int main() { a; return 0; } the profile result this: # uftrace a.out created destroyed # duration tid function 2.026 [ 4828] | __cxa_atexit(); [ 4828] | main() { [ 4828] | __static_initialization_and_destruction_0() { 89.397 [ 4828] | std::ios_base::init::init(); 0.768 [ 4828] | __cxa_atexit(); 93.029 [ 4828] | } /* __static_initialization_and_destruction_0 */ 94.425 [ 4828] | } /* main */ [ 4828] | main() { [ 4828] | a::a() { 11.104 [ 4828] | std::operator <<(); 10.825 [ 4828] | std::basic_ostream::operator <<(); 24.514 [ 4828] | } /* a::a */ [ 4828] | a::~a() { 0.978 [ 4828] | ...
Read more

How to put a lock and transaction on table using spring 4 or above using jdbcTemplate and annotations like @Transactional? -

i trying put lock on table while writing on table , if happened in between roll-back . trying convert below code lock table test_g1 read; lock table test_g write; -- begin; start transaction; insert test_g1 values(143); insert test_g values(145); select * test_g1; select * test_g; rollback; select * test_g; unlock tables; how convert above code @transactional spring jdbctemplate code? @transactional(rollbackfor={dataaccessexception.class}) public void test(){ jdbctemplate.execute("insert test1 (id, nam) values (4, 'a')"); throw new dataaccessexception("error") { }; } here trying throw error, insert statement should rollback it's not happening . thanks edit-1 attaching code , doing in jdbcdaoimpl.java , mentioned problem comment above test() . app.java package com.cgiri.javabrains.spring4; import org.springframework.beans.factory.annotation.autowired; import org.springframework.context.applic...
Read more