Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-11-11 : 02:14:46
|
| Dear All,i've read in an article that several isolation levels we can use to avoid dead locks, and we can improve the performance also. please let me know how to know which isolation level is there in my database?which one is the best for production server and which is the best for reports server....please guide me hereArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2008-11-11 : 02:31:03
|
| you can check your isolation level by DBCC USEROPTIONS, but by default it would be READ COMMITTED |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-11-11 : 02:37:55
|
| thankyou very muchArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-11-11 : 02:42:46
|
| which isolation is good for production environment?is it good repeatable read isolationArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-11-11 : 04:54:42
|
| usually the read committed is enough. but it really depends on what your business requirements are.there is no one correct prod isolation level._______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.1 out! |
|
|
|
|
|
|
how to know which isolation level is there