Re: SQL Database files on a SAN

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

You can move the files by detaching the db, moving some of the files and reattaching it specifying the new physical locations of the files. It is hard to say if there will be performance improvements or not. But if you had I/O bottlenecks with the current configuration this should help.You didn't mention where the log files are located. If they are on the same raid 10 as the data you might consider using some new capacity for a Raid 10 dedicated to the log files.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Mike" <Mike@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:A13A332F-C069-4794-9B06-989E5695B04C@xxxxxxxxxxxxxxxx
We run our SAP SQL database on a SAN and we recently expanded our SAN
capacity for SAP. My question is, we have 7 database files for SAP running
on a RAID 10 on 2 cabinets of 15 discs each.

Can we move part of the SQL database files onto the new discs we just
implemented in the SAN and still have SAP find the data on those files?

Also, will performance increase/decrease within SAP have the files split up
like that?

Thanks for your help!

Mike

.

Relevant Pages

  • Re: SQL Database files on a SAN
    ... "Andrew J. Kelly" wrote: ... If they are on the same raid 10 as ... we have 7 database files for SAP ... Can we move part of the SQL database files onto the new discs we just ...
    (microsoft.public.sqlserver.setup)
  • SQL Database files on a SAN
    ... We run our SAP SQL database on a SAN and we recently expanded our SAN ... Can we move part of the SQL database files onto the new discs we just ...
    (microsoft.public.sqlserver.setup)