Issue with DB on particular machine

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Paul
    #1

    Issue with DB on particular machine

    Hi,

    I am at a bit of a loss about what to do with a problem I am having. I
    have a 7GB database, loaded on to SQL Server 2000 SP4 on 2 different
    machines.

    Machines have following specs:

    1) Intel Pentium 4 Dual Core 3.40 GHz, 3 GB RAM, 2GBb RAM available to
    SQL Server. Windows 2003 SP1
    2) AMD Athlon 2500 + (1.8GHz), 2GB RAM, , 2GBb RAM available to SQL
    Server. Windows 2003 R2 SP1

    I hope this is enough relevant information.

    The 2nd machine handles the database fine, complex queries are OK etc.
    The 1st machine cannot even handle generating an estimated execution
    plan for a query on a single table. It dies and has to be killed via
    the power button.

    However, I have another 9GB DB on the same machine that I can run
    complex queries against with no problem.

    I thought that there may be a particular issue with that DB so I ran
    DBCC CHECKDB against it but no errors were reported. I have also run
    Check Disk on the machine and again, no problems were found. So I am
    currently at a complete loss about what to do. Both instances of the DB
    have come from the same backup. I do not really know what else to try
    with this.

    If anybody has any ideas at all it would be greatly appreciated.

    Thanks in advance,

    Paul

    Tags: None
    • JoeyD
      #2
      Re: Issue with DB on particular machine

      Hi Paul - what are the disk drives like on both servers? Where are the
      databases' data files located on each server? If you doing a lot of I/O
      (which I suspect your are) then you might want to look at Disk I/O
      and/or disk thru put.

      JD


      Paul wrote:
      Hi,
      >
      I am at a bit of a loss about what to do with a problem I am having. I
      have a 7GB database, loaded on to SQL Server 2000 SP4 on 2 different
      machines.
      >
      Machines have following specs:
      >
      1) Intel Pentium 4 Dual Core 3.40 GHz, 3 GB RAM, 2GBb RAM available to
      SQL Server. Windows 2003 SP1
      2) AMD Athlon 2500 + (1.8GHz), 2GB RAM, , 2GBb RAM available to SQL
      Server. Windows 2003 R2 SP1
      >
      I hope this is enough relevant information.
      >
      The 2nd machine handles the database fine, complex queries are OK etc.
      The 1st machine cannot even handle generating an estimated execution
      plan for a query on a single table. It dies and has to be killed via
      the power button.
      >
      However, I have another 9GB DB on the same machine that I can run
      complex queries against with no problem.
      >
      I thought that there may be a particular issue with that DB so I ran
      DBCC CHECKDB against it but no errors were reported. I have also run
      Check Disk on the machine and again, no problems were found. So I am
      currently at a complete loss about what to do. Both instances of the DB
      have come from the same backup. I do not really know what else to try
      with this.
      >
      If anybody has any ideas at all it would be greatly appreciated.
      >
      Thanks in advance,
      >
      Paul

        Comment

        Previous template Next
        Working...