x

SQL Server Performance Drops

One of my customers has a SQL Server 2005 Standard Edition with the current service pack. Over the weekend the Windows 2003 Server had some Windows Update (all security patches) applied. Performance on batch process doing adds, deletes, and updates went from 1000 transactions to 30 transactions per second.

SQL Server is on its own server box. Web application via IIS on its own server box. Both servers are hosted in the cloud and referenced in private network (IP 192.168.x.x)

Anyone heard of any Windows Updates that bog down SQL Server 2005?

Things that we have checked:

  • Running queries across the network and directly on the SQL Server server have same performance drop, so the network infrastructure, network card, and driver do no seem to be impacting the problem.
  • Not all queries on the server are suffering the same percentage of drop, and short queries still run as fast as normal. Batch process is most affected.
  • None of the Windows Updates have any mention of SQL Server.
  • Log file is around 5 GB, database is around 4 GB

The app has been running fine for the last few months since it was implemented.

I am not convinced the Windows Update is nothing more than a coincidence timing wise, but it is hard to ignore as well.

Wondering if there were any recent battles for DBAs or developers with a Windows Update killing SQL Server performance.

more ▼

asked Mar 01, 2010 at 06:09 PM in Default

Rick Schummer gravatar image

Rick Schummer
11 1 1 1

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

Based on your dB size I'll assume you are running off drives on the server and not a SAN.

Was anti-virus software re-configured and exclusions missed?

Did someone alter your SQL memory configs without your knowledge?

Did the O/S team move a pagefile to your dB drives?

Does any other team use your server?

It appears drive based on first glance but without more metrics it will be hard to pin down.

Ciao

more ▼

answered Mar 01, 2010 at 07:29 PM

Blackhawk-17 gravatar image

Blackhawk-17
11.9k 28 31 37

All good questions we are looking into. I know there is no AV, but in the cloud someone else does control certain aspects of the server.
Mar 02, 2010 at 03:38 PM Rick Schummer
(comments are locked)
10|1200 characters needed characters left

Did you get an answer for this? If so please post here, or flag the correct answer! If not...

Use SysInternal's Process Explorer to find out which processes are using most cpu and i/o and where they come from (I've had problems with the DPM agent hogging i/o).

Look for extra/long running jobs and in the logs for unusual activity.

Look at fragmentation, both within SQL and in Windows.

I'm assuming it's not a virtual server?

Windows search wasn't installed in the update was it?!

Dave.

more ▼

answered Mar 31, 2010 at 07:53 AM

user-1392 gravatar image

user-1392
71 1

(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:

x1951
x252

asked: Mar 01, 2010 at 06:09 PM

Seen: 1480 times

Last Updated: Mar 02, 2010 at 06:57 AM