Changing isolation levels in the Operations Manager operational and data warehouse databases

Published Feb 15 2019 11:57 PM 187 Views
First published on TECHNET on Jan 20, 2015

~ Larry Mosley | Senior Escalation Engineer

We recently had a question about changing isolation levels in the System Center 2012 R2 Operations Manager (OpsMgr 2012 R2) operational and data warehouse databases so I wanted to pass the information along here in case anyone else might be wondering the same thing.

The Operations Manager database already has Snapshot Isolation ON and is configured for ‘Read Committed Snapshot’.

The Datawarehouse (usually OperationsManagerDW) has Snapshot Isolation OFF and is configured for ‘Read Committed’.

We do not test any other configuration.

This also applies to System Center 2012 Operations Manager with or without Service Pack 1 (SP1).

Larry Mosley | Senior Escalation Engineer | Microsoft GBS Management and Security Division

Get the latest System Center news on Facebook and Twitter :

System Center All Up: http://blogs.technet.com/b/systemcenter/

Configuration Manager Support Team blog: http://blogs.technet.com/configurationmgr/
Data Protection Manager Team blog: http://blogs.technet.com/dpm/
Orchestrator Support Team blog: http://blogs.technet.com/b/orchestrator/
Operations Manager Team blog: http://blogs.technet.com/momteam/
Service Manager Team blog: http://blogs.technet.com/b/servicemanager
Virtual Machine Manager Team blog: http://blogs.technet.com/scvmm

Microsoft Intune: http://blogs.technet.com/b/microsoftintune/
WSUS Support Team blog: http://blogs.technet.com/sus/
The RMS blog: http://blogs.technet.com/b/rms/
App-V Team blog: http://blogs.technet.com/appv/
MED-V Team blog: http://blogs.technet.com/medv/
Server App-V Team blog: http://blogs.technet.com/b/serverappv
The Surface Team blog: http://blogs.technet.com/b/surface/
The Application Proxy blog: http://blogs.technet.com/b/applicationproxyblog/

The Forefront Endpoint Protection blog : http://blogs.technet.com/b/clientsecurity/
The Forefront Identity Manager blog : http://blogs.msdn.com/b/ms-identity-support/
The Forefront TMG blog: http://blogs.technet.com/b/isablog/
The Forefront UAG blog: http://blogs.technet.com/b/edgeaccessblog/

%3CLINGO-SUB%20id%3D%22lingo-sub-350122%22%20slang%3D%22en-US%22%3EChanging%20isolation%20levels%20in%20the%20Operations%20Manager%20operational%20and%20data%20warehouse%20databases%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-350122%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20TECHNET%20on%20Jan%2020%2C%202015%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3E%3CSTRONG%3E%20%3CEM%3E%20~%20Larry%20Mosley%20%7C%20Senior%20Escalation%20Engineer%20%3C%2FEM%3E%20%3C%2FSTRONG%3E%3C%2FP%3E%0A%20%20%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F81976i4878699C21DDCD5D%22%20%2F%3E%20We%20recently%20had%20a%20question%20about%20changing%20isolation%20levels%20in%20the%20System%20Center%202012%20R2%20Operations%20Manager%20(OpsMgr%202012%20R2)%20operational%20and%20data%20warehouse%20databases%20so%20I%20wanted%20to%20pass%20the%20information%20along%20here%20in%20case%20anyone%20else%20might%20be%20wondering%20the%20same%20thing.%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3EThe%20Operations%20Manager%20database%20already%20has%20Snapshot%20Isolation%20ON%20and%20is%20configured%20for%20%E2%80%98Read%20Committed%20Snapshot%E2%80%99.%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3EThe%20Datawarehouse%20(usually%20OperationsManagerDW)%20has%20Snapshot%20Isolation%20OFF%20and%20is%20configured%20for%20%E2%80%98Read%20Committed%E2%80%99.%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3EWe%20do%20not%20test%20any%20other%20configuration.%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3EThis%20also%20applies%20to%20System%20Center%202012%20Operations%20Manager%20with%20or%20without%20Service%20Pack%201%20(SP1).%3C%2FP%3E%0A%20%20%3CP%3E%3CB%3ELarry%20Mosley%20%3C%2FB%3E%20%3CSTRONG%3E%20%7C%20Senior%20Escalation%20Engineer%20%7C%20Microsoft%20GBS%20Management%20and%20Security%20Division%3C%2FSTRONG%3E%3C%2FP%3E%0A%20%20%3CP%3E%3CB%3EGet%20the%20latest%20System%20Center%20news%20on%20%3C%2FB%3E%20%3CA%20href%3D%22https%3A%2F%2Fwww.facebook.com%2Fpages%2FMicrosoft-System-Center-Support%2F111513322193410%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20%3CB%3E%20Facebook%20%3C%2FB%3E%20%3C%2FA%3E%20%3CB%3E%20and%20%3C%2FB%3E%20%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2F%23!%2FMS_SystemCenter%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20%3CB%3E%20Twitter%20%3C%2FB%3E%20%3C%2FA%3E%20%3CB%3E%20%3A%3C%2FB%3E%3C%2FP%3E%0A%20%20%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F81977i416414AA808286FD%22%20%2F%3E%20%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F81978i63B18C11511D10C9%22%20%2F%3E%3C%2FP%3E%0A%20%20%3CP%3ESystem%20Center%20All%20Up%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fb%2Fsystemcenter%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fb%2Fsystemcenter%2F%3C%2FA%3E%3C%2FP%3E%0A%20%20%3CP%3EConfiguration%20Manager%20Support%20Team%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fconfigurationmgr%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fconfigurationmgr%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20Data%20Protection%20Manager%20Team%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fdpm%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fdpm%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20Orchestrator%20Support%20Team%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fb%2Forchestrator%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fb%2Forchestrator%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20Operations%20Manager%20Team%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fmomteam%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fmomteam%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20Service%20Manager%20Team%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fb%2Fservicemanager%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fb%2Fservicemanager%20%3C%2FA%3E%20%3CBR%20%2F%3E%20Virtual%20Machine%20Manager%20Team%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fscvmm%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fscvmm%3C%2FA%3E%3C%2FP%3EMicrosoft%20Intune%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fb%2Fmicrosoftintune%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fb%2Fmicrosoftintune%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20WSUS%20Support%20Team%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fsus%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fsus%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20The%20RMS%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fb%2Frms%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fb%2Frms%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20App-V%20Team%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fappv%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fappv%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20MED-V%20Team%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fmedv%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fmedv%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20Server%20App-V%20Team%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fb%2Fserverappv%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fb%2Fserverappv%20%3C%2FA%3E%20%3CBR%20%2F%3E%20The%20Surface%20Team%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fb%2Fsurface%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fb%2Fsurface%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20The%20Application%20Proxy%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fb%2Fapplicationproxyblog%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fb%2Fapplicationproxyblog%2F%3C%2FA%3E%3CP%3EThe%20Forefront%20Endpoint%20Protection%20blog%20%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fb%2Fclientsecurity%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fb%2Fclientsecurity%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20The%20Forefront%20Identity%20Manager%20blog%20%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.msdn.com%2Fb%2Fms-identity-support%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.msdn.com%2Fb%2Fms-identity-support%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20The%20Forefront%20TMG%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fb%2Fisablog%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fb%2Fisablog%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20The%20Forefront%20UAG%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fb%2Fedgeaccessblog%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fb%2Fedgeaccessblog%2F%3C%2FA%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-350122%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20TECHNET%20on%20Jan%2020%2C%202015%20~%20Larry%20Mosley%20%7C%20Senior%20Escalation%20Engineer%20We%20recently%20had%20a%20question%20about%20changing%20isolation%20levels%20in%20the%20System%20Center%202012%20R2%20Operations%20Manager%20(OpsMgr%202012%20R2)%20operational%20and%20data%20warehouse%20databases%20so%20I%20wanted%20to%20pass%20the%20information%20along%20here%20in%20case%20anyone%20else%20might%20be%20wondering%20the%20same%20thing.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-350122%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESystem%20Center%20Operations%20Manager%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Mar 11 2019 10:16 AM
Updated by: