January 25, 2013 at 4:26 am
Hi ALL ,
I want to stop the Restoring of cube because it has taken almost 7 hours and yet we were not able to know the reason for it and still continuing, could anybody please suggest about the Stopping the Restore of cube . The Restore of cube was started using the Jobs and it is the last step among the other steps related to the cube .
January 25, 2013 at 4:41 am
Restarting the service should do this
You could see if there are connections to the server that you can kill. Use the DMVs to find a connection and then kill it
http://dwbi1.wordpress.com/2010/01/01/ssas-dmv-dynamic-management-view/
select * from $system.discover_sessions
select * from $system.discover_commands
<Cancel xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<SPID>12345</SPID>
<CancelAssociated>1</CancelAssociated>
</Cancel>
Mack
January 25, 2013 at 4:46 am
Hi Thanks for the Reply,
We have tried with the given Two Commands but we are not able to find anything related to the Restore but in Job we can see the Step(Restore) is correctly running .
January 25, 2013 at 5:01 am
Use the DMVs to check if there are any large queries running or any long running connections and kill them. SSAS will wait for large queries to finish before fully restoring
Mack
January 25, 2013 at 5:41 am
Mackers (1/25/2013)
Use the DMVs to check if there are any large queries running or any long running connections and kill them. SSAS will wait for large queries to finish before fully restoringMack
Hi,
Executed the DMVs that you provided above, but there are no queries that is taking more time, it just shows 2 records one for the DMV that is executing and the other shows 'MDSCHEMA_FUNCTIONS'.
I searched in other forums , others are suggesting to restart the SSAS service, without restarting the service could you please suggest me if there are any other options available?
January 25, 2013 at 6:18 am
hmmmmmm sounds like restarting the service is your best option at this point
Looks like no-one else is using it tho judging from the DSVs
Mack
January 25, 2013 at 7:51 am
Mackers (1/25/2013)
hmmmmmm sounds like restarting the service is your best option at this pointLooks like no-one else is using it tho judging from the DSVs
Mack
hhmmm....think so done with restarting the Service again... 🙁
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply