SQL Server Fill Factor – Restart Services

fill-factorsql server

I changed the Fill Factor option from 1 to 75.

When I run a query that displays the fill Factor I am seeing 75

But I read online that I have to stop and start the sql Server services inorder for this change to be effective. Is that True?

http://sqlmag.com/database-administration/fill-factor-truth

You must stop and restart the SQL Server service for the change to take effect. The new fill factor will be in effect when you see it in the run-value column

Best Answer

But I read online that I have to stop and start the sql Server services inorder for this change to be effective. Is that True?

Yes, you have to stop and restart sql server services.

fill factor (%)

This has is_dynamic = 0 in the master.sys.configurations. This means that when you run sp_configure 'fill factor (%)', 75, the VALUE will be set to 75, but it wont take affect until you restart sql server.

You should check value in use for master.sys.configurations or run_value of the sp_configure output.

enter image description here

Related Question