This is sticky that is for sure. How much RAM on the server? Are there multiple instances to combine similar DBs in a group? Is the MAX server ram seeing on box set to default? Is the server pagenating swapping to disk for more ram?
Are there a certain combination of DBs in use with queries across dbs hat have subsets of data in the where clause? What is the backend, local RAID or SAN? What is free space on the log as well as database drives? Is logging turned on all over the place and if it is has it EVER been used in the last 5 years? Is there log shipping on the primary database(s) ? A NIC was already brought up and it could be that as well? Are there multiple NICs if the backend is really a SAN? You may have an issue with the SAN NIC as I did a year+ ago. HTH On Fri, Jul 13, 2018 at 1:26 PM M Jarvis <brewda...@gmail.com> wrote: > 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 > --- > [excessive quoting removed by server] _______________________________________________ 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/cajidmy+z7p_e+kna6s2st+jk4-po6gf-fwu7cehpewe80+w...@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.
