Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
HPE BladeSystem Server Blades
Showing results for 
Search instead for 
Did you mean: 

BL680G7 MS SQL Server 2008 R2 performance issues


BL680G7 MS SQL Server 2008 R2 performance issues

Hi all,


I have HP BL680G7 server and windows server 2008 R2, SQL Server 2008 R2 installed on it.

We migrated our DB from bl460G1( with  windows server 2003 and sql server 2005 on it ) to BL680G7 with windows server 2008 R2 and SQL Server 2008 R2 and we have not seen peformance growth also  a little decrease.


I think that performance issues related to SQL Server  numa settings.


SELECT DISTINCT memory_node_id

FROM sys.dm_os_memory_clerks


1        0
2        3
3        64
4        1
5        2


Does server has correct settings for numa hardware support?


Re: BL680G7 MS SQL Server 2008 R2 performance issues

Hi Danil,


Please check this link:




How to assign KUDOS! Click the STAR!

HP Guided Troubleshooting -


I work for HPE

If you feel this solution was helpful please click the KUDOS! thumb below!