Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DBCC CHECKDB performance Expand / Collapse
Author
Message
Posted Monday, September 3, 2012 11:47 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 2:27 PM
Points: 231, Visits: 749

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
Post #1353714
Posted Monday, September 3, 2012 11:56 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 2:53 AM
Points: 1,101, Visits: 5,290
Are the RAM, temp db and disk configurations same?
Post #1353715
Posted Tuesday, September 4, 2012 12:33 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 2:27 PM
Points: 231, Visits: 749
test make in the same server only instances are diffrent
Post #1353725
Posted Tuesday, September 4, 2012 4:54 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, October 17, 2014 4:03 AM
Points: 86, Visits: 366
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.
Post #1353805
Posted Tuesday, September 4, 2012 5:17 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 2:27 PM
Points: 231, Visits: 749
It is true ı didnt look at that
Post #1353824
Posted Wednesday, September 5, 2012 9:07 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, October 17, 2014 4:03 AM
Points: 86, Visits: 366
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?
Post #1354641
Posted Monday, June 24, 2013 5:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 16, 2014 5:12 PM
Points: 1, Visits: 15
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
Post #1466686
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse