Solved

All open application freezing, except SQL Analyser

Posted on 2009-05-06
8
352 Views
Last Modified: 2013-12-05
I might have 3 apps open at the time.  Lotus Notes, SQL Server Enterprise Manager and SQL Query Analyser.  I am working in SQL Analyser and everything is fine.  I run some queries, maybe 20 rows returned - nothing big.  Then after a period of time, if I try to switch to Lotus or Enterprise Manager - they dont open.  They are highlighted in the task bar, but the window is the Analyser window.  Sometimes "part" of the app I am selecting shows, but it doesnt get focus.  I select SQL Analyser from the task bar and it goes back into Analyser, fully functional and I can run queries etc as normal.  

If I CTRL+ALT+DEL, that freezes as well, I can see what processes are running.

HOWEVER.  If i switch back to SQL Query Analyser and close down the application - everything returns to normal.

Why?  Is this a memory issue?  Should SQL be reinstalled?

These problems just started to occur 3 days after installing Office 2003.
Using Windows 2000 and SQL 2000.  
2GB Ram
0
Comment
Question by:Wedmore
  • 3
  • 3
  • 2
8 Comments
 
LVL 3

Expert Comment

by:Aaog
ID: 24317222
Ouch.  Definitely seems like a resource issue.  The query analyzer isn't running anything during this time of slowness?  And does it slow down only after you've queried the database?
0
 

Author Comment

by:Wedmore
ID: 24317383
No its not running anything during the freezing.  I would say it only happens AFTER I have been running queries for a period of time, but not always immediatley after.  For example as I write this, I switched to Analyser ran a query pulling 200 rows and I am back again without issue.

Give it 10 mins or so, the bad stuff happens.
0
 
LVL 2

Expert Comment

by:quistlogic
ID: 24338261
There must be a memory leak in one of the programs.  Are they all up to date?  Maybe you can leave Task Manager (Alt+Ctrl+Del) open and leave the computer for a while.  Come back and find out who's hogging the memory.  Find all updates for that program or consider upgrading to the newest edition.

Are you upgraded to SQL 2000 SP4?  http://support.microsoft.com/kb/888799

Extended Support from Microsoft ends in 2012, so you have some time to investigate SQL 2005 (the next step up).
0
 

Author Comment

by:Wedmore
ID: 24338345
Just checked and I have SP4 installed.  I agree it has to be something going on with Query Analyser.  Is there an event logger I could use in Windows 2000 that I could monitor this?  Yesterday it was occuring after only 2 mins.
0
Are your end users making ugly email signatures?

Have you left it up to your end users to create their own email signatures? Are they forgetting to add the company logo or using garish font colors? Take control and ensure all users have the same email signature.

 
LVL 2

Expert Comment

by:quistlogic
ID: 24338438
Hopefully this can help explain the process.
http://support.microsoft.com/kb/302542
0
 

Author Comment

by:Wedmore
ID: 24358711
Oddly enough when I opened Event Viewer the problems subsided for a while.

Anyway, this morning I had Lotus Notes open and MS Paint.  I was editting some large BMP files, copying pasting etc.  Saved the picture, closed MS Paint, opened the folder where the BMP was located and attempted to email the picture as an attachment.  The computer didnt necessarily freeze, but you could believe it was.  It slowed to a crawl.  

So I only had Lotus notes open and a folder on the network, I opened the task manager and it said "Not Responding" beside both the folder and lotus app.  Eventually they would switch to "responding" for a second or so and switch to "not responding".  During this time the CPU was only at 1% and the System Idle process was going crazy.  

Now my instinct suggests this is memory related, as mentioned above.  Is there anyway to prove or diagnose any bad memory issues.
0
 
LVL 3

Assisted Solution

by:Aaog
Aaog earned 100 total points
ID: 24358880
I think the simplest first step, like quistlogic suggested, is to have the task manager open and check the running processes.  Sounds like you did that already for CPU but take a look at the Memory usage there.  Which process is taking the most?  Also, is it much more than it should be (may be hard to tell at first if you're not sure of the usual amount taken) and is it growing over time (memory leak)?

Especially relevant here is also, is all your RAM or close to all of it being used (which would significan;ty slow things down)?  2GB should be enough but not if there is an unreasonable amount being used due to some leak.  Does the event viewer say anything interesting at about the time it started freezing up?  (Application section or System Section especially).  
0
 
LVL 2

Accepted Solution

by:
quistlogic earned 400 total points
ID: 24360842
I've used http://www.memtest.org/ in the past, can't say I remember how to use it now.

Recently updated for use with Core i7 processors, so I'm sure it'll handle whatever you throw at it.  Including legacy processors. :)


Additionally, I found a thread on here that might help -- A LOT! It seems you can limit the amount of memory used by SQL.

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20562868.html?sfQueryTermInfo=1+10+2000+memori+test+window


Here is another post with Memory Test responses.

http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Windows/2000/Q_21601670.html?sfQueryTermInfo=1+10+2000+memori+test+window
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Issue: One Windows 2008 R2 64bit server on the network unable to connect to a buffalo Device (Linkstation) with firmware version 1.56. There are a total of four servers on the network this being one of them. Troubleshooting Steps: Connect via h…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
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 to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

911 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