BL680G7 MS SQL Server 2008 R2 performance issues

[IS.Danil]

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?

[S_Logan]

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