provider and IIS hold so much cpu resource. by the way, memery
condition is normal.
when i restart sqlserver, from windows task manager, i see the cpu time
of sqlserver.exe process is low, but it grows gradually, and in two
days, it can grow to as high as 2:xx:xx.
any one can tell me why .net sqlclinet data provider and IIS hold so
much cpu resource? and why cpu time of sqlserver.exe grows gradually?
thanks a lot.
below is the part of a trace report:
TextDataApplicationNameDurationStartTimeReadsWritesCPU
NULL.Net SqlClient Data Provider189123357:46.529168411040076
NULL.Net SqlClient Data Provider277798310:19.27923583730414
NULL.Net SqlClient Data Provider189504657:42.722503411526282
NULL.Net SqlClient Data Provider189957657:38.2161560740425570
NULLInternet Information Services43009602:52.77042962721518
NULL.Net SqlClient Data Provider277362310:19.16577581019828
NULL.Net SqlClient Data Provider68673308:21.03144731014904
NULLInternet Information Services33395630:11.666142618512188
NULLInternet Information Services60609310:07.49384117111124
NULL.Net SqlClient Data Provider37281323:04.9111621010686
NULL.Net SqlClient Data Provider170658028:33.72410832077626
NULLInternet Information Services64606024:35.3238936207390
NULL.Net SqlClient Data Provider109062338:32.911946207109
NULL.Net SqlClient Data Provider89465642:20.85394306778
NULL.Net SqlClient Data Provider78986006:40.766466706483
NULL.Net SqlClient Data Provider68856331:44.82884206420
NULL.Net SqlClient Data Provider79023344:29.73802006077
NULL.Net SqlClient Data Provider56975000:21.587254356049
NULL.Net SqlClient Data Provider110423338:12.911020565453
NULL.Net SqlClient Data Provider56978000:21.5111749415217
NULL.Net SqlClient Data Provider149207631:42.65649825122
NULL.Net SqlClient Data Provider142872027:40.27825734877
NULL.Net SqlClient Data Provider173951628:27.111265694653
NULL.Net SqlClient Data Provider169073328:26.59107804640
NULL.Net SqlClient Data Provider40656306:52.74912304391
NULL.Net SqlClient Data Provider56973601:17.73792804344
NULL.Net SqlClient Data Provider87886028:25.46157204280
NULL.Net SqlClient Data Provider78981306:40.7160337554279
NULL.Net SqlClient Data Provider28615610:42.01521704172
NULL.Net SqlClient Data Provider180126328:07.98573904138
NULL.Net SqlClient Data Provider26623352:11.54391104048
NULL.Net SqlClient Data Provider42412613:13.33311404046
NULL.Net SqlClient Data Provider45828349:48.71569404014
NULL.Net SqlClient Data Provider59893648:20.44212603983
NULLInternet Information Services38987657:32.910983643923
NULL.Net SqlClient Data Provider40825051:56.11565203922
NULL.Net SqlClient Data Provider44153050:05.41727103906
NULL.Net SqlClient Data Provider49392303:29.66312503890
NULL.Net SqlClient Data Provider35761025:20.51493003797
NULL.Net SqlClient Data Provider35456343:38.81570403782
NULL.Net SqlClient Data Provider37890649:44.61523103689
NULL.Net SqlClient Data Provider36323643:30.21596403673
NULL.Net SqlClient Data Provider43392348:08.21566003672
NULL.Net SqlClient Data Provider22059321:53.91434903645
NULL.Net SqlClient Data Provider184018628:04.68771003637
NULL.Net SqlClient Data Provider40776351:38.71646203595
NULL.Net SqlClient Data Provider40970350:47.01393003389
NULL.Net SqlClient Data Provider65773645:36.83863503376
NULL.Net SqlClient Data Provider44501348:17.71387003342
NULL.Net SqlClient Data Provider40331351:24.91290503266
NULLInternet Information Services60418628:05.5146475413035
NULLInternet Information Services60220337:13.79609252955
NULL.Net SqlClient Data Provider34518623:32.612010402955
NULL.Net SqlClient Data Provider30251314:52.01217902937
NULL.Net SqlClient Data Provider37945357:47.331948102891
NULL.Net SqlClient Data Provider35692347:15.61096402564
NULL.Net SqlClient Data Provider37964019:33.51062602453
NULL.Net SqlClient Data Provider161006329:47.711812422391
NULL.Net SqlClient Data Provider75999648:30.68796232376
NULL.Net SqlClient Data Provider76001348:30.65651302187
NULL.Net SqlClient Data Provider158300030:14.79316502157
NULLInternet Information Services55791032:46.851272111967
NULLInternet Information Services25312653:29.67935541893
NULL.Net SqlClient Data Provider95000027:14.33036801875
NULL.Net SqlClient Data Provider56968607:22.5112528421842
NULLInternet Information Services21875054:04.03855301811
NULL.Net SqlClient Data Provider126831335:28.4162994581782
NULL.Net SqlClient Data Provider141667332:47.97308401674
NULLInternet Information Services55525047:41.07781181639
NULL.Net SqlClient Data Provider88247028:21.84272901638
NULLInternet Information Services25129653:31.553638181626
NULL.Net SqlClient Data Provider88981328:14.44857501625
NULLInternet Information Services19851600:16.159345501580
NULL.Net SqlClient Data Provider56970601:17.77347301576
NULLInternet Information Services52651647:51.24524581565
NULL.Net SqlClient Data Provider37881326:26.96875301467
NULL.Net SqlClient Data Provider81989043:15.75487301312
NULLInternet Information Services37651632:48.275602141297
NULL.Net SqlClient Data Provider30257614:51.91455351801266
NULL.Net SqlClient Data Provider94970357:49.66191501238
NULL.Net SqlClient Data Provider34781323:29.93622901203
NULL.Net SqlClient Data Provider76679630:17.53368101170
NULL.Net SqlClient Data Provider107081039:00.44675901109
NULL.Net SqlClient Data Provider49532648:22.548276101095
NULL.Net SqlClient Data Provider50011048:49.252299511078
NULL.Net SqlClient Data Provider37954657:49.7448401062
NULL.Net SqlClient Data Provider88336028:20.94006501049
NULL.Net SqlClient Data Provider24511033:33.0489701032
NULL.Net SqlClient Data Provider88495328:19.33754801031
NULL.Net SqlClient Data Provider60478303:26.6451490968
NULL.Net SqlClient Data Provider49395303:29.5640980955
NULL.Net SqlClient Data Provider54786019:17.0377930938
NULLInternet Information Services29589006:38.7446491907
NULL.Net SqlClient Data Provider33442300:18.767960891
NULL.Net SqlClient Data Provider86037628:43.9126870858
NULLInternet Information Services40493639:47.8471172843
NULL.Net SqlClient Data Provider68973331:53.8315881796
NULL.Net SqlClient Data Provider50568649:43.33473121796
NULL.Net SqlClient Data Provider50345348:13.1276641764
NULL.Net SqlClient Data Provider72609348:20.5210820702
NULL.Net SqlClient Data Provider24520333:32.9381320688
NULL.Net SqlClient Data Provider28625010:41.9285548686
NULL.Net SqlClient Data Provider173781330:13.5169100659
NULL.Net SqlClient Data Provider34089023:36.953030625
NULL.Net SqlClient Data Provider34144023:36.327820625
NULL.Net SqlClient Data Provider41397050:40.9287224610
NULL.Net SqlClient Data Provider34073323:37.0213300608
NULL.Net SqlClient Data Provider53148348:02.7270060595
NULL.Net SqlClient Data Provider35764025:20.5402862594
NULL.Net SqlClient Data Provider56892033:54.6284070593
declare @.P1 int set @.P1=1033 declare @.P2 int set @.P2=20644 exec
p_splitpage @.sql = 'Select
UserName,Status,Qymc,Qylb,areaCode1,SiteHits,Zycp, CONVERT
(varchar(300), Qyjj) AS Qyjj,QyjjStatus,compPhone,compFax From UserInfo
Where isValid=1 and Right(Status,1).Net SqlClient Data
Provider481308:18.211296955578
NULL.Net SqlClient Data Provider49670348:13.6268720563
NULL.Net SqlClient Data Provider49137349:58.5275230562
NULL.Net SqlClient Data Provider37967019:33.5404290562
NULLInternet Information Services39212632:22.61511612543
NULL.Net SqlClient Data Provider51453048:13.0228450532
NULL.Net SqlClient Data Provider65514048:42.740750531
declare @.P1 int set @.P1=5587 declare @.P2 int set @.P2=55867 exec
p_splitpage @.sql = 'Select
Info.picPath,Info.Info_ID,Info.postUser,Info.infoT ype,Info.infoLevel,Info.infoDirect,Info.showname,I nfo.postDateTime,Info.areaCode,CONVERT
(varchar(300), Info.conten.Net SqlClient Data
Provider94014:55.0139021180516
exec p_splitpage 'Select
ID,UserName,PassWord,Qymc,RegisterTime,name,Phone From UserInfo Where
isValid = 1 and UserName like ''%nick%'' and
SUBSTRING(Status,2,3)=''019'' Order By ID DESC',0,30Internet
Information Services131335:39.814030516
NULL.Net SqlClient Data Provider24104607:30.7216430514
NULL.Net SqlClient Data Provider56918635:46.737300499
NULL.Net SqlClient Data Provider36893650:51.7199720486
NULL.Net SqlClient Data Provider102501628:10.9231642485
NULL.Net SqlClient Data Provider54798619:16.9340860485
NULL.Net SqlClient Data Provider42397013:13.4397300483
NULL.Net SqlClient Data Provider37964012:11.1330690470
NULLInternet Information Services18441037:30.3261545468
NULL.Net SqlClient Data Provider43448606:16.9191610468
NULL.Net SqlClient Data Provider36296652:15.4190060436
NULLInternet Information Services11064001:43.984251422
NULL.Net SqlClient Data Provider37975057:40.8210330419
NULL.Net SqlClient Data Provider5279655:44.9159260406
NULL.Net SqlClient Data Provider33442300:18.7325502392
NULLInternet Information Services11436047:40.4148070390
NULL.Net SqlClient Data Provider39812636:26.138510343
NULL.Net SqlClient Data Provider155228331:21.2164340329
NULL.Net SqlClient Data Provider4187655:55.8164293328
NULL.Net SqlClient Data Provider36928023:08.5144192328
Select Count(ID) From UserInfo Where isValid=1 and Right(Status,1)<>'0'
and hy = '0019'.Net SqlClient Data Provider98308:31.9232480298
SELECT TOP 5 L.title, L.siteUrl FROM Links L INNER JOIN LinksCategory C
ON C.PKID = L.CategoryID INNER JOIN LinksType T ON T.typeID = C.typeID
WHERE (T.typeID = 7).Net SqlClient Data
Provider3057654:41.622720282If i recall correctly, CPUTime is the cumulative time spent. It is NOT
the amount of the CPU that is currently being used, but rather the
amount of cpu time that has been used since the process started.
No comments:
Post a Comment