Query Analyzer Not Responding

[fuzzyocelot]

Hi everyone!

I'm running Query Analyzer 8.00.194 on my computer (Windows XP SP 2 with 2 GB RAM). I connect to SQL Server 2000 which is on a server somewhere. Note: We will be upgrading to 2005 some time this year.

I'm currently using Query Analyzer to develop stored procedures. Every so often when I save the query, the Query Analyzer locks up and I see "Not Responding" in the Task Manager. It won't do anything until I end the task using the Task Manager. I can't try reinstalling it yet because our DBA is out of the office for the entire week. Does anyone have any ideas as to how to fix this? It's been doing this off and on for quite some time and it's getting tiresome.

Thank you!!!
Rebecca

 

[Catadmin]

Task Manager will often show "Not Responding" for a SQL tool when it has sent the data to the server and is waiting for a response from it. "Not Responding" doesn't necessarily mean something is wrong. You could just literally have a query that takes forever to run.

One way to test this is to start the query again. Watch your cursor turn to an hourglass (if that's the busy icon you have set up) and see if you can minimize the window or hit the stop button after a minute or two. If you can do those two things, than QA isn't really frozen. It's just waiting for a result set.

If you have access to Profiler, you can run Profiler to see what in your query is causing the problem. You can also do a "Display Estimated Execution Plan" in QA to see if there are any Index or Table Scans (Very Bad Things) in your query which means you should rewrite your query or add index hints to it.

Lastly, try to PING the SQL Server from the command prompt of your PC. If you're losing packets or it's taking forever to return anything, it's a network issue and has nothing to do with you or SQL at all.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[fuzzyocelot]

Hi!

I really appreciate your quick response; however, it appears to be locking only when I'm trying to save the query to a file. This does not happen when I run the query itself. Just when I save it to a file. When this happens, I get the hourglass and the entire query analyzer window goes blank. I can't see any buttons or anything except for the minimize, restore, and close buttons on the upper right corner of the window. It doesn't matter which query or stored procedure I am using either. I can create a new simple query and save it to a file with no problems. Then later on when I try to save it, it seems to lock up and will sit there for 30 minutes if I let it. Any ideas?

Thanks!
Rebecca

 

[SQLBill]

One BIG issue...you say your version is 194. That is the RTM (no service packs, no updates) version. You really should update it to SP3a at a minimum. That might even solve your problem.

-SQLBill

Posting advice: FAQ481-4875