Torn page detection


    Sponsored Links


  • 1. Removing post
    I am most disappointed with this area. I posted SQL 2000 Backup yesterday at 8:48 am and 30 minutes later my email was full of viruses and spammers. How do I remove a previous post? If any moderator is around, can all my information be stripped from the record? Thx
  • 2. Sysprocesses output..ques
    hi, i found network Io in sysprocesses lastwaittype column output many times,wot is this ?? my site is working slow isit related to site. 2) output is also showing processes from last 3 days and some values in cpu,memusage,physical_io// will this cause any issues in performance. login time of last 3 days. any feedback will be highly apprec'td
  • 3. problem installing sql server 2000 on xp prof
    I am trying to install it but the installation stops after I click on next on the screen to validate the user to start the service. Then the system pops up the message to send the problem to microsoft. What can I do???
  • 4. Problems installing ms sql client tools
    Hi all, I tried to install MS SQL client tools and while I was at the option of choosing between local or remote computer, it gives me the error as shown: "A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup" I have tried restarting it several times but its still gives the same results. Does anyone have a clue to rectify this problem or can anyone tell me how do you remove the pending file operations on the installation machine?
  • 5. Uninstall 120 Day Evaluation SQL Server Databse
    Hello, i want to deinstall a 120 Day Evaluation SQL Server Database. I do not have the complete CD. What file do i have to copy that the setup.exe will run ? Thank you Ursula

Torn page detection

Postby san » Tue, 16 Sep 2003 16:40:05 GMT

Does unselecting torn page detection/auto statistics form 
server/database properties will bring performance down of 
server.. ??


Re: Torn page detection

Postby sunnya » Tue, 16 Sep 2003 17:39:55 GMT

 First of all thanks for yr mail and also for making a gr8 
These are the options which are diabled in server right 
now,with yr reply it seems that they should be always 

Db server is facing too much issues,
1) its slow and hangs down,extensive use of tempdb,more 
locks are there on server etc..etc..

performance, by
why you want to
protection. Again, why do
Server Books Online.

Torn Page Detection

Postby John Barr » Thu, 12 Feb 2004 00:26:05 GMT

Does anyone have any thoughts on using Torn Page Detection 
or not? I see where Microsoft, in there documentation, 
tells you to use it, then they say don't use it. Not sure 
what to do, or ultimately what I will gain from using it.

Re: Torn Page Detection

Postby James Goodman » Thu, 12 Feb 2004 02:18:22 GMT

Personally, I leave it on & have not found any ill-effects from doing so.
This is on the basis that a slight performance loss is better than a
torn-page going unnoticed & losing data when it eventually gets detected.


James Goodman MCSE, MCDBA

Similar Threads:

1.torn page detection and auto shrink: performance?

Hello everybody,

First: SQL Server 2000 sp3a, HP cluster server, MS 2003 server,
database recovery model simple

Torn page detection:
When I have this option turned on, processes conected with updating and
writing in database, was MUCH more slower, than if I've this option
turned off.

It seams to me, that when this option is turned on, the sqlserver is
much more slower by any operation connected with writing, than without
this option.

This option is required for ensurance, that the data are written
properly on the media.
My question is:
if I have my database running under cluster, with RAID hd system, which
contains write cache, with additional checking, that the data will be
written correctly, is it necessary for me to keep this option turned

Auto shrink:
When it is turned on, does it affect performance?
Personaly, I don't think so, but somebody is insysting on it, and I
would like to have an information from independent source about that.

Best regards


2.Full recovery and torn page detection


I would like to ask if there is any point having torn page detection turned
on if you are operating in full recovery mode.

I was under the impression that when operating in full recovery mode, if the
server loses power then the next time it restarts
any transaction will be rolled back and thus will we have have no torn

or does the recovery mode yhave nothing to do with torn page detection?

I have read that if we have torn pages the database must be restored, is
this the only option?

I take it I would be correct in assuming that torn pages are totally
different from page splits.

thank you in advance.


3.Torn Page Detection

We had this problem 2-3 times so i feel it is always 
better to leave this option ON. dbcc checkdb will able to 
catch this problem. so if u have this option off unless 
someone try to access this page u will never see this 
error and u might need to recover since last good full 
backup and all transaction log backups.


>-----Original Message-----
>Hello.  I understand what setting this option ON gives 
>and the possible performance overhead it can cause, 
>but........  let's say you GET a torn page, and this 
>option was OFF.  So, you'd have this corruption and when 
>would you get NAILED?  When you try to restore a backup 
>containing a torn page?  Would a DBCC Check catch a torn 
>page problem?  Sounds like it makes sense to turn this 
>option ON always, but I'd appreciate any opinions on 
>this...  THanks, Bruce

4.torn page detection - master

Why is the torn page detection option grayed out in Enterprise Manager for 
the master database?

If it is "OFF", should it be turned "ON" for SQL 7.0?  SQL 2000?


5.Can torn page detection fire from existing corruption?

Does torn page detection only show new errors or errors during restore or 
can it error due to a torn page that may have been in the database for a 


6. Torn Page Detection?

7. Torn Page detection unchecked

8. Newbie-Page Torn Detection - ambigious results



Who is online

Users browsing this forum: No registered users and 73 guest