Post reply

DB structure

  • June 12, 2009 at 11:07 pm

    #131902

    Hi,

    I have a table which contain3 updates,bulk insert,selection of 100 records were running at the same time(concurrently).So many users are updating the table.i hav 47 lakhs of data in the table.My cpu utilization is growing too high,due to unproper mangement of the deadlocks.The java team s saying that better way is to move to mysql which will reduce the cpu utilization.As my point of view it is a foolish decision.

    the operation on the table a follows,

    1.insert

    2.update to status to 1

    3.update to status to 2

    2 and 3 r running on same records.

    4 .during the above process selection is occuring...

    for all the statements indexing is done...

    i want an urgent help.hope u hav the answer

    regards

    varun

  • June 12, 2009 at 11:47 pm

    #1009013

    You know, the people that help out here are all un-paid volunteers. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables affected, and INSERT statements to put some test data into those tables that shows your problem will go a long way in getting people to look at your issue and help you out. Please include code for what you have already tried. Don't forget to include what your expected results should be. As a bonus to you, you will get tested code back. For more details on how to get all of this into your post, please look at the link in my signature.

    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

  • June 13, 2009 at 4:12 am

    #1009038

    developer team will never accept that major cause of poor performance is 'bad design'.

    :doze:


    Pradeep Singh

  • June 13, 2009 at 4:40 am

    #1009042

    See yesterday's headline article for info on posting performance problems

    http://qa.sqlservercentral.com/articles/SQLServerCentral/66909/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 13, 2009 at 5:29 am

    #1009052

    Thanks my dear friends for helping this,

    i solved out this problem of high cpu uilization.The reason is one select query with inner join is causng the

    problem.so i maked it as a view and it solved my problem.thanks my dear friends for helping me...

    2morrow i will come with new scenario and i need all ur help,so keep in touch

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

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