RE: [ActiveDir] question about optimization?

[Cotter, Paul M.]

ï Have you checked any of the performance stats on the server?  In particular, if CPU, disk I/O and NIC traffic are all within reasonable levels (you'll have to determine what's "reasonable" for you) then I doubt you will gain enough to make the investment in a new server (hardware, migration time/costs etc) worth it.  If those three stats are looking okay, then I doubt there's much "network speed" to be gained this way.  The biggest boost will come, as Roger said, from properly indexed tables and well constructed queries that utilize those indices.   Paul   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Patrick - IT Department Sent: Wednesday, April 28, 2004 1:20 PM To: [EMAIL PROTECTED] Subject: RE: [ActiveDir] question about optimization? 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----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Roger Seielstad Sent: Wednesday, April 28, 2004 2:01 PM To: [EMAIL PROTECTED] Subject: RE: [ActiveDir] question about optimization?   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?     -------------------------------------------------------------- Roger D. Seielstad - MTS MCSE MS-MVP Sr. Systems Administrator Inovis Inc.     From: Patrick - IT Department [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 28, 2004 1:11 PM To: [EMAIL PROTECTED] Subject: RE: [ActiveDir] question about optimization? 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----- From: Brian Desmond [mailto:[EMAIL PROTECTED]On Behalf Of Brian Desmond Sent: Wednesday, April 28, 2004 12:55 PM To: [EMAIL PROTECTED] Subject: RE: [ActiveDir] question about optimization?   Pat-   What sort of issues are you experiencing? How do you define slow data access?   --Brian -----Original Message----- From: Patrick - IT Department [mailto:[EMAIL PROTECTED] Sent: Wed 4/28/2004 10:31 AM To: Active Directory Cc: Subject: [ActiveDir] question about optimization? 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   =========================================================== Important: This electronic mail message and any attached files contain information intended for the exclusive use of the individual or entity to whom it is addressed and may contain information that is proprietary, privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any viewing, copying, disclosure or distribution of this information may be subject to legal restriction or sanction. Please notify the sender, by electronic mail or telephone, of any unintended recipients and delete the original message without making any copies. ===========================================================