May 19, 2010 at 10:17 pm
i read the foll. article of Brad McGehee
http://www.sql-server-performance.com/articles/audit/2005_database_configuration_p2.aspx
here in Page_Verify part he has said that
if page_verify option is
None - least protection but Performance is highest - AGREE
CHECKSUM -best tradeoff in protection and performance.
Torn_Page_Detection- best protection, but the least performanc
Here the question is in highlighted options Torn_Page_Detection gives least performance. is that true?
i think Torn_Page_Detection gives more performance than checksum.
what are ur opinions?
Sanket Ahir
Don't run behind the success, Try to be eligible & success will run behind u......
May 19, 2010 at 11:32 pm
I think I would swap the descriptions between checksum and torn page detection.
reference:
http://msdn.microsoft.com/en-us/library/aa337525.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 20, 2010 at 4:43 pm
Brad is normally very good, but I think he got this one back to front. CHECKSUM checks every bit on the page and creates the checksum, written to the page header. Hence you take a performance hit, but if a single bit changes you will pick it up.
Torn_Page_Detection only tracks that the pages follow on one after the other correctly. It's fairly efficient, but doesn't provide a lot of protection.
Leo
Striving to provide a better service.
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
May 20, 2010 at 5:06 pm
Leo.Miller (5/20/2010)
Brad is normally very good
Agreed. It is good to verify what one says because people do occasionally make mistakes.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply