Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Query to tell when Isolation level was set... Expand / Collapse
Author
Message
Posted Sunday, November 18, 2012 10:27 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, April 17, 2014 12:57 PM
Points: 461, Visits: 1,265
Hi -

I need a way to find out when an isolation level was last set on a database (or originally set and is the same since). Reason being is due to an issue right now at my place of business that is swearing we were using SNAPSHOT ISOLATION when in fact it is listed as the default - RED COMMITTED (and all of our code is indicative of the default because the use of WITH(NOLOCK) is everywhere.

I came up with this, but my feeling is that this is the creation date of the database, and not the last time the isolation level was set...

SELECT name, create_date, snapshot_isolation_state_desc, is_read_committed_snapshot_on 
FROM sys.databases

Any help with this would be really appreciated.

Thank you all in advance!

SQL_ME_RICH
Post #1386149
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse