Monday, December 06, 2010

SQL2008 bug?

Can this case happen:
From the TASK MANGER show SqlServer is running(status).
but actually the SqlServer is non-responsive.
Cause i click/type ... there is no response at all.

* but other app is running normal.
* that time, sql server is doing nothing. no loader/IIS/query.

from application show runnnig
from performance show normal(not high CPU). is up and down..
from processes: it show normal. like sql is OPEN.

seem like not memory low.
- there is no notice
- and other app is run normal. not feel any slow or what.

finally end task.
- when end task, it say the sql server non-reponsive
- reopen, query no recovery
-------------------------------------------------
suspect:
- virtualbox? the sqlserver(32bit) is stay in virtualbox, win2003(32bit).
the virtualbox is also win2003(32bit)

- OS, when connection(remote) from few place. when disconnection, it cause the active widnows to HANG.
so when reconnect to there... other app work, but the sqlserver remain HANG.(possible need to reconnect from previous place to solve it.

3 comments:

cK said...

http://stackoverflow.com/questions/4073055/sql-server-2008-cdc-non-responsive-stuck-after-table-dropped/4362829#4362829

cK said...

http://www.questionhub.com/StackOverflow/4073055

cK said...

Suggestion:
- restart sqlserver/sqlagent service.