topic Re: Dynamically increase disk size of SQL server on EVA4400 in MSA Storage

Dynamically increase disk size of SQL server on EVA4400

John821 — Mon, 17 May 2010 07:51:33 GMT

Hi,
We have an EVA4400. We have SQL server connected to a LUN on the EVA4400. Is it possible to increase the size of the LUN without brining SQL server down?
Thanks

Re: Dynamically increase disk size of SQL server on EVA4400

Uwe Zessin — Mon, 17 May 2010 08:28:12 GMT

Well, as long as it is not some strange partition setup, it should work fine.

- Increase the size of the virtual disk.
- Rescan in Disk Administration.
- Use DISKPART to extend the partition table and the filesystem:
http://support.microsoft.com/kb/325590/EN-US/

Re: Dynamically increase disk size of SQL server on EVA4400

Ace Calderon — Tue, 18 May 2010 01:23:06 GMT

this should work, you can search thru windows re the diskpart steps,but as best practice,please do back the DB before doing the capacity expansion

Re: Dynamically increase disk size of SQL server on EVA4400

Jan Soska — Tue, 18 May 2010 05:25:26 GMT

Hello,
did the seme many times with Eva6000 and SQL 2000-2008 under win2003/2008.
Do the steps described above with one more advice - IF your system is under heavy I/O load, STOP temporary SQL before disk extend under windows. It will be really fast then (1-5 seconds). If you do not stop SQL, it could take much more time and nerves... :)

Jan