slow processing after Service Pack upgradation

• deb-128405

  SSC Veteran

  Points: 275

  More actions

  September 17, 2005 at 3:21 pm

  #87652

  Hi,

  I have just upgraded one of our production dbs(sql 2000) with latest service packs( change from 3 to 4) and others hot fixes.Also upgraded the 2003 WIN2k box with all the hot fixes. Since after,all my processing is taking almost double time to complete.We have processings which runs thrice a day , which pulls/massages data from our central db.I did identify few store procs which are running very slowly.My question.

  1.Did any one face this issue before , and if yes, could anyone list where all it could have got affected?

  2. What all non-db related things i should be looking at?

   

  Thanks in advance,

  Deb

• Shawn Denogeon

  SSChasing Mays

  Points: 634

  More actions

  September 19, 2005 at 5:51 pm

  #591195

  I don't know yet; but, if any server I'm involved is affected, I don't think I see evidence of it yet. I've been following along here:

  SP4 issue

  http://groups.google.com/group/microsoft.public.sqlserver.server/msg/b86e343e513ab281?hl=en

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=52230&whichpage=3

  http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic1883.aspx

  http://www.dbforums.com/t1174282.html

• Prasad Bhogadi

  SSCrazy Eights

  Points: 9235

  More actions

  September 20, 2005 at 10:44 am

  #591422

  There are definitely some performance issues with SP4 on SQL Server 2k, for more information please follow this link.

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=52230

  Thanks

  Prasad Bhogadi
  www.inforaise.com

• deb-128405

  SSC Veteran

  Points: 275

  More actions

  September 20, 2005 at 2:33 pm

  #591502

  thanks prasad.

   

  went thorugh the links but the problem still persists