November 19, 2012 at 12:33 am
Could you tell me , Which is best isolation level for SSIS and T- SQL ?
anyone advice me..
Thanks
solomon
November 19, 2012 at 10:25 am
Best for what? Performance, data integrity, minimal impact on the source system.....the list goes on.
November 19, 2012 at 10:30 am
The best isolation level is the one that best fits the needs of your requirements.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
November 19, 2012 at 10:43 am
Most of the time, Read Committed (the default level) will do what you want and is "the best". If you have specific needs, then pick something else, but, most of the time, the default is the best.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 19, 2012 at 7:09 pm
performanace...
November 20, 2012 at 7:27 am
solomon.jernas (11/19/2012)
performanace...
Are you saying you want the best performance? We can't tell you what is best. Read what G2 said above, unless there is a definitive reason to do otherwise, the default is probably your best option.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
November 20, 2012 at 7:33 am
solomon.jernas (11/19/2012)
performanace...
You'll have to clarify that.
In most cases, Read Committed will peform just fine. In a few, Read Committed Snapshot, or Snapshot, will perform better. In a few Serializable will actually perform better.
It all depends on what you're doing with the data, how the data is structured, and what you expect applications and users to want from the data and application(s).
If what you're looking for is some sort of recommendation that Read Uncommitted or NoLock will "perform better", you won't get that, because it's false. If you're fishing for that recommendation (I don't know if you are or not), then I'll say what I say ever time that comes up. Yes, it can be faster in some circumstances, so long as you don't mind getting wrong data slightly faster. And it's not faster than other isolation levels (RCSI or SI are often just as fast or faster, so is RC under many circumstances). Sometimes it is, but "fast and wrong" isn't a good solution in the vast majority of cases.
So, performance and locking characteristics really depend on your situation. There is no "Run Faster" option in SQL Server.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply