Post reply

Increase sqlserver performance

  • May 11, 2008 at 7:45 am

    #121419

    Hi,

    i'm quite new to SQL-Server 2006 DBA. My company asked me to make analysis on how to improve performance.

    We have a situation in which we produce around 15millions of rows per month in single table and data are updated every milliseconds without pause (even in the night).

    It is possible to use a kind of parallel computing i which more than one server blend its processing power??

    i investigated on replication technology but the problem is the network overhead.

    Any suggestions?

    Thanks

  • May 11, 2008 at 11:27 am

    #813561

    If you are in SQL 2005, You can take advantage of table partitioning but only in Enterprise edition.

  • May 11, 2008 at 11:54 am

    #813564

    15 million rows per month isn't much. Instead of looking for a hardware solution to a software problem, the best thing to do would be to follow the suggestions in the URL found in my signature and describe the real problem... the answer will be in the code you write against the table, not in the hardware you throw at it.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • May 11, 2008 at 12:57 pm

    #813568

    - 15 million rows per month = +/- 350 rows a minute. Should not be a problem.

    Try to implement as many best practises a you can, because it can go wrong if you don't.

    - In many cases managers think they can make up development mistakes by getting state of the art hardware solutions, in stead of investing in state of the art development according to general guidelines.

    Indeed, adaptability, ease of maintenance, ease of scalability, are things they may only appreciate a year or so after the project has been delivered, but then the cost savings really start.

    - project definition and scope ?

    - how much do you know about the data requirements ?

    - Codds rules are still your friend and prevents the most common pitfalls.

    - Only when you have a validated data model, you can start with implementing to a rdbms engine if you want a state of the art system.

    - You can find many beste practises for sqlserver at SSC, and even at Microsoft they have a best practise section nowadays.

    - If you have a more concrete case, we'll be happy to help out 😎

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

Viewing 4 posts - 1 through 3 (of 3 total)

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