- Community Home
- >
- Servers and Operating Systems
- >
- HPE ProLiant
- >
- ProLiant Servers (ML,DL,SL)
- >
- Smart Array Expansion - Can I run SQL Server while...
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
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
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
11-27-2014 09:48 AM
11-27-2014 09:48 AM
Smart Array Expansion - Can I run SQL Server while Expanding
I have a ProLiant DL385 SmartArray 6i expanding now (adding 2 SCSI drives). Calculations show the expansion will take about 70 hours to finish.
Can I start the services for SQL Server while this is running - users will want to use it at about the 50 hour mark on Saturday when they come in to work.
Will this affect or hurt the Expansion?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-27-2014 10:56 AM
11-27-2014 10:56 AM
Re: Smart Array Expansion - Can I run SQL Server while Expanding
NOTE: The server is online, I am running ACU in Browser Mode as I do the expansion. Right now I have stopped all the SQL Server services, but want to know if I can start them without disrupting the expansion.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-27-2014 01:31 PM - edited 11-28-2014 03:59 PM
11-27-2014 01:31 PM - edited 11-28-2014 03:59 PM
Re: Smart Array Expansion - Can I run SQL Server while Expanding
>Will this affect or hurt the Expansion?
It will slow it down of course. There are only so many IOPS that you can do.
Since you aren't replacing a failed drive, perhaps it won't matter if it slows the expansion.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-28-2014 05:53 AM
11-28-2014 05:53 AM
Re: Smart Array Expansion - Can I run SQL Server while Expanding
Thanks, Dennis,
I will give it a try - it will not be a full crew working Saturday, so it should be light usage, other than SQL Server's own activities. But I will also turn off the Full Backup and Indexing of SQL Server for the day to help minimize that.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-01-2014 03:27 AM
12-01-2014 03:27 AM
Re: Smart Array Expansion - Can I run SQL Server while Expanding
Completed:
In ACU:
1. After inserting drives: Select High Priority for both options in Controller Settings
2. Choose Expand Array and select both drives (goal is one volume from 6 - 146.8 GB SCSI drives) and click Save
3. After 50 % trasfroming, start SQL Server services to make ready for production use after holidays (about 45 hours into Expansion
4. Transformning reached 100% at about 85 hours
5. In ACU select Extend Volume and set size to max of 683.6 GB
6. it showed volume now at 683.6 GB, but windows still at 410 GB
7. Reboot after about an hour of nothing happening - still no added space in Windows Explorer
8. Went into Computer Managements / Storage Management - there the unused space showed in the graphic view.
9. Right click graphic view of volume and choose Expand and select full amount of unused space.
10. Immediately the unused space was part of drive and available for use.
11. Total time about 86 hours - the ACU documentation was correct for Expanding, but not for Extending (yet the documentation was for some ACU version different than mine because of differences in the interface)
12. Running Windows Server 2008 which had capability to Extend drive in Computer Storage Management interface.
Thanks for help.