Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2007
    Posts
    197

    Smile Unanswered: performance tuning

    how to increase performance through management studio
    except making indexes

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by ankur02018
    how to increase performance through management studio
    except making indexes
    Wow. Good luck with that. Let us know how it goes.

    hmscott
    Have you hugged your backup today?

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Hows about writing more efficient SQL - that's always a good way...

    ankur: a vague question will only ever get a vague answer.
    George
    Home | Blog

  4. #4
    Join Date
    Aug 2007
    Posts
    5
    Good database design. Well written queries. Well thought out indexes. A decent layout of data and log files on disk. Just a few of the things you want to consider, there's no single magic pill answer. Tuning a database server is like tuning a car - make the engine more powerful and you need a better exhaust, and a bigger gas tank as it's less fuel efficient, which add weight.
    More power means better brakes and better cooling, which means more weight. Which in turn means more power and better brakes. Change one thing and it affects others, you can't alter anything in isolation in a database server without knowing the knock on effect. Point I'm making is you need to learn about the whole thing, not just one in isolation. There is no magic, single answer - unless you just turn it over to a decent DBA who's skilled in knowing what he's doing. This is where Management Studio stops poviding the answers and your brain has to start working hard, it's an aid to your mind, not a replacement ! Dig into SQL Server Books Online and start learning is my best advice
    Last edited by Indexer; 08-23-07 at 05:05.

  5. #5
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    I just have to say: what a fantastic answer!
    George
    Home | Blog

Posting Permissions

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