| Author |
Topic |
|
tfountain
Constraint Violating Yak Guru
491 Posts |
 Posted - 2008-06-27 : 14:15:22
|
| Has anyone configured their databases for either statement level read consistency or transaction level read consistency? If so which model did you choose and what where your factors in choosing one over the other?For those that have migrated to either of these models... what issues did you run into (if any)? Where there considerations for tempdb that needed to be implemented?Again, thanks for your responses on this! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-27 : 14:23:25
|
| Check this out:http://www.sqlservercentral.com/articles/SQL+Server+2005/62464/ |
 |
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2008-06-27 : 15:48:06
|
| Good read. I read the MS version on their site but as usual... it's long and lengthy and I almost fell asleep :).I'm really thinking I want to go to this model. I see no cons (other than the resource related concerns but we just plan for that accordingly) and all pros. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-27 : 15:54:43
|
| Remember if you are going Row-versioning method, it does all its operation in TempDB. So TempDB should be efficient enough to take loads as well. |
|
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2008-06-27 : 16:18:30
|
quote:
Originally posted by sodeep
Remember if you are going Row-versioning method, it does all its operation in TempDB. So TempDB should be efficient enough to take loads as well.
quote:
Originally posted by tfountain...I see no cons (other than the resource related concerns but we just plan for that accordingly)...
|
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-27 : 16:30:39
|
| Tfountain, That doesn't explain what people are looking for. Resource contention speaks many issues in SQL server. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-28 : 00:09:59
|
| Many sql2k5 features use row versioning, online index is one. |
|
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2008-06-30 : 11:28:55
|
quote:
Originally posted by sodeep
Tfountain, That doesn't explain what people are looking for. Resource contention speaks many issues in SQL server.
If you keep in context with the topic and the link you supplied, it makes perfect sense. The statement regarding resource issues was referring directly to the various issues that need to be taken into consideration for this setup (i.e. tempdb space mainly). |
|
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2008-06-30 : 11:34:06
|
quote:
Originally posted by rmiao
Many sql2k5 features use row versioning, online index is one.
I did run across this statement somewhere else too. Since online indexing works w/o this (we do it now), I can only assume that the performance of an online index operation can be boosted if one of these methods are implemented as well. |
|
|
|
|
Opinions on row versioning in SQL Server 2005