DB structure

Question

DB structure

varunfilim

Mr or Mrs. 500

Points: 594
More actions
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

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

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

WayneS SSC Guru Points: 95460 More actions · Answer 1

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

ps. One Orange Chip Points: 29422 More actions · Answer 2

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

:doze:

Pradeep Singh

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

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

http://www.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

varunfilim Mr or Mrs. 500 Points: 594 More actions · Answer 4

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