Hi, i have on my sql server every day the error message: blocked for more than 120 seconds ...
i must hard restart the vm.
hardware of host are ok.
on test i have use the host as sql srever, it works fine and without errors. only on vm the error comes.
following link i have used, but without solution: http://www.blackmoreops.com/2014/09...ask_timeout_secs-blocked-120-seconds-problem/
problem are the same.
any ideas?
best regards
i must hard restart the vm.
hardware of host are ok.
on test i have use the host as sql srever, it works fine and without errors. only on vm the error comes.
following link i have used, but without solution: http://www.blackmoreops.com/2014/09...ask_timeout_secs-blocked-120-seconds-problem/
problem are the same.
any ideas?
best regards