BladeSystem - General
1828402 Members
3992 Online
109977 Solutions
New Discussion

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 1
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

Accept or Kudo


[Any personal opinions expressed are mine, and not official statements on behalf of Hewlett Packard Enterprise]