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
Solved

Microsoft Server 2003 Standard SP2 Freezes

Posted on 2009-05-14
15
409 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
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 

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
 

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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
backup job space check 4 44
where to find DTS instalation package for sql 2014 64 bit 3 10
SQL Log size 3 17
RESTORE MASTER DATABASE -- NOW 2 19
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

856 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