SQL server datbase parameter change

[former_member747244]

Hi ,

I have SQL server 2005 as database server.

I have to change the the parameter max worker threads from 572 to 255 .

Please explain the complete step wise procedure for doing this.

Thanks and regards

Tushar

[Former Member · Accepted solution]

Hai,

Try this,

1) In Object Explorer, right-click a server and select Properties.

2) Click the Processors node.

3) In the Max worker threads box, type or select a value from 32 through 32767.

Use the max worker threads option to configure the number of worker threads available to SQL Server processes. The default setting for max worker threads is best for most systems. However, depending on your system configuration, setting max worker threads to a smaller value sometimes improves performance.

or check the below link...

http://www.helpline4it.com/lab_practices-d582.html

Regards,

Yoganand.V

[former_member747244]

Hi Yoganand

Thanks for this.

I also want to change the datafile growth from 60 mb to 100 mb

Please also let me know how to do this?

Thanks

Best regards

Tushar