- Community Home
- >
- Servers and Operating Systems
- >
- HPE BladeSystem
- >
- BladeSystem - General
- >
- BL680G7 MS SQL Server 2008 R2 performance issues
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Forums
Discussions
Discussions
Discussions
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-16-2012 12:08 AM
01-16-2012 12:08 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-31-2012 01:17 AM
01-31-2012 01:17 AM
Re: BL680G7 MS SQL Server 2008 R2 performance issues
Hi Danil,
Please check this link:
HTH,
Surendar
HP Guided Troubleshooting - www.hp.com/support/hpgt
[Any personal opinions expressed are mine, and not official statements on behalf of Hewlett Packard Enterprise]