Power settings in OS and IOS
- Max performance and BIOS is also updated (because power saving cycles down the CPU and the performance may be reduced by as much as 20%)
SQL MaX Memory settings
- set it to 90% of OS memory for upto 16GB; and then 1GB for every 4GB increase on RAM
- if other MSBI suite of products are installed, appropriately assign more memory for OS
if the OS doesnt have enough memory and SQL takes up all then OS starts eating up the memory allocated to active processes and slows down entire system
Disk Cluster size
- set it to be in the chunks of 64Kb
Auto-shrink/Auto-close
- disable on all Dbs
0 Comments.