Roger, That’s being handled by the application developer and yes they are
working on it and it becomes better, I was just asked to get as much speed out
of our network as possible on my side of things. -----Original
Message----- Well,
as Brian Moran (one of the SQL MVP's) often says about 90% or more of SQL
server optimization has to be done at the Application level, not the server
level. Have you done any index optimizations? Query optimizations? -------------------------------------------------------------- From: Patrick - IT
Department [mailto:[EMAIL PROTECTED] B. the complaints come from accessing the databases. We are a
mortgage co. and have a large client and lead database, actually not that large
yet, but it will be in the future. Anyway to pull all the clients up from the
database can take several minutes…I figured adding a server and moving some of
the services to the new server would cut down on the access to the single
server we have now and in turn increase network speed. Does this help? -----Original Message----- Pat- What
sort of issues are you experiencing? How do you define slow data access? --Brian -----Original
Message----- Hi, I am trying to decide how to optimize our current
network to increase data access speed. We have 30 employees and 1 w2k server
handling AD and all other network services, file , data storage and 2 good
sized databases. Would moving the AD and network services to a new server give
me the results I’m looking for? Also we are using a cisco 1721 router. Thanks to all who respond! Patrick |
- [ActiveDir] question about optimization? Patrick - IT Department
- RE: [ActiveDir] question about optimization? Brian Desmond
- RE: [ActiveDir] question about optimizat... Patrick - IT Department
- RE: [ActiveDir] question about optimization? Patrick - IT Department
- RE: [ActiveDir] question about optimization? Roger Seielstad
- RE: [ActiveDir] question about optimization? Cotter, Paul M.
- RE: [ActiveDir] question about optimizat... Patrick - IT Department
- RE: [ActiveDir] question about optimizat... joe