x

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?
more ▼

asked Sep 21, 2011 at 08:16 PM in Default

AYH gravatar image

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, 2011 at 11:56 AM Shawn_Melton

Hi Shawn,

It is importing data to database server.

AYH.
Sep 22, 2011 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, 2011 at 09:28 AM Shawn_Melton
(comments are locked)
10|1200 characters needed characters left

1 answer: sort newest
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
more ▼

answered Sep 21, 2011 at 11:22 PM

Håkan Winther gravatar image

Håkan Winther
16k 35 37 48

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, 2011 at 11:28 PM AYH
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x476
x28

asked: Sep 21, 2011 at 08:16 PM

Seen: 1102 times

Last Updated: Sep 22, 2011 at 10:43 AM