Hoping for tips on monitoring resource utilisation

-

hi,
implementing sql server integration services (ssis) solution on windows server 2003.

have problem overnight process (dtexec.exe) seems "freeze" , don't know why. "freeze" mean see entries in logfile:
dataflow: 2010-02-21 22:09:20.69
   source: dft dataflow
   component "lkp dim client" (792) receive 0 rows on input "lookup input" (793)
end dataflow
dataflow: 2010-02-21 22:09:20.69
   source: dft dataflow
   component "lkp dim contract" (843) w

knows ssis (and granted, suspect doesn't include around here) knows log records unusual. can see log record has been partially written - strange thing if leave process long enough (and i'm talking hours here) log record gets written in entirety , execution continues unabated.

awry. suspicion of our machine resources getting constrained, either cpu or memory. reasno visiting forum haven't clue how go monitoring these resources.

know perfmon overnight process , have no desire sit here until hours staring @ perfmon :)

can recommend tool monitoring/capturing cpu , memory utilisation in situation? i'd prefer built windows if have go 3rd party....so it!

in advance advice. if haven't explained things enough please let me know.

regards
jamie thomson
http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | about me

ignore this. i've learnt how set perfmon traces log file , replay them.

cheers
http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | about me


Windows Server  >  Windows Server General Forum



Comments

Post a Comment

Popular posts from this blog

Edit Group Policy

-
i have pc has power settings pushed out default domain policy in ad environment. of course on local machine "some settings managed system adminstrator". the machine temporarily no longer in contact domain controller (it's been physically moved , not on same network now) can't updated gpo settings. i believe if edit local group policy won't make difference because of group policy processing , precedence. since it's temporary away ad network, still want use settings of ad user. is there somewhere in registry stored can edit power plan manually until can sync domain? (i need prevent sleeping while plugged in - it's set 1 hour) thanks! allen crist i found site: http://gpsearch.azurewebsites.net/#7916 i able add policy to hkey_local_machine\software\policies\microsoft\power using specs found on site. looks solved issue. i'll report if didn't. thanks! allen crist ...
Read more

Hyper-V VM not reaching OS 'Logon' screen

-
i trying migrate vm vmware hyper-v. so far have done following (seemingly successfully): prepare vmware vm conversion hyper-v format (vhd) within vmware workstation 8.0 environment following steps guide: http://social.technet.microsoft.com/forums/en/winserverhyperv/thread/ef8c12f7-c45d-442e-9a30-c43cd87df3b3   (i.e. remove vm tools, add new ide hard disk…) use vmdk2vhd application convert individual vmdk files vhd ones create new vm in hyper-v exporting in 3 newly converted vhd files at point have checked settings , powered on vm in hyper-v find although windows begins load expected manages reach screen prior login screen saying either of following messages: “windows starting up…” “the active directory rebuilding indices… please wait” to knowledge, albeit limited in area, vm should present me login screen since appears in vmware. if start vm in safe mode can login not desired affect. below details of vm: operating system: windows server 2003 (enterprise edit...
Read more

DNS question...

-
i new setting dns server....my domain name expl. "domain.com"....i set "a" record in forward lookup for  www.domain.com itself...."server's local ip"....i've added no other zones , i seem able resolve names except own....www.domain.com.....also, do i put my isp's dns ip's....for external dns's server can't resolve?....forwarding or in nic setup?......i want setup in my dns server don't have include them on client side..... thanks mark     not put isp dsn server address in settings on nic dc or clients. should point local dns server on dc. set dns forward public dns, such isp. bill Windows Server  >  Network Infrastructure Servers
Read more