Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
harshal_in
Aged Yak Warrior
633 Posts |
 Posted - 2002-10-24 : 01:03:36
|
| My SQL server hangs up when I start the enterprise manager. the databases are running as before the client can connect to the server and work on it but if I try to connect sitting on the server it hangs up but if I connect thru query analyser it connects to the database after 15 minutes. the last thing that I had done was I had some 500 insert statements to be executed while executing those the server performance moniter showed 100% and after that the enterprise manager never opens. Please help. harshal |
|
|
Kevin Snow
Posting Yak Master
149 Posts |
Posted - 2002-10-24 : 13:29:45
|
| Running EM on the server takes up more resources than connecting from a remote client...but not much. Do you have any severe limitations on memory or free disk space? Any chance the log files are full? |
 |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2002-10-25 : 00:44:17
|
quote:
Running EM on the server takes up more resources than connecting from a remote client...but not much. Do you have any severe limitations on memory or free disk space? Any chance the log files are full?
no I have checked up with it there is ample space on the disk and the memory is also available.Still can't track the problem.harsh |
|
|
|
Kevin Snow
Posting Yak Master
149 Posts |
Posted - 2002-10-25 : 12:05:56
|
| What version and service pak are you on?Have you checked the master and tempdb databases?Have you already stopped and restarted SQL SERVER? |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2002-10-28 : 05:40:54
|
quote:
What version and service pak are you on?Have you checked the master and tempdb databases?Have you already stopped and restarted SQL SERVER?
I am using sqlserver 2000 and when I check it from enterprise manager it shows me: Microsoft SQL Enterprise ManagerMicrosoft CorporationVersion: 8.0I have already stopped and started sql server a couple of times.I have even tried restarting the server.What specifically should I look into master and tempdb databases??thnxs harsh. |
|
|
|
Kevin Snow
Posting Yak Master
149 Posts |
Posted - 2002-10-28 : 10:38:42
|
| Check to see that they are set for unrestricted file growth, or if not, that there is about 20% free space available in the master.Also, check to see what the default database is for the login that Enterprise Manager uses to access the server. If that database is different than the master, then check that databases primary file group for growth restrictions as well. Logging in with a account having a different default database may speed up the connect. If that works, then you will be looking to that database for your EM problem.You ran 500 insert statements....does than mean you inserted 500 records, or was it 500 batches of inserts? If batches, you may have seen a huge growth in the size of indexes attached to the affected tables. Was there a dramatic increse in DB size after the inserts? |
|
|
|
|
|
|
is my server about ot crash???