How do you use cloud databases? Take the survey.
diagnosing SQL server locks
We have a SQL 2017 Server running on Windows Server 2019. The server locks, almost on a schedule, each day around 3:30-5:00. We can wait for it to open up. Activity monitor on SSMS doesn't show anything out of the ordinary and reports show no locks. This server is ONLY SQL and no other software running. At the recommendation of a good friend I've installed SQL Monitor in hopes of finding a solution. Can anyone recommend a specific place I should start looking? This is pretty much stopping the company during this time. Thanks for the input!!
0 · Share on Twitter