16 reputation
3
bio website
location
age
visits member for 1 year, 5 months
seen Sep 24 '13 at 8:18

Nov
2
awarded  Supporter
Nov
2
awarded  Editor
Nov
2
revised Why is my CPU usage increase after setting database to read-only on SQL Server 2008 R2
added 565 characters in body
Nov
2
comment Why is my CPU usage increase after setting database to read-only on SQL Server 2008 R2
@MartinSmith : I'm not sure how to supply a repro. I'll try to detail more.
Nov
2
comment Why is my CPU usage increase after setting database to read-only on SQL Server 2008 R2
The copy is not the issue the copyied data are fine, indexes are rebuild and statistics updated before setting to read-only mode. The issue is the denormalization process that get slow and it does not refere anytime to the read-only DB. They just share the same server.
Nov
2
awarded  Student
Nov
2
asked Why is my CPU usage increase after setting database to read-only on SQL Server 2008 R2