1. hooperdba New Member

   Has anyone had dramatic performance improvement from
   turning off torn page detection on a high (90%)cpu server.
   Thanks

   hooperdba, Oct 26, 2006

   #2
2. satya Moderator

   Not in all cases at my end, but you should test it before attempting on production server.
   
   http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx fyi.
   
   Satya SKJ
   Microsoft SQL Server MVP
   Contributing Editor & Forums Moderator
   http://www.SQL-Server-Performance.Com
   This posting is provided AS IS with no rights for the sake of knowledge sharing.

   satya, Oct 26, 2006

   #2
3. joechang New Member

   i have never seen a case of high cpu due to torn page
   it is always due to queries or some other traceable cause

   joechang, Oct 27, 2006

   #2

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in