Changing sys.configurations for SQL Azure instance? Is that possible?

• vsamantha35

  SSChampion

  Points: 11529

  More actions

  December 9, 2017 at 9:45 pm

  #409843

  Hi All,

  If I would like to change the sp_configure settings on a SQL Azure instance, how can I do that? Can we do that using tsql statement or something which has to done in azure portal? This is a testing server. I want to propose changing "cost threshold for parallelism" from 5 to 25/50 as we are seeing high cpu.
  and want to turn on "optimize for adhoc workload" to 1.

  Other thing is that I want to turn on auto_create stats = ON, auto_close = OFF at database. Can I do that using tsql Alter statement just as we do it for OnPrem database?

  Thanks,

  Sam