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 |
|
Rita Bhatnagar
Posting Yak Master
172 Posts |
 Posted - 2001-12-28 : 13:02:40
|
| We have sql 2k. We have 20 databases on it.It was working great.What happened is that some programmers can't see databases in enterprise managaer.It shows no item.When we refresh it we can see it but it's very slow.I checked @@connections and it is 120782.I don't know how did we are having so many connections.What should i do to solve this problem.Thanks for any suggestion.Rita |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2001-12-29 : 00:33:33
|
| Might be lot of users have left their connection's open. just recheck the application s/w you are using whether it is closing the connection's it is using.the most simple soulutin is restarting your server though not feasible most of the time.Check the Client's machines , check if they are using Query Analyzer .suggest them to use a simple window and work , coz the no. of new windows it in, the no. of connections the server consumes. so , whenever u click on new query in Query Analyzer it add's a new connection on your server.HTH-------------------------Graz's Baby is my Master:) |
 |
|
|
|
|
|
some programmers can't see databasenamee