c# - Multithreading application versus active sql session -

-

have c# application running multi-threaded (parallel.foreach) 16 maximum concurrent threads. can see working fine because performance of execution time faster. however, wondering why showing less 16 active sessions on sql server monitor tool? bizarre part same application (similar set except using sql server 2012 instead of our sql sever 2008r2) running on our customer's machine, same tool report more 30 active session monitored. since can't access our customer's enviornment, wondering:

1. why there few active sessions found (usually less 5) on sql server while have 16 threads running concurrently?

2. why there more 30 active sessions reported on our customer machine? claim system isolated has our application access @ moment...

first 1 chart when running on environment: here chart when running on environment:

vs chart when running on our customer's environment: here chart when running on our customer's environment:

comment, , here trying provide more information:
i. confirmed application running single instance, , console desktop application.

ii. datawarehouse migration, download xml file server, , using same connection string on each thread (inside parallel.foreach , import data using nhibernate, part of code blackbox me since not familar nhibernate, call in-house dll carry out function)

iii. don't have information customer's machine knew have more powerful machine test server mine 16gb quadcore 64 bits win7. big difference using sql server 2012 , test server (who running application) sql 2008 r2 server (i.e. datawarehouse client db repository).

iv. understand each connection string should share 1 pool, have no clue why same monitor tool showing different number of sessions between me , customer's environment.

unless bad programmer code open , close database connections when needs them, using using construct.

and if tasks else read , write data means not keep connection open time.

which means naturally see less open connections - size of connection pool active. not reach sam e size of tasks because not used time.


Comments

Post a Comment

Popular posts from this blog

c++ - QTextObjectInterface with Qml TextEdit (QQuickTextEdit) -

-
i registred handler simple qtextobjectinterface , draws 10x10 red rectangle. when used qtextedit in normal qwidget app, worked. when used qquicktextedit (textedit qml component) in qt quick app, doesn't worked (nothing drawed, rectangle in textedit reserved, because when change cursor position, notice there something, empty space, nothing drawed. qtextobjectinterface intrinsicsize method called (that explains why see there empty space 10x10), drawobject method isn't. i did research , found problem here: qquicktextedit.cpp qt 5.3.0 sources (line 1821) qsgnode *qquicktextedit::updatepaintnode(qsgnode *oldnode, updatepaintnodedata *updatepaintnodedata) { . . . if (textframe->firstposition() > textframe->lastposition() && textframe->frameformat().position() != qtextframeformat::inflow) { updatenodetransform(node, d->document->documentlayout()->frameboundingrect(textframe).topleft()); c...
Read more

javascript - angular ng-required radio button not toggling required off in firefox 33, OK in chrome -

-
i trying toggle required attribute on radio button using angular show html5 popup. i cannot following code function correctly in firefox 33. function correctly in chrome. required property being toggled via checkbox value, in firefox, when set false radio button still acts required , shows html5 required popup. see plnkr below example doesn't work me in ff 33. <!doctype html> <html> <head> <script data-require="angular.js@*" data-semver="1.3.1" src="//code.angularjs.org/1.3.1/angular.js"></script> <link href="style.css" rel="stylesheet" /> <script src="script.js"></script> </head> <body ng-app="myapp"> <script> angular.module('myapp',[]) .controller('mycontroller',['$scope',function($scope) { $scope.foorequired=true; $scope.submitform = function() { $scope.submitmessage = ...
Read more

xcode - Swift Playground - Files are not readable -

-
Image
files not readable in swift playground . how make files readable? same code runs on xcode terminal app, fails on swift playground. demo code below. import foundation println("hello, world!") var fname:string = "/users/holyfield/desktop/com.apple.iconcomposer.plist" var fm:nsfilemanager = nsfilemanager.defaultmanager() if(fm.fileexistsatpath(fname)){ println("file exists") if(fm.isreadablefileatpath(fname)){ println("file readable") var fd:nsdata? = nsdata(contentsoffile: fname) println(fd?.length) let pl = nsdictionary(contentsoffile: fname) println(pl?.count) println(pl?.allkeys) }else{ println("file not readable") } } else{ println("file not exists") } sample images: i have thank nate cook first quick response , solid answer. just case share answer post, title misleading. see nate's answer here: https://stackoverf...
Read more