multithreading - Can mutli-threading java client cause high CPU utilization of SQL Server 2008? -

-

i java developer, not dba, , consult issue encountered in high cpu utilization in sql server 2008 (not in java app server).

the java client uses multi-threading, simplify:

  1. 40 threads each select / insert / update (simple sql statements) table x - autocommit on
  2. 10 threads each select / insert / update (simple sql statements) table y , selects (again simple) table x (to check existence) - autocommit on

both set of threadpools run simultaneously. each thread assigned "message queue" (a file), loads / reads assigned "message", , inserts / updates corresponding table. these 2 thread pools connections single connection pool via datasouce, example:

    <resource auth="container" driverclassname="com.microsoft.sqlserver.jdbc.sqlserverdriver" maxactive="100" maxidle="10" maxwait="10000" name="jdbc/abc_datasource" password="p" type="javax.sql.datasource" url="jdbc:sqlserver://ntxxx\\instyyy:12345;databasename=dbzzz" username="u"/>

the db environment sql server 2008 r2 , shared other apps, java client above flagged causing cpu utilization. when java client shutdown, utilization stabilized. java client's application server jboss, statistics java running not have performance issues, cpu , memory fine; db server got cpu spiked.

my question is, high amount of threads, consume datasource's pool of maxactive 100, potentially cause? if so, how can prove this db perspective, ie. sql server statistics pointing high volumne threads java client?

posted in dba stack, not getting views...: https://dba.stackexchange.com/questions/96502

your description generic give detailed answer. nevertheless, simple statements can cause substantial database activity, if database has either plenty of values or no matching indexes , needs fall full table scans each select.

so, first suggestion is, use sql studio application activity analyzer. there find current load on machine and, more important, list of "currently valuable queries". list queries, responsible current cpu load. see queries executed often, take little time per execution , see queries executed few times, extremely expensive execute.

you can evaluate queries java application , optimization hints. helpful.

the other point is, if queries cannot optimized, maybe data inserted expensive handle (for example blob objects) or sql server not powerful enough handle amount of rows amount of memory , other applications running @ same time.

if cannot solve issue on query side, may need inspect code, if can throttle db load implementing queueing mechanism in between or if need implement caching layer.


Comments

Post a Comment

Popular posts from this blog

google chrome - Developer tools - How to inspect the elements which are added momentarily (by JQuery)? -

-
i looking @ how website designed using inspector in chrome. can use firefox developer tools or firefox web developer add-on or chrome web developer extension. so website has slide-show , using jquery it. looking @ markup , css in inspector, i see 2 things constantly changing slides change: one opacity css property understandable, i'd see changing values, changes fast see read anything. second- a div added in div slides change momentarily , moment when appears short notice except div . so question is there way stop slideshow can temporarily rid of blinking sort of effect (by speedy adding , removal , changing of elements , values)? where can inspect div element gets added such short moment , , gets removed? , can see changes in value of opacity takes place? is there way stop slideshow can temporarily rid of blinking sort of effect (by speedy adding , removal , changing of elements , values)? if opacity animated css transition or animation,
Read more

angularjs - Showing an empty as first option in select tag -

-
my app showing empty select field first entry. have read other solution given , tried still not working. my controller code is: .controller('usercreatecontroller', function(user,profile,auth) { alert("hello"); var vm = this; vm.type = 'create'; profile.all() //this service fetch profiles shown in select field .success(function(data){ vm.profile = data; }); vm.userdata.profile = vm.profile[0]; //here have set default value select field and html page is: <label class="col-sm-2 control-label">profile</label> <div class="col-sm-8"> <select ng-model="user.userdata.profile" ng-options="person._id person.profilename person in user.profile"> </select> </div> hierarchy of vm.profile { "_id": 46, "profile": objectid("5516498e95b84548156db754"), "isactive": true, "password": "$2
Read more

php - Cloud9 cloud IDE and CakePHP -

-
i attempting cakephp running on cloud9, cloud based ide. unaware, cloud collaboration ide intermixes services such bitbucket. site gives sudo rights, , installed cakephp using these instructions: https://www.digitalocean.com/community/tutorials/how-to-install-cakephp-on-an-ubuntu-12-04-vps when attempt run database exported machine cakephp installed, error message "url rewriting not configured on server." attempted solve issue using official guide cakephp: http://book.cakephp.org/2.0/en/installation/url-rewriting.html but no cigar, same error message. has gotten cakephp working, or aware of cloud ide free/low cost cloud9 support cakephp? here's how got working now: sudo apt-get update sudo apt-get install php5-intl curl -ss https://getcomposer.org/installer | php -- --filename=composer ./composer create-project --prefer-dist cakephp/app this creates project in /app default. move workspace docroot: mv app/* ./ mv app/.* ./ rm -rf app then de
Read more