server - How to check if SSAS service is responding -

-

is there way check if analysis service installed on server not responding , requires restart ? been looking @ ssas dmvs :

  • select * $system.discover_connectionsgo
  • select * $system.discover_object_memory_usage
  • select * $system.discover_locks

but dont feel answer question.

thanks in advance.

try this: here mssqlserverolapservice name of sql analysis service , can found here

exec xp_servicecontrol n'querystate',n'mssqlserverolapservice'

you can check status of service , take decision accordingly.


Comments

Post a Comment

Popular posts from this blog

database - How many Observations in SAS Sample Data Output -

-
i have sample sas output , need find out how many observations , compute t-statistic beta1. can me started on how go doing this? sample sas output to number of obs in dataset can run code. data _null_; put nobs=; stop; set sashelp.class nobs=nobs; run; a proc reg give summary statistics need, namely, t-value, beta1 , beta null, intercepts of regression equation. here simple easy follow example http://support.sas.com/documentation/cdl/en/statug/63962/html/default/viewer.htm#statug_reg_sect003.htm
Read more

emulation - Android map show my location didn't work -

-
i have been struggle current location in google map, tried official map demo, not working also. shows getmylocation button on upper right, didn't show blue dot on map current location. here code , i'm using emulator target api 23, guess may emulator's problem since code download directly github. advice appreciated. [screenshot][1] package com.example.mapdemo; import com.google.android.gms.maps.googlemap; import com.google.android.gms.maps.googlemap.onmylocationbuttonclicklistener; import com.google.android.gms.maps.onmapreadycallback; import com.google.android.gms.maps.supportmapfragment; import android.manifest; import android.content.pm.packagemanager; import android.os.bundle; import android.support.annotation.nonnull; import android.support.v4.app.activitycompat; import android.support.v4.content.contextcompat; import android.support.v7.app.appcompatactivity; import android.widget.toast; /** * demo ...
Read more

ios - how to query based on pfobject/pfuser associated with another pfobject in parse.com? -

-
i have parse class called friendrelation. class has 2 users, 1 friend other user. i want of messages posted of friends of user. attempting following query: pfquery *innerquery = [pfquery querywithclassname:@"friendrelation"]; [innerquery wherekey:@"user" equalto:currentuser]; pfquery *query = [pfquery querywithclassname:@"message"]; [query wherekey:@"usermessage" matchesquery:innerquery]; [query findobjectsinbackgroundwithblock:^(nsarray *comments, nserror *error) { }]; this query comes no results. i believe occurring because of line: [query wherekey:@"usermessage" matchesquery:innerquery]; the key needs friendrelation match. correct? how can make results of inner query user intern match matching query? thanks! you can try using - (void)wherekey:(nsstring *)key matcheskey:(nsstring *)otherkey inquery:(pfquery *)query something like: pfqu...
Read more