SnapShot Isolation Level

[ptheriault]

I am trying to figure out if I can reduce the amount of blocking I am seeing on my database by setting the db isolation level to snapshot. From what I have read it should. Has anyone worked with this Isolation level. are there any cons to changing this setting.

Here is the link to mdsn.

http://msdn2.microsoft.com/en-us/library/tcbchxcb.aspx

- Paul
- Database performance looks fine, it must be the Network!

 

[Catadmin]

From what I understand, and I haven't tried it myself, this should actually help reduce blocking.

However, notice the parts of the article referring to the storing of data in the TempDB. If you're going to use it at all, put TempDB on a separate volume and make sure it has TONS of space, or your issue is going to be just as bad if not worse.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[ptheriault]

I already have my tempdb on a seperate array. I was thinking the same thing. I put that under cons. I really can't find anyone or anything bad about using it. I'm going to give it a try. I'll see if it helps with some of our blocking problems.

- Paul
- Database performance looks fine, it must be the Network!

 

[Catadmin]

Let us know how it works. I, for one, would be really interested in the details.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"