Post reply

Handling Bulk data in SQL Server

  • September 2, 2010 at 1:23 am

    #237765

    i have a distubed environment where in multiple users comes into play. And my data are in one centeralised loaction. Handle of datas become a problem.

    Statices of database are given in detials:

    1. In my project we are using more then hundred tables for one database

    2. Two hundred users conncurrentley used my projects

    3. Most of the tables increased a 50000 records daily basis.

    Prblems

    i am facing following problems

    1. Timeout Expired problems comes in frequently

    2. select query takes long time

    my question is

    How to design the tables?

    How to split the tables?

  • September 2, 2010 at 6:47 am

    #1215556

    I don't think that's a question for a forum.

    You might want to call a local consultant to help you improving performance.

    Other than that: use SQL Profiler to identify long running queries (and tune those) and check for appropriate indexes.

    There is simply not enough information to be more specific.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • September 2, 2010 at 7:15 am

    #1215577

    Check your dmv's for missing indexes.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

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

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