Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Boost of performance to SQL Server 2012
Message
From
09/04/2014 09:54:35
 
 
To
09/04/2014 00:44:29
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01598327
Message ID:
01598346
Views:
49
>I have switched the SQL Server 2012 to run in SQL Server 2012 instead of the emulation to 2008. So far, having removed the emulation, is being reported by two users that the impression is that this is very fast. Is it the case that it should be faster?

I'm not aware of any reason why that would be the case. SQL 2012 has some big performance boosts with the new columnstore index, and they rewrote the buffer pool associated with that. But out of the box, to the best of my knowledge I wouldn't expect SQL 2012 to be faster just by removing the emulation.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform