- Community Home
- >
- Storage
- >
- Midrange and Enterprise Storage
- >
- StoreVirtual Storage
- >
- Re: P4500 Multi-site and SQL 2008
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
Discussions
Discussions
Forums
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
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
тАО02-11-2011 07:41 PM
тАО02-11-2011 07:41 PM
P4500 Multi-site and SQL 2008
Thanks in advance.
Tim Foster
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-11-2011 08:19 PM
тАО02-11-2011 08:19 PM
Re: P4500 Multi-site and SQL 2008
What type of switches are the P4500's connected to?
how are the blades connecting to the storage?
what about to the user network?
Steven
HP Master ASE, Storage, Servers, and Clustering
MCSE (NT 4.0, W2K, W2K3)
VCP (ESX2, Vi3, vSphere4, vSphere5, vSphere 6.x)
RHCE
NPP3 (Nutanix Platform Professional)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-13-2011 06:42 AM
тАО02-13-2011 06:42 AM
Re: P4500 Multi-site and SQL 2008
On the iSCSI switching side you should be using flow control over jumbo frames. If your switches support it then flow control and jumbo frames.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-13-2011 07:03 PM
тАО02-13-2011 07:03 PM
Re: P4500 Multi-site and SQL 2008
Site A
2x2910al SAN dedicated switches - VLAN for SAN traffic
2x 2x1Gb trunked Switch to Switch
Nodes 1 & 2 - 2x1Gb to each switch
Jumbo and Flow enabled
SQL Server (Blade) to SAN - 6Gb Fibre
Site A to B - 2x1Gb Fibre
Site B
1x2910al
Nodes 1 and 2 - 2x1Gb to switch
This has been escalated up through HP and VAR, checked by Lefthand people, etc. On Friday we tried 3500yl switches to no avail.
We (not the VAR or HP) have isolated the problem to sequential write performance for the LOG volume. It's just not there. If we move the logs to a DAS disk (C:), we get good performance in SQL.
That's why I asked for an example of a successful configuration for SQL - I know this one is not working for us.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-14-2011 05:18 AM
тАО02-14-2011 05:18 AM
Re: P4500 Multi-site and SQL 2008
Open up the CMC go to the Performance monitor. Add statistics for IOPS total for all your nodes in the cluster. Watch the value, you want to make sure it is not exceeding 1700 IOPS per node for long periods of time. If the IOPS look good then as you are writing data to the log watch the network utilization at the switch level.