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 |
|
john.burns
Posting Yak Master
100 Posts |
 Posted - 2006-10-26 : 11:00:06
|
| has anyone had a big performance improvement from turning offtorn page detection in a high CPU server.thanks |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2006-10-26 : 15:08:08
|
| What is the theory on this? I guarantee turning it off is always improve performance (and will always increase your failure exposure). But I don't see why that would affect "high CPU" servers (whatever that means) more than otherwise.Jay White |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2006-10-27 : 13:36:12
|
| I think I would track down what the cause of the High CPU utilization is and fix that rather than turning off torn page detection.Let us know if you would like some help with that.Michael<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda>Opinions expressed in this post are not necessarily those of TeleVox Software, inc. All information is provided "AS IS" with no warranties and confers no rights. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-28 : 03:05:45
|
| "turning off torn page detection"Too scary to contemplate!Kristen |
|
|
|
|
|
|
Peformance