On using Sql server as database in Ruby on Rails we face zombie state problem.
the solution for this problem is to keep all the transactions in the begin and end block and further commit this transaction.
This solution help me a lot. You buddy can also try this.
sql_query = ActiveRecord::Base.connection();
sql_query.begin_db_transaction
.........Your code...............
sql_query.commit_db_transaction