We are running into an intermittent issue w/ our SQL Server running

SQL2016. It's not that our tables are all that large (usually), but our

server is trying to manage around 550 different DB's parked on it. Few of

the DB's are open at any one time, but the server has to keep track of them

at least to some extent.

When the problem arises our dev team runs into timeouts and sometimes the

problem goes away, some time it doesn't and our IT guys out of desperation

restarts the machine.

One of our devs suggested that even though we aren't past some theoretical

limit on the number of DB's the server can manage, maybe we just have too

many and getting rid of most, or at least detaching them, might help.

Any thoughts on this?

--

Matt Jarvis

Eugene, Oregon USA

--- StripMime Report -- processed MIME parts ---

multipart/alternative

text/plain (text body -- kept)

text/html

---

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/CAPT54rZg5wagf4Q1d+=Q_TSu8zmk3AodR3rfrNSo0qaWZ4U1Yw@mail.gmail.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.