When a SQL Server application becomes slow, one of the first questions should be: What is SQL…