What are differences between a latch and a lock? What are the different states of an spid in SQL Server? Explain each state. What are…