Post reply

Slow database performance on a higher spec server

  • April 10, 2006 at 9:28 am

    #631766

    A fundamental part of fault finding and performance tuning is to ensure you test on like for like systems. Might I suggest an investment in a tool such as Redgate's SQL Compare, this might have saved you two months postings!! < grin >

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • April 10, 2006 at 5:39 pm

    #631843

    How would SQL Compare help in this instance, when the database was identical on both servers?   (The same database with the same missing index ran fine on one server and really poorly on another.)

    Or is there functionality in Red Gate SQL Compare that I'm not aware of, that will tell me what execution plan each server will use and why?

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

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