| HelpMeIfYouCan 2005-06-29, 3:23 am |
| Sunday I received a call from a user that a critical SQL Server app was
getting a Timeout Expired error message. Looking into the problem a stored
procedure that use to take 17 seconds to execute was now taking 323 seconds
(20 times as long) to return the data. I've tested this database on 5
machines now. 4 of which were Server 2003 test servers and my XP Laptop.
The SP in question on all of the 2003 boxes takes in excess of 3 minutes
usally the upper 3's to execute. My XP Laptop executes that same SP in 13
seconds. What's the deal? Has anyone heard of a known problem with Server
2003 and SQL Server. I've update all the machines to the latest Service
Packs and I've even gone as far as backing off the Hotfix's for 2003. With
2003 all updates installed SP1 (Standard or Enterprize) and SQL Server with
SP 4 I have this same performance problem. I opened a case with my Universal
subscription an had a Microsoft rep send me a TSQL script to Update
Statistics on all tables in the database. That didn't fix anything. I'm
running out of options. Does anyone know of someone that's having similar
problems recently.
|