September 3, 2012 at 11:47 pm
I have a server and two instance SQL SERVER 2008 R2 SP2
and SQL SERVER 2012 and firstly ı try DBCC CHECKDB in SQL SERVER
2008 R2 2 times and it takes 5 hours and 30 minutes after
I deattched db and ı atched db to SQL SERVER 2012 and
ı try DBCC CHECKDB in SQL SERVER 2012 and it takes
2 hours and 28 minutes what is the new feature of SQL SERVER 2012
September 3, 2012 at 11:56 pm
Are the RAM, temp db and disk configurations same?
September 4, 2012 at 12:33 am
test make in the same server only instances are diffrent
September 4, 2012 at 4:54 am
Do both instances of SQL Server have the same memory allocation?
In SSMS
- Right-click on the server name and select 'Properties'
- Select the 'Memory' option.
- There is a 'Maximum server memory (in MB) section.
September 4, 2012 at 5:17 am
It is true i didnt look at that
September 5, 2012 at 9:07 am
Hi,
Did you manage to check the SQL Server max memory parameter in both instances?
Were they different?
If so, were you able to make the parameters the same and re-test?
June 24, 2013 at 5:02 am
It is due to the page and object batching improvements that came into SQL Server 2012.
Although there was a CU in 2008 R2
Bob ward explains the story here
http://blogs.msdn.com/b/psssql/archive/2012/02/23/a-faster-checkdb-part-ii.aspx
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply