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.