Showing posts with label resource. Show all posts
Showing posts with label resource. Show all posts

Thursday, March 22, 2012

Create a hidden resource

Good day
I am using the CreateResource method (C#) to upload a jpg file to a report
server. I have completed this task, however I am manually navigating to the
Report Manager, going to the Properties section of the jpg file and checking
the "Hide in list view" checkbox.
I am sure this can be done programmatically, and I suspect it has to do with
this last parameter of the CreateResource method? Please could someone help
me.
ThanksI have managed to complete this, using the SetProperties method. The actual
property name I was looking for was "Hidden" - how simple :) I just set this
to "True"
"Imrahn" wrote:
> Good day
> I am using the CreateResource method (C#) to upload a jpg file to a report
> server. I have completed this task, however I am manually navigating to the
> Report Manager, going to the Properties section of the jpg file and checking
> the "Hide in list view" checkbox.
> I am sure this can be done programmatically, and I suspect it has to do with
> this last parameter of the CreateResource method? Please could someone help
> me.
> Thanks

Wednesday, March 7, 2012

cpu quota / resource management

Hello *,

Is there a way to restrict resource consumption by user or connection?

If I execute some long running reports my complete server slowes down. I'd like to assign this reports only limited resources.

Thanks,

Michael

You can configure database mirroring for the target database in your production SQL instance and create snapshot on the mirror server (your backup SQL instnace) on different machine. The principle system can be considered as your normal OLTP business system and the mirror server can be used to support your reporting system. Since the reporting system will be run on differet SQL Server instance on different machine, it will not hurt your normal business onthe principle server. HTH|||Really your easy options are limited to setting query govenor which is time based not resource based.|||Thanks for the hint, "SET QUERY_GOVERNOR_COST_LIMIT" is useful in this context. Additional question:-
Is there a way to cancel running querries? For instance by issuing a "cancel" call from a seperate thread?

Thanks,
Michael