Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
BladeSystem Server Blades
cancel
Showing results for 
Search instead for 
Did you mean: 

Performance Improvement Best Practices

chuckk281
Trusted Contributor

Performance Improvement Best Practices

Ankur was looking for some performance advice:

 

**********************

 

Hi Team,

 

We recently came across an interesting situation.We moved the MS-SQL databases from windows server 2003 32 bit (BL685c G1) to windows server 2008 r2 (BL685c G1)64 bit.Instead of gaining performance ,the performance of the sql queries degraded considerably  .We disabled power management at the BIOS level and  changed the power plan on windows 2008 R2 server from balanced to high performance and the sql queries started performing a lot  better than the old environment. Has anybody else come accross a situation like this?Any shared experience or knowledge in regards to this is highly appreciated.

 

 

*******************************

 

Mark and Lee suggested looking at an HP whitepaper on the subject:

 

*********************

 

We saw this in TPCC for the Proliant DL980 G7, and have a whitepaper which recommends going to High Performance Power Plan, and OS Control Mode.

 

Of course, for normal workloads, it may be more suitable to be default, but high performance workloads need to squeeze every transaction out.

 

  Configuring the HP ProLiant Server BIOS for Low-Latency Applications White Paper (151.9KB, PDF)

 

***********************

 

Hope this helps. Any other experiences you may have in this area please let us know.