[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 440
  • Last Modified:

Windows Server 2003 experiences serious performance degradation every day at the exact same time

One of my customer has a Windows Server 2003 R2 SP2 64bit with 16GB of RAM.
They have approx 30 users using  SAP business One, most of them accross the network and a few on remote desktop sessions.
The server performance is fine in the mornings, but deteriorates seriously at 2pm everyday.
We have checked all the usual suspects like the task scheduler, software + anti-virus updates to no avail.
We have also tried to spot any processes in task manager with no result.
We have reviewed employee daily routines to establish if anything specific they do could be the cause with no result.
Does anybody know of any software utilities that we might be able to use to assist us with this problem or does anybody have any suggestions in general ?  
0
Blu3jeans
Asked:
Blu3jeans
4 Solutions
 
Joseph DalyCommented:
You could try performance monitor pr process monitor to see what is using memory/process/etc during this window.

http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx
0
 
mrroonieCommented:
check times for automatic windows updates or maybe a backup is misconfigured to run at 2pm instead of 2am??
 
nothing in event viewer/applications or /system at 2pm?
0
 
Iain MacMillanCommented:
Use Process Explorer from SysInternals as mentioned by Xxdcmast, and also Autoruns from the same place, to check whats running in the background automatically on the server.  Keep PE running while this event takes place and monitor closely.

normally its AV scan or update, patches/updates or Disk defrag.  Also watch SAP and printer services.

  1. what is the performance hit - CPU, Memory or Disk i/O??
  2. Is this a physical or virtual server?  
  3. Which version of SQL is installed??
Check the links below for known issues :-

http://www.sap-exp.com/importance-sap-note-performance-issue-on-microsoft-windows-server-2003.html

http://support.microsoft.com/kb/931308
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
Blu3jeansAuthor Commented:
Thank you all for the input.
We have installed Performance Monitor on the server and will switch on monitoring just before 2pm (C.A.T.)  today.
In reply to questions asked :
1) The performance hit is on memory. (The SQL database size is 43GB, the hard drives are SAS and
    the server has dual XEON processors)
2) It's a physical server
3) SQL 2005 SP3 is installed.

We are digesting the other info and will post feedback ASAP
0
 
9660kelCommented:
You might want to check performance monitor for excessive disk paging as well, it could be a memory leak.
0
 
Iain MacMillanCommented:
thats a massive DB, you have read the notes for the fixes for SQL 2005 SP4, its not been out long (link below).  According to TM and/or Process Explorer, how are you doing for memory/cpu resources??

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=ca6523d1-d265-4c15-b89a-9268e5e3cda4&displaylang=en - SQL 2005 SP4

one thing that may improve performance, other than BIOS & RAID firmware is NIC and chipset driver updates.
0
 
Blu3jeansAuthor Commented:
We have been unable to resolve this issue to date. We found many suggestions helpful and implemented many of them, to no avail though. Thank you all for your input.
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now