You can't without destroying and re-creating the partition.
There are much worse things than a non-optimal disk subsystem. So no I would not - in fact the only things i would refuse to admin would be .. well i haven't found something yet but when I do I'll let you know.
Things ran just fine for years without aligned partitions. Are you seen performance issues with the unaligned disks?
the partiton has to be aligned at partition creation. No I wouldn't refuse to admin it I'd simply note the issue and whenever there are disk related performance problems remind the business that I need downtime to resolve the issue.
I wouldn't refuse to admin it. In addition, unless you have a very busy server, I would wonder exactly how much of a performance hit is actually occurring because of it. It's one thing to see that the partition is not alligned, it's quite another to prove that that's the cause of performance issues. Have you run any perfmon or other diagnostics to confirm your suspicions?
I can't imagine telling someone I'd "refuse to admin" a system, unless I was given some kind of bizarre ultimatum along with a bizarre system.
To fix this, just create a new database on a correctly formatted partition, and migrate the data to it. Should be relatively straightforward unless the database is ungodly huge, and if it was ungodly huge, I think this would have been a pretty pressing problem before now.
In the admin world, systems that are working are seldom worthy of emergency responses. Plan it out, do your migration in an orderly manner, and you should be fine.
Things ran just fine for years without aligned partitions. Are you seen performance issues with the unaligned disks?
the partiton has to be aligned at partition creation. No I wouldn't refuse to admin it I'd simply note the issue and whenever there are disk related performance problems remind the business that I need downtime to resolve the issue.
I wouldn't refuse to admin it. In addition, unless you have a very busy server, I would wonder exactly how much of a performance hit is actually occurring because of it. It's one thing to see that the partition is not alligned, it's quite another to prove that that's the cause of performance issues. Have you run any perfmon or other diagnostics to confirm your suspicions?
I can't imagine telling someone I'd "refuse to admin" a system, unless I was given some kind of bizarre ultimatum along with a bizarre system.
To fix this, just create a new database on a correctly formatted partition, and migrate the data to it. Should be relatively straightforward unless the database is ungodly huge, and if it was ungodly huge, I think this would have been a pretty pressing problem before now.
In the admin world, systems that are working are seldom worthy of emergency responses. Plan it out, do your migration in an orderly manner, and you should be fine.