sqlwb.exe uses 100% CPU when in SSMS I try to setup local replication

• ajay.nabh

  SSC Rookie

  Points: 44

  More actions

  May 17, 2010 at 9:12 pm

  #235186

  Hi Guys

  new to the forum and sql 2005!! I have a problem where I open SSMS and expand replication option --> Local Publication --> right click on Local Publication and then click on new publication, My CPU will jump to 100%, sqlwb.exe would be using 70% of the CPU and new publication wizard will never start. then I have to kill sqlwb.exe. also see "is Busy" pop up right hand side bottom corner. however I can start Local subscription wizard with no issues.

  PLease suggest how can I fix this issue? SQL 2005 with SP3 on W2K3 with SP2

  Thanks a lot

  Aj

• Roy Ernest

  SSC-Dedicated

  Points: 38780

  More actions

  May 18, 2010 at 11:26 am

  #1168981

  This looks more like a HW issue. What kind of system are you experiencing this problem?

  -Roy

• ajay.nabh

  SSC Rookie

  Points: 44

  More actions

  May 19, 2010 at 10:52 pm

  #1169861

  Hi

  Thanks for your comments

  it is virtual environment

  windows 2003 R2 Sp2 It is VM

  SQL Server 2005 SP3

  1 proc 4 GB RAM

  5 DB

  thanks

• Roy Ernest

  SSC-Dedicated

  Points: 38780

  More actions

  May 20, 2010 at 7:00 am

  #1170080

  Check how much free memory you have and how is your Disk IO. Also are you running out of disk space? All of these can cause the CPU to go 100%

  -Roy