Re: SQL Database files on a SAN

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

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 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
    ... 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. ... we have 7 database files for SAP running ... Can we move part of the SQL database files onto the new discs we just ...
    (microsoft.public.sqlserver.setup)
  • Re: Missing modules/*.DLLs
    ... thanks for the reply Andrew. ... >> 10 disc recovery discs I received after a total trojan-caused crash ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Missing modules/*.DLLs
    ... siguytwo wrote: ... > thanks for the reply Andrew. ... >>> in the 10 disc recovery discs I received after a total ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: SQL Database files on a SAN
    ... Andrew J. Kelly SQL MVP ... Solid Quality Mentors ... > We run our SAP SQL database on a SAN and we recently expanded our SAN ...
    (microsoft.public.sqlserver.setup)
  • Re: SAP Integration?
    ... I am not a SAP programmer, and only have a basic knowledge of the SAP ... I would expect there to be some IDOC that is generated ... "Andrew" wrote in message ... >> I have worked with the MS SAP Adapter, and have had a few specific issues ...
    (microsoft.public.biztalk.general)