- Community Home
- >
- Servers and Operating Systems
- >
- HPE ProLiant
- >
- ProLiant Servers (ML,DL,SL)
- >
- Re: Proliant ML380 G5 - P400 controller - 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
тАО01-17-2011 05:18 AM
тАО01-17-2011 05:18 AM
Proliant ML380 G5 - P400 controller - SQL 2008
It's a dedicated sql 2008 server.
We have performance problems and we strongly suspect the Disk I/O of being the main cause.
What/how can i verfy ?
What are the recommended settings for the p400 array controller (acceleraror ratio..)
thx
Xavier
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-17-2011 05:34 AM
тАО01-17-2011 05:34 AM
Re: Proliant ML380 G5 - P400 controller - SQL 2008
You have BatteryBacked Cache on the controller?
And write-back cache is enabled for the array?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-17-2011 05:43 AM
тАО01-17-2011 05:43 AM
Re: Proliant ML380 G5 - P400 controller - SQL 2008
Cache Status Enabled
Accelerator Ratio 25% Read /75% Write
Total Memory on Controller 256 MB
Battery Pack Count 1
Battery Status OK
extra info :
Controller Smart Array P400
Bus Interface PCI Express
Controller Location Slot 1
RAID 6 (ADG) status Enabled
Hardware Revision D
Firmware Version 4.06
Rebuild Priority Medium
Expand Priority Medium
Current Surface Scan Delay 15 sec
Number of Arrays 2
Number of Logical Drives 2
Number of Physical Drives 8
Physical Drives Attached to Port 1I Box 1 : Bay 5, 146 GB (SAS)
Box 1 : Bay 6, 146 GB (SAS)
Box 1 : Bay 7, 146 GB (SAS)
Box 1 : Bay 8, 146 GB (SAS)
Physical Drives Attached to Port 2I Box 1 : Bay 1, 72 GB (SAS)
Box 1 : Bay 2, 72 GB (SAS)
Box 1 : Bay 3, 146 GB (SAS)
Box 1 : Bay 4, 146 GB (SAS)
All Physical Drives Assigned Yes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-17-2011 06:05 AM
тАО01-17-2011 06:05 AM
Re: Proliant ML380 G5 - P400 controller - SQL 2008
(Most DB operations are read, not write)
Is this a new install, or an older install where the problem has shown up after a while?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-17-2011 06:11 AM
тАО01-17-2011 06:11 AM
Re: Proliant ML380 G5 - P400 controller - SQL 2008
thx for the quick replies
yes i was considering change the value to 50/50 or even 75/25 but before doing that i wanted to have some advice from experts
initially we did not have the performance problem but the load wasn't that high either
extra question : can the amount of cache be upgraded on this controller ? and does it make sense to do that ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-17-2011 06:27 AM
тАО01-17-2011 06:27 AM
Re: Proliant ML380 G5 - P400 controller - SQL 2008
I KNOW there's a 512MB module for it, at least.
(We believe in 'overkill' at the office if the part isn't too expensive compared to the 'normal' part... )
How much memory do you have in the server?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-17-2011 06:32 AM
тАО01-17-2011 06:32 AM
Re: Proliant ML380 G5 - P400 controller - SQL 2008
ram in the server : 3GB
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-17-2011 07:20 AM
тАО01-17-2011 07:20 AM
Re: Proliant ML380 G5 - P400 controller - SQL 2008
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-18-2011 12:31 AM
тАО01-18-2011 12:31 AM
Re: Proliant ML380 G5 - P400 controller - SQL 2008
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-01-2011 11:13 PM
тАО03-01-2011 11:13 PM
Re: Proliant ML380 G5 - P400 controller - SQL 2008
should i foresee multiple array controllers (one per set of disks ) and/or what kind of array controllers in a DL386 G6 ?