Post reply

Data and Log files Placed on same drive, by any chance it may hit the performance on server?

  • April 16, 2009 at 9:28 am

    #199467

    Hi everyone,

    There is one server having configuration such that data , log and backups are kept on same drive?

    We are facing many performance issues on server my doubt is that whether this may be one of the reason for poor performance,If so then how?

    Awaiting for reply.

    Any help is much appreciated.

    Rol

  • April 16, 2009 at 10:07 am

    #978996

    It's possible, but not necessarily. You'd have to check on what the load is on the server and if there are enough writes to cause a problem.

    It's also a poor idea for disaster recovery. If that drive fails, you lose your backups and data. Backups should be moved.

    As far as performance, you have to determine what your bottleneck is. Is the CPU pegged? Do you have memory pressure? Disk throughput maxed? Indexes not set properly on tables?

    It's too much to list here to check. What you would want to do is start searching for those issues, determine if any of them apply and work on mitigating them.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply