-
Problem with Query Analyzer
When I save a file in Query Analyzer the program freezes up for 20-30 seconds at a time.
This is getting very frustrating because out of habit I hit Ctl-S every few lines or so.
I've defragged my disk (it needed it). Rebooted and I'm still having the problem.
Does anyone have a clue as to what the problem is?
Thanks,
Tim
-
1. do you have any virus scan and shield running.
2. what is the default path you are saving? if it is mydocuments then see how big the mydocument folder is. try to archive some data in mydocuments
or try to change the default path.
-
I've got Norton on my box but it's been on there for months and hasn't given me any problems. And it's not currently scanning my system anyway.
The sql files are saved in MyDocuments and the size is ~180MB. I'll try moving somethings out.
Thanks,
Tim
-
I've turned off Norton and I've moved/deleted my older files and I've got it down to ~ 90MB.
I'm still having the same problem. It also hangs when I try to open the File menu.
I've brought up several of my sql files in other text editors and programs and I'm able to save them just fine with no lag.
Any other ideas?
Thanks,
Tim
-
Tried save to other path on the disk? And how big the file is?
-
Yes I have.
It happens across the board. When I click the File Menu to do a Save As I get the same 20-30 sec lag before it shows me the menu options.
Not to mention it still hangs in the new location once I've saved it there.
It seems to be the client that is having the problems besides the file system.
Anything else? I've about exhausted what I can think of.
Thanks,
Tim
-
Do you have any network authentication issue?
-
Just for testing purposes please try do this
close all the windows
1. click Start - run - isqlw - {enter}
-Login
2. Click Tools-options- (General tab)
change Query File directory to C:\
change Result File directory to C:\
3. Click on Editor Tab
change Number of Undo Buffers = 5
Maximum undo buffer size = 255
4. Apply settings. click ok
5. close Query Analyser
6. 1. click Start - run - isqlw - {enter}
-Login
type something and click save button.
BTW what is the free space available on your C drive?
-
I think The problem is in your network. Check what connection have you connected.. in the comand line (cmd) type "net use" to view all connections.
You Have To Be Happy With What You Have To Be Happy With (KC)
-
I have 21GB left on my C:\
I think it's a network problem also.
I took my box off the network and used the Query Analyzer against my local SQL Server and everything worked fine.
But when I hooked back into the network and went against our development Server I get the lag again.
I've looked at the Event View to see if any errors were occuring during this and nothing is showing up there.
Is there a way that I can track/trace where the lag is?
Any more ideas?
Thanks for all your help.
Tim
-
You can trace it with network monitor.
-
Try delete some connections you do not need, or all connections (net use * /delete) and reconnect them back... Maybe some of them are invalid.
You Have To Be Happy With What You Have To Be Happy With (KC)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|