long time to connect to sql server
-
I do not know why recently it took me long time to open the sql enterprise manager and the database.
Any procedures to fix this problem.
Thx.
-
Is it all the time or just occasionally?
We have one app that periodically builds up a number of blocked tasks, and when this happens EM connection performance is substantially degraded.
...
-- FORTRAN manual for Xerox Computers --
-
just happened . but I am the only use the server. How do improve if the case like yours ? Thx.
-
A few ideas:
1. If possible, try restarting SQL Server Agent. When we have had similar problems it has been because of SQL Jobs and SQL Mail.
2. PING your SQL Servers and check the response times. Also, try opening Enterprise Manager on the server itself. If its quick then it could be a network related problem.
3. Check the current activity within SQL (just in case).
4. Check the processor usage on the SQL Server. Is SQL using alot of processor time? You could try stopping non-essential services if they are using alot of processor time. (If you stop the virus checker etc. remember to restart them!)
5. Make sure you have the latest SQL service packs and Windows updates applied.
6. If all else fails, try rebooting your SQL Server!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply