controller

Can any one let me know about the controller like in the optimization
concern, we need to spearate our log file and data file into different
controller, means sepearate physical hard disk
What the controller is ?
Hi
Controller = Disk Driver Controller or RAID Controller.
It is the device that talk to the hard drives.
One controller can talk to lofg and data drive, but for performance, it is
better to go each drive set it's own controller.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rogers" <Rogers@.discussions.microsoft.com> wrote in message
news:D92BF589-8725-4BCB-9490-8E8D0AD810CA@.microsoft.com...
> Can any one let me know about the controller like in the optimization
> concern, we need to spearate our log file and data file into different
> controller, means sepearate physical hard disk
> What the controller is ?
|||We have implemented RAID 5 but the thing is that can any one guide me like
how can i check my RAID help my set my log and data file into different
controller.
Thanks
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> Controller = Disk Driver Controller or RAID Controller.
> It is the device that talk to the hard drives.
> One controller can talk to lofg and data drive, but for performance, it is
> better to go each drive set it's own controller.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Rogers" <Rogers@.discussions.microsoft.com> wrote in message
> news:D92BF589-8725-4BCB-9490-8E8D0AD810CA@.microsoft.com...
>
>
|||Hi
Once you have implemented a RAID level, you can not change the controller
without destroying the RAID volume.
If you want to move your databases from one drive to another, look at
sp_attachdb and sp_detachdb in Books Online.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rogers" <Rogers@.discussions.microsoft.com> wrote in message
news:61E7C4CB-B4C4-494E-9CD4-60F94F3C3126@.microsoft.com...[vbcol=seagreen]
> We have implemented RAID 5 but the thing is that can any one guide me like
> how can i check my RAID help my set my log and data file into different
> controller.
> Thanks
> "Mike Epprecht (SQL MVP)" wrote: