• No, both options are not enabled. just now i checked in server setting in advanced options both values is set mention below's.

    1) Locks value is 0.

    2) Optimize for Ad hoc work load is False.

    I have one quick question on this.

    If i suppose to do enable these options, what outputs will come.

    is it caused to any server performance, if i enabled those options?

    Thanks.