I am using SQL Server 2008 in on of our project, I am facing an issue, sometime daily or after 1-2days at morning(08:00 to 09:00) and at evening(18:00 to 19:00) database stuck. The query which we runs directly from database it works fine but the same query we execute from ASP.NET application then it stuck, mean when we click on that page it shows in progress. I also tried to debug from live database server but on Database stuck time when we called any stored procedure EXECUTE command then it not responds. I also observe that it stuck for 30-35mints, so after that it works fine automatically.
Current Solution : We are managing by Restarting SQL Server, so as we re-start SQL server it works fine.