Solved

Microsoft Server 2003 Standard SP2 Freezes

Posted on 2009-05-14
15
403 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

929 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

12 Experts available now in Live!

Get 1:1 Help Now