Limiting Resources During Statistics Update

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

HowardW One Orange Chip Points: 29109 More actions · Answer 1

If you have Enterprise Edition, Resource Governor can do this.

Syed Jahanzaib Bin hassan SSChampion Points: 11410 More actions · Answer 2

Make a resource pool with the help of Resource Governor for the specific user and then login with it and then update the statistics

My Blog
www.aureus-salah.com

dajonx SSCertifiable Points: 6950 More actions · Answer 3

How do I associate a resource pool to a specific user?

Syed Jahanzaib Bin hassan SSChampion Points: 11410 More actions · Answer 4

For Resource Governor information

Example

CREATE FUNCTION My_Classifer_func()

RETURNS SYSNAME WITH SCHEMABINDING

BEGIN

--workload definition based on login names

DECLARE @WorkLoadName sysname

IF SUSER_SNAME()= 'admin'

BEGIN

SET @WorkLoadName='AdminUsers';

END

--workload definition based on application

IF APP_NAME() = 'My Application'

BEGIN

SET @WorkLoadName='MyApp';

END

RETURN @WorkLoadName;

END

A very good Article by Muhammad Shujaat

My Blog
www.aureus-salah.com