Can someone show me with an example what the difference betweent these two are?
please help me
View Complete Post
I must misunderstand something here. I have altered the DB to allow READ_COMMITTED_SNAPSHOT and some deadlock situations have been solved. Nevertheless, in a very similar situation, I'm getting deadlocks and the deadlock graph (XML) shows me the following:
isolationlevel="read committed (2)"
What do I miss here?
I get below in Blocked Process Report. I understand READ COMMITTED, but what (2) signifies? Also why process status is listed as "suspended"?
<process status="suspended" waittime="97" spid="55" sbid="0" ecid="0" priority="0" trancount="0" lastbatchstarted="2010-09-29T12:25:08.143" lastbatchcompleted="2010-09-29T12:25:08.023" clientapp="Internet Information Services" hostname="WEBAPP6"
hostpid="2216" loginname="masteruser" isolationlevel="read committed (2)" xactid="735041142" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
I have a customer that is getting long blocking chains caused by reporting against OLTP data. I have successfully setup replication to report against a subset of the tables for another customer and this has worked fine. The only downside to this, besides
the replication performance impact, is that if many reports are running and updates are happening at the same time, the second report (and up) will be blocked. The blocking chain is the first report blocks the replication agent which blocks
the second report and so on. This is probably acceptable but I want to make sure it is the best option. Therefore, I would like to look into using either read committed snapshot isolation (RCSI) or the snapshot isolation (SI).
1) Are RCSI and SI mutually exclusive options? From my testing, I could turn on one without turning on the other. However, I read a blog that said you can only turn on SI once RCSI has been turned on for the database. Is this true? I am assuming the blog
2) If I only turn on SI and only ever use a "SET TRANSACTION ISOLATION LEVEL SNAPSHOT" statement in read only reports, the application (non-reports) should function the exact same correct? (Excluding the added tempdb space used). Obviously a huge dilemma
with setting any of these snapshot levels is trying to prevent the changes to how the applicati
I need some help with video embedding in ASP.NET. So I am developing a litle custom blog and I need users to upload Quick Time videos (.mp4,.3gp) but I also need when upload completes to take a snapshot from the uploaded video which should be used as a link to a page that plays the video, in other words I need to take a frame from this video file... Do you have any idea how this is possible??
Thanks in advance