Tune Database Settings- chef

Question

I am trying to install SQL Server 2012 using chef. Below is my chef recipe. But my task is to - Increase the buffer size(as results of common queries are returned slowly) and to - Decrease the transaction retry interval value (When transactions are failing frequently). Could any one insight on this and tell me how to do this

include_recipe 'chocolatey::default'
chocolatey 'mssqlserver2012expressadv --allow-empty-checksums' do
    action :install
    end

score 0 · Answer 1 · edited May 23 '17 at 12:19

You can use a Chef template to generate a Configuration_File.ini that fits your needs and later you can use it for your installation. So assuming you have a valid configuration template under templates directory:

template '/foo/bar/zaz/config_file.ini' do
  source 'your.template.ini.erb'
  variables(
    variable1:node['attribute1']
    ...
    variableN:node['attributeN']
  )
  action :create
end

However I am afraid that the second request you have (To dynamically set parameters depending on SQL server load) is not what Chef is intended for, since it is against chef's idempotent design. You can read more about it here.

If you are going to manage several SQL servers for different purposes, try looking at Chef Roles and Chef Environments, so you can override the configuration template to match the needs of each solution you deploy.

Tune Database Settings- chef

1 Answers1