RE: [NF] SQL Server - too many databases?

2018-07-18 Thread Dave Crozier
o resell or use the goods in the ordinary course of its business. Until such time as the property in the goods passes to the buyer the seller shall be entitled at any time -Original Message- From: ProFox On Behalf Of M Jarvis Sent: 17 July 2018 16:15 To: profox@leafe.com Subject: R

Re: [NF] SQL Server - too many databases?

2018-07-17 Thread Stephen Russell
Just to mess with their heads I'd tell them to consider putting in 2-3-4 instances to separate databases better going forward. I have 7 on my POR as well as Test servers Across those instances I have over 120 dbs for both Prod and Test. Prod data is just under 2TB now in total. On Tue, Jul 17, 2

RE: [NF] SQL Server - too many databases?

2018-07-17 Thread Paul H. Tarver
If you ever get a confirmed fix on this, please share! Thanks! Paul H. Tarver p...@tpcqpc.com -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of M Jarvis Sent: Tuesday, July 17, 2018 10:15 AM To: profoxt...@leafe.com Subject: Re: [NF] SQL Server

Re: [NF] SQL Server - too many databases?

2018-07-17 Thread M Jarvis
Thanks for the replies fellas... Things have turned into a bit of a circus with that server so I'll pass along the questions and suggestions and let them sort it out. My gut tells me it's a NIC card which I mentioned to them, but they poo-poo'd doing anything about it... Hey if they wanna stay n

Re: [NF] SQL Server - too many databases?

2018-07-15 Thread Wollenhaupt, Christof
> > 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

Re: [NF] SQL Server - too many databases?

2018-07-14 Thread Stephen Russell
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 ac

Re: [NF] SQL Server - too many databases?

2018-07-13 Thread Paul H. Tarver
Depending on the server design it may have multiple network ports built into the motherboard but I’d still recommend putting a high quality network card in the computer to eliminate any problems that might continue on these other ports. Relatively cheap, easy method to eliminate the network port

Re: [NF] SQL Server - too many databases?

2018-07-13 Thread M Jarvis
On Fri, Jul 13, 2018 at 2:44 PM, Paul H. Tarver wrote: > Not sure whether this will apply to you or not, but I recently had a client > running an ERP for hundreds of client databases spread over multiple > servers. We became aware of problem they were having with random timeouts > to > a specific

RE: [NF] SQL Server - too many databases?

2018-07-13 Thread Paul H. Tarver
Not sure whether this will apply to you or not, but I recently had a client running an ERP for hundreds of client databases spread over multiple servers. We became aware of problem they were having with random timeouts to a specific server. Since all our other server connections were working fine (