Microsoft Patches for SQL 2000 and Window server 2003

After installing the microsoft security patches on 10 Sept 2011 (KB2535512,KB2536276-v2,KB2544521,KB2544893,KB2555917,KB2559049,KB2562937,KB2566454,KB2507938,KB2567680, KB2570791,KB2607712,KB2476490,KB2503665,KB2570222)
in SQL server 2000 standard edition SP4 and window 2003 server,
file uploading prcess is slower than before applying patches
(before take 15 mins, after patches 30mins). Anybody faced this issue?

asked Sep 21 '11 at 08:16 PM in Default

AYH
11 ● 1 ● 1 ● 2

Those patches are all Window OS patches. None appeared to be a SQL Server patch. Is the uploading you are refering to importing data into a database or uploading files to the server?

Sep 22 '11 at 11:56 AM Shawn_Melton

Hi Shawn,

It is importing data to database server.

AYH.

Sep 22 '11 at 08:32 PM AYH

Browsing those KB articles I did not really see any that appear to affect SQL performance. Could it be that the data import may have grown and it was just coincidence?

Sep 23 '11 at 09:28 AM Shawn_Melton

(comments are locked)

1 answer:

You are running an unsupported version of SQL server and one of the patches have probably replaced something that SQL 2000 is depending on. I soul recommend you to upgrade to SQL 2008 r2

answered Sep 21 '11 at 11:22 PM

Håkan Winther
15k ● 29 ● 35 ● 46

Thanks Winther,

But I have un-installed the pataches already, still slow performance. Slow performance is only uploading time, the rest of the day are running fine no high CPU usage or no high memory too.

Sep 21 '11 at 11:28 PM AYH

(comments are locked)