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 !

Mike

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 .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@discussions.microsoft.com> wrote in message
news:A13A332F-C069-4794-9B06-989E5695B04C@microsoft.com...
> 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 !
>
> Mike

Andrew,

Thank you for the information. Our logfiles are located else where - not in
the same disc array.

Are there any MS KB articles or documentation that I could get my hands on?

Mike

"Andrew J. Kelly" wrote:

> 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 .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@discussions.microsoft.com> wrote in message
> news:A13A332F-C069-4794-9B06-989E5695B04C@microsoft.com...
> > 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 !
> >
> > Mike
>
>

Documentation on what exactly?

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Mike" <Mike@discussions.microsoft.com> wrote in message
news:900631C5-A808-4437-ABE8-E4C8DF8B8FB3@microsoft.com...
> Andrew,
>
> Thank you for the information. Our logfiles are located else where - not
> in
> the same disc array.
>
> Are there any MS KB articles or documentation that I could get my hands
> on?
>
> Mike
>
> "Andrew J. Kelly" wrote:
>
>> 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 .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@discussions.microsoft.com> wrote in message
>> news:A13A332F-C069-4794-9B06-989E5695B04C@microsoft.com...
>> > 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 !
>> >
>> > Mike
>>
>>