Day one of my SQL Server Monitoring Week: clients often ask which tool fits them best after a Health Check. Today I briefly look at Database Performance Analyzer.
SQL SERVER – 5061: FIX Error: ALTER DATABASE failed because a lock could not be placed on database ‘Database Name’. Try again later.
Trying to take a test database offline, we hit Msg 5061: ALTER DATABASE failed because a lock could not be placed on database. Here is how to fix it.