Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL 2012 SSAS performance issue


SQL 2012 SSAS performance issue

Author
Message
kochu.vinod
kochu.vinod
Grasshopper
Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)

Group: General Forum Members
Points: 20 Visits: 226
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
stevefromOZ
stevefromOZ
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: Moderators
Points: 1929 Visits: 3754
Sounds like you should probably make a call to Microsoft Support...

Steve.
kochu.vinod
kochu.vinod
Grasshopper
Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)

Group: General Forum Members
Points: 20 Visits: 226
Thanks steve,

Is there any Best practices for SSAS configuration

Memory, max degree of parallelism etc..

Regards,
Vinod K
kochu.vinod
kochu.vinod
Grasshopper
Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)

Group: General Forum Members
Points: 20 Visits: 226
Hi,

Issue was resolved after applied SQL2012 Cumulative Hotfix 3

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


Regards,
Vinod K
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search