Cumulative Updates – SQL Server 2012 SP1 CU7

As part of their Incremental Service Modelling, Microsoft have released SQL Server 2012 Service Pack 1 Cumulative Update #7.

To apply this cumulative update package, you must be running SQL Server 2012 SP1. So it is pertinent for versions 11.0.3000 — 11.0.3381.0 but is not  for SQL Server 2012 RTM (11.0.2100 — 11.0.2999).

The build number of the cumulative update package is 11.0.3393.0. You may have to restart the computer after you apply this cumulative update package.

This CU contains 47 fixes, more than double the previous release.

w/r/t SSAS 2012, the fix below seems significant as if you are using role based permissions with service accounts then you may get a performance enhancement (but only if you are running in tabular data mode)
FIX: It takes much longer for a user without administrator permissions to run an MDX query than an administrator user in SSAS 2012.

There is also a potential memory leak issue if you are running SQL Server 2012 SP1 CU3:
FIX: Slow SQL Server performance and a memory leak occurs after you apply Cumulative Update 3 for SQL Server 2012 Service Pack 1.

Author: Richie Lee

Full time computer guy, part time runner. Full time Dad, part time blogger. Knows a thing or two about Pokémon. Knows too much about SQL Agent. Writer of fractured sentences. Maker of the best damn macaroni cheese you've ever tasted.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s