Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Microsoft Server 2003 Standard SP2 Freezes

Posted on 2009-05-14
15
Medium Priority
?
438 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 5
  • 3
15 Comments
 
LVL 43

Expert Comment

by:Eugene Z
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 43

Expert Comment

by:Eugene Z
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

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 43

Assisted Solution

by:Eugene Z
Eugene Z earned 1000 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 43

Expert Comment

by:Eugene Z
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
 

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 43

Expert Comment

by:Eugene Z
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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

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.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
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
Suggested Courses

610 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