November 5, 2012 at 11:57 pm
Hi all,
What will the impact of setting the database to read-only be? Will performance improve on reading? If so why and is there a way to measure this improvement?
Regards
Kristian
November 6, 2012 at 2:40 am
This was removed by the editor as SPAM
November 6, 2012 at 4:40 am
That can be accomplished by using the NOLOCK hint?
November 6, 2012 at 4:50 am
In terms of measuring the improvement, simply run a (typical) query before setting the DB to read only and measure the CPU impact etc ...
Then set your DB ot RO and run the same query again
Then compare results.
See http://msdn.microsoft.com/en-us/library/ms190287.aspx
and
http://msdn.microsoft.com/en-us/library/ms184361.aspx
USE AdventureWorks2012;
GO
SET STATISTICS IO ON;
GO
SET STATISTICS TIME ON;
GO
SELECT *
FROM Production.ProductCostHistory
WHERE StandardCost < 500.00;
GO
SET STATISTICS IO OFF;
GO
SET STATISTICS TIME OFF;
GO
HTH,
B
November 6, 2012 at 4:56 am
Thanks! Most helpful!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply