HPE BladeSystem Server Blades
cancel
Showing results for 
Search instead for 
Did you mean: 

BL680G7 MS SQL Server 2008 R2 performance issues

IS.Danil
Advisor

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

 

memory_node_id
1        0
2        3
3        64
4        1
5        2

 

Does server has correct settings for numa hardware support?

1 REPLY
S_Logan
HPE Pro

Re: BL680G7 MS SQL Server 2008 R2 performance issues

Hi Danil,

 

Please check this link:

http://books.google.com/books?id=6VcwMpLhjVAC&pg=PT201&lpg=PT201&dq=memory_node_id&source=bl&ots=BZ8OSe0WGl&sig=j2YGoz0LdqVkDb6WX4CT-c57xiQ&hl=en&sa=X&ei=67AnT469BIjg2AXGiKXoAg&ved=0CEMQ6AEwBQ#v=onepage&q=memory_node_id&f=false

 

HTH,

Surendar

How to assign KUDOS! Click the STAR!

HP Guided Troubleshooting - www.hp.com/support/hpgt

 

I work for HPE

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