The problem This afternoon, out of the blue, the development folks called over wanting to know why the DB server was not responding, sure enough the databases were not accessible from application and from MMS. I knew there weren’t any maintenance happening and so I logged in to the server remotely and found that the sql services were still running as usual and the services had not restarted. To my surprise, in 10-15 mins everyone was able connect to the server again. My first thoughts were, it would have been an issue with the network and due to the glitch the servers weren’t accessible during the time period. Environment details : - The sql server were on a hyper v with a single CPU and 1024 memory - There was 80 + transaction replications setup and further 20-30 sql ser...
This blog is to, share the encounters and learning’s of Sql Server