SQL Server 2008 R2 Data Collection and WMIPrvSE.exe


long time lurker/reader, first time poster... :)

i've been working on new environment prepare upgrade our 2000 environment 2008r2.  in qa, did simulation of normal day's traffic against databases, decided wanted capture data , try use data collection tool set so.  setup snap , , running, writing out 1 of our other databases.

in monitoring server whole, sql server instances seemed behave , had no problems keeping work load.  qa people impressed responsiveness of reports applications.  1 thing myself , 1 of sa's noted there 2-3 wmiprvse.exe processes, cluster services , svchost.exe processes eating 25-30% of cpu.  little suprirsed, failed on our second node in cluster , started testing again.  time, data collection running, there no wmi/svc/clsvc processes hogging cpu.

both sa , myself sat there scratching our heads.  we've got few more tests run , things dig into, wanted see if else has had similar issue?  here's our current setup:

2-node cluster on vmware vsphere 4.1, windows server 2008 r2 enterprise sp1, sql server 2008 r2 cu5, running in active/passive mode

 

hi notsocleverdba,

windows management instrumentation (wmi) part of microsoft windows operating system provides management information , controls programs in enterprise environment. wmiprvse.exe host process wmi provider services. essential service start whenever specific piece of software requires facilities.

the collecting data remote can load wmiprvse.exe in-process. please refer link more information on troubleshooting: sql server (2005, 2008) performance counter collection problems.

you can check these 2 nodes same operate system see if installed different roles or features or other third party application may load wmi provider service.

best regards,
stephanie lv



SQL Server  >  SQL Server Tools



Comments

Post a Comment

Popular posts from this blog

SQL server replication error Cannot find the dbo or user defined function........

hi there, i ran problem while deploying sql 2008 transactional replication between 2 servers lets assume server , b. actually created  both distributor , publisher on server , after created subscriber pointed server b, launch replication monitor , found big red cross. when click on tab "distributor subscriber history" error says "cannot find either column "dbo" or user defined-function or aggregate "dbo.ufnleadingzeros", or name ambiguous". can body regarding issue. regards, ishuv hi, you need compare data , others reseved, index size, unused should not compared. differs. here server - data - 87896 kb server b - data - 78152 kb server data size includes publication tables, can't compare directly. need check article article know exact data size. SQL Server  >  ...
Read more

BIT Version

  hi,     knows how find out ther bit version in sql  , windows os (32 or 64)   regards, s.balavenkatesh   microsoft sql server 2005 - 9.00.1399.06 (intel x86) oct 14 2005 00:33:37 copyright (c) 1988-2005 microsoft corporation standard edition on windows nt 5.2 (build 3790: service pack 2)     intel x86)   -- says sql server 32 bit   madhu SQL Server  >  SQL Server Tools
Read more

Admin Permissions

hi need create new 'role' following permissions, 1. access sql server logs. 2. access maintenance plans ( can avoid access) 3. access activity monitor 4. normal access product databases , not system db´s need guidance on how it, can point me in right direction please? thanks 1.grant  execute on xp_readerrorlog [domainname\ad user or group]; 2. http://technet.microsoft.com/en-us/library/ms191002.aspx 3.view server state permission 4. make user member of dbo_owner database role. best regards,uri dimant sql server mvp, http://sqlblog.com/blogs/uri_dimant/ ms sql optimization: ms sql development , optimization ms sql consulting: large scale of database , data cleansing remote dba services: improves ms sql database performance sql server integration services: business intelligence SQL Server  >  ...
Read more