How do you tweek a network for dbs?

[MarkGibson]

In thread181-31163, one repondent suggests that often networks can be tweeked to make it better for databases (rather than being optimized for email and file transfers). Can someone tell me how to do this, and whether this can be done with Windows ME? (Our Access backend is being served (for the moment) by a Windows ME workstation, and we are getting intermittent slowdowns in the db, even when no-one is on the network and we are not connected to the internet).

Thanks a lot!

Mark

 

[tlbroadbent]

I'm no expert in network configuration but you will never get good performance using Win ME as the file server. It was not created to handle file server work. Put your backend databases on a real file server running a Server OS. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.