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

SQL 2012 SSAS performance issue Expand / Collapse
Author
Message
Posted Wednesday, June 05, 2013 12:39 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, November 09, 2013 1:51 AM
Points: 17, Visits: 176
Hi,

We had upgraded our SSAS instance with SQL2012 Sp1 and Prior to this up gradation of SP1 there were no performance issue on the server. Post up gradation we are getting performance issue on SSAS instance. To resolve the same we had applied hotfix build ID: 11.0.3335
"FIX: Component installation process freezes after you install SQL Server 2012 SP1"
But still the issue is not resolved and we are left with no option but to restart the servers after that everything has been resolved. This happens every day morning between 9:00 AM to 10 AM. The memory & CPU utilization is below 40 %.
When this performance issue happen SSMS goes into hung mode and after server reboot everything works normal.

Server configuration:
OS: Win2k8 R2 STD
SQL SERVER 2012 Enterprise Edition SP1 CU 11.0.3335
Dual proc 8 Core
64 GB RAM

Kindly help us to resolve this issue

Regards,
vinod K
Post #1460047
Posted Wednesday, June 05, 2013 6:24 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Sunday, April 13, 2014 11:43 PM
Points: 1,781, Visits: 3,340
Sounds like you should probably make a call to Microsoft Support...


Steve.
Post #1460200
Posted Wednesday, June 05, 2013 7:20 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, November 09, 2013 1:51 AM
Points: 17, Visits: 176
Thanks steve,

Is there any Best practices for SSAS configuration

Memory, max degree of parallelism etc..

Regards,
Vinod K

Post #1460227
Posted Tuesday, June 11, 2013 12:42 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, November 09, 2013 1:51 AM
Points: 17, Visits: 176
Hi,

Issue was resolved after applied SQL2012 Cumulative Hotfix 3

http://support.microsoft.com/kb/2812412?wa=wsignin1.0


Regards,
Vinod K
Post #1461883
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse