Different isolation levels defined in SQL Sever

Explain different isolation levels defined in SQL Sever.

Isolation levels determine the degree of isolation of data during concurrent access.

Read Uncommitted, Read Committed, Repeatable Read, Serializable are the different isolation levels defined in SQL Server.
The default SQL Server isolation level is Read Committed.
SET TRANSACTION ISOLATION LEVEL
allows to define the isolation level at the connection level
What is lock escalation?
Lock escalation is the process of converting low level locks (row locks, page locks) into higher level locks (table locks)........
Define SQL Profiler
SQL Profiler is used to diagnose a problem by capturing events in a trace file......
Explain SQL Server Service Manager
SQL Server Service Manager is used to start, stop, and pause SQL Server services that exist as the separate components on the server......
Post your comment