Solved

Microsoft Server 2003 Standard SP2 Freezes

Posted on 2009-05-14
15
402 Views
Last Modified: 2012-08-13
I have a Server 2003 Standard Edition SP2 that act's a a file sharing server as well as runs SQL 2005 and Backup Exec 12d. For some reason it freezes daily. Used to be every couple of Months. Nothing in the event logs points to anything. I have tried uninstalling Symantec Antivirus Corp. and have updated all firmware, drivers etc... I have installed all Microsoft updates. I have no idea what is causing it. The motherboard is an Intel SE7500CW2 with 4GB of RAM. I want to test the memory so can someone reccomend a good program? Is microsofts memory tester suitable for a server? Any help is appreciated.

0
Comment
Question by:clifford_m71
  • 7
  • 5
  • 3
15 Comments
 
LVL 42

Expert Comment

by:EugeneZ
ID: 24392340
<file sharing server >
how fast your server HDDs?


Check memory setting for SQL SERVER, OS..
run perfmon, etc


try
Windows Memory Diagnostic
http://oca.microsoft.com/en/windiag.asp
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 24392349
one more:
what are you running on your sql server? "bad" queries (for example without indexes) can freeze server
0
 
LVL 10

Expert Comment

by:Banthor
ID: 24392435
Can you be a little more desriptive on 'FREEZING'

Is Windows Search installed?
 
 
 
0
 

Author Comment

by:clifford_m71
ID: 24394471
EugeneZ,

Thanks for the quick reply.
The HDD's are  Seagate Barracuda 7200.8 ST3250823AS 250GB 7200 RPM 8MB Cache SATA 1.5Gb/s.

Can you give me a little guidance on the performance monitor. What counters should I use?

The SQL database runs a third party software. I have talked to our application provider and they say no one else is experiencing these issues. Basically I don't know if bad queries are running but I assume that if no other client is having the issues then they should be fine. How can I check?

FYI: When I say freeze I mean freeze. You can see whatever is on the screen at the time it freezes but nothing works. Can't move mouse, use keyboard, remote in, ping, use SQL.....nothing. Have to manually shut down and restart.




0
 
LVL 42

Assisted Solution

by:EugeneZ
EugeneZ earned 250 total points
ID: 24395440
7200 RPM  is very slow - good for file server - not sql server; what is RAID configuration?
this is very "standard" issue- when CPU jumps to 100% , etc. in many cases server memory, etc - effected by bad sql code performances..
BTW: did you patch sql server 2005 - there is fresh sp3, etc..?

check
Understanding Perfmon Counters while troubleshooting SQL Server Performance Issues
http://blogs.technet.com/vipulshah/archive/2006/11/30/understanding-perfmon-counters-while-troubleshooting-sql-server-performance-issues.asp

also
run sql profiler to see what is running on the box
Introduction to SQL Profiler
http://www.developer.com/db/article.php/3482216


<third party software>
it can have memory leaks, etc
--
Again - you probably need to think about better server for sql server...
0
 

Author Comment

by:clifford_m71
ID: 24397414
We have Adaptec 2410SA SATA RAID Controller. 6 total HDD's. 2 mirrored for OS and 4 RAID 5 for data. The SQL is installed on the RAID 5.

We have Dual 2.8 Ghz Xeon Processors that never reach 50% of capacity.

When I ran a SQL trace I had no idea what I should be looking for as far as errors. I do know that the file I saved it to reached 924KB in about 20 minutes. Is that a lot of activity?
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 24397523
raid config is ok -  :( does not make hdd speed faster

size is ok depends what are you tracing -> try to select templates- >  duration for example:
1 MB in 20 mins - no big -> see duration (1000 is 1 sec) and queries
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:clifford_m71
ID: 24406863
EugeneZ,

This may be a question for another forum but if I want to replace my HDD's with faster models can I simply remove one of the drives on the OS mirror then put in a new hard drive and let the mirror rebuild then do the same with the 2nd OS hard drive?

As for the RAID 5 array....can I remove one drive then put in a faster model and let the array rebuild and so on....and so on....

0
 
LVL 10

Expert Comment

by:Banthor
ID: 24407263
There is a template in SQL Profiler called Long Running Queries.
This would be a good place to start
Locks could be the issue.
I am still unclear what you mean by Freeze.
If the desktop is frozen, can you still connect to the database VIA SQLCMD or another workstation.

Can you connect VIA MMC?
0
 

Author Comment

by:clifford_m71
ID: 24418188
Banthor,
When I say freeze I mean it is as if the server were shut off. NOTHING works....No SQLCMD, no logging in from another workstation, no MMC.
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 24421049
yes, you can as long it is hotswappable  just make sure to have all backups - just in case
0
 
LVL 10

Expert Comment

by:Banthor
ID: 24424666
How about errors in the Event Log ?
0
 

Author Comment

by:clifford_m71
ID: 24434179
Banthor, There are no consistent or critical errors in the event log when the server freezes.
0
 

Accepted Solution

by:
clifford_m71 earned 0 total points
ID: 24434245
Out of frustration I have uninstalled Symantec Backup Exec 12D. I let the server run for a couple of days with no backup. I then re-installed it on D: Drive (RAID 5 Array). Since then the server has not frozen. I am still not convinced but so far so good. If things don't hold up I will re-open this issue.

For now I would like to reward half the points to EugeneZ. While there is not a definitive answer yet I believe I should upgrade the HDD's to faster models as EugeneZ suggested.
0
 

Author Comment

by:clifford_m71
ID: 24434251
Oops! I forgot to add.....how do I reward half the points?
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how the fundamental information of how to create a table.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now