Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I deal with an application which runs on network clients, and opens many database files from a network share. This is a flat-file-type database, as opposed to SQL Server or whatever.

We have a couple of Windows Small Business Server 2003 sites who get thrown out of this application quite regularly, due to actual or perceived temporary network disconnections.

On both sites I have heard mutterings from the companies that handle their hardware support about SBS 2003 doing this if it gets busy enough or low enough on memory. Certainly on one site they are running at about 6% free RAM on the server due to SQL Server 2005 inhaling it all.

Could this be the case ?

share|improve this question

2 Answers 2

It's (always) worth limiting the amount of RAM that the SQL instances of WSUS and Monitoring on SBS 2003 can use. (Default is a couple of GB for each!)

From a command prompt:

osql -E -S ServerName\WSUS

Replace 'Servername' with name of your server.

Then enter each line below separately.

sp_configure 'show advanced options',1
reconfigure with override
go    
sp_configure 'max server memory',128
reconfigure with override
go

Repeat above using Servername\Monitoring

share|improve this answer

Yes, this could be the case - I experienced this in my network. You have to check logfiles to be sure. Tons of RAM are always welcome on busy servers.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.