Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002

    Unanswered: Slow performance after restore (7.0)

    I have restored my CRM database to a lab environment that runs on a Dual P4 1.4 w/ 768 mb ram. Same hardware as the original box, including RAID 5 w/ 4 SCSI drives. Performance is not up to par on this system. I have rebuilt all of the indexes, I have ran perfmon and nothing jumps out at me as being a problem. The database is close to 4gb, but we haven't experienced performance problems like this in the live db. We are seeing queries take up to 500% longer on this lab machine. Has anybody else experienced this? I am relitively new to SQL, so I am sure I am just missing something simple. Thanks,


  2. #2
    Join Date
    Feb 2002
    Houston, TX
    you might want to update statistics, then rebuild indexes and stored procedures.
    Paul Young
    (Knowledge is power! Get some!)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts