Your cluster is presently in an Active/Passive config, which great for high availability but does nothing for end-user performance.
You would need to go Active/Active if you are looking to load balance and provide a performance increase. Before you do that - you may want to look into your storage configurations to make sure your SQL storage (DB, Log, TempDB, etc) is optimized. Jim Jim Holmgren Manager of Server Engineering XLHealth Corporation The Warehouse at Camden Yards 351 West Camden Street, Suite 100 Baltimore, MD 21201 410.625.2200 (main) 443.524.8573 (direct) 443-506.2400 (cell) www.xlhealth.com From: Cameron Cooper [mailto:[email protected]] Sent: Wednesday, July 07, 2010 1:27 PM To: NT System Admin Issues Subject: RE: Network Share unshares This should probably be another topic (hacking my own)... Currently we have the two clustered with one as the active node and the other as the inactive, is there a way that we can setup the two to load balance the database? _____________________________ Cameron Cooper Network Administrator | CompTIA A+ Certified Aurico Reports, Inc Phone: 847-890-4021 | Fax: 847-255-1896 [email protected] | www.aurico.com From: Richard Stovall [mailto:[email protected]] Sent: Wednesday, July 07, 2010 12:17 PM To: NT System Admin Issues Subject: RE: Network Share unshares You're welcome. It should bounce over to the inactive node just like SQL and any other configured resources. From: Cameron Cooper [mailto:[email protected]] Sent: Wednesday, July 07, 2010 1:15 PM To: NT System Admin Issues Subject: RE: Network Share unshares Thank you sir. Setup the resource and will see what happens when the server is restarted tonight. _____________________________ Cameron Cooper Network Administrator | CompTIA A+ Certified Aurico Reports, Inc Phone: 847-890-4021 | Fax: 847-255-1896 [email protected] | www.aurico.com From: Richard Stovall [mailto:[email protected]] Sent: Wednesday, July 07, 2010 11:55 AM To: NT System Admin Issues Subject: Re: Network Share unshares You have to make the share a clustered resource. Just create it in the cluster admin tool. On Wed, Jul 7, 2010 at 12:54 PM, Cameron Cooper <[email protected]> wrote: We have two SQL Servers clustered into a Dell MD3000 and have a folder that is shared. When either of the clustered servers restarts the share is gone. Any ideas on how to resolve this? _____________________________ Cameron Cooper Network Administrator | CompTIA A+ Certified Aurico Reports, Inc Phone: 847-890-4021 | Fax: 847-255-1896 [email protected] | www.aurico.com CONFIDENTIALITY NOTICE: This email, including attachments, is for the sole use of the intended recipient(s) and may contain confidential and/or protected health information. Under the Federal Law (HIPAA), the intended recipient is obligated to keep this information secure and confidential. Any disclosure to third parties without authorization from the member of as permitted by law is prohibited and punishable under Federal Law. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. NOTA DE CONFIDENCIALIDAD: Este facsímile, incluyendo lo adjunto, es para el uso exclusivo del destinatario(s) y puede contener información confidencial y/o información protegida de salud. En virtud de la Ley Federal (HIPAA), el destinatario tiene la obligación de mantener esta información segura y confidencial. Cualquier divulgación a terceros sin la autorización de los miembros de lo permitido por la ley está prohibido y penado en virtud de la Ley Federal. Si usted no es el destinatario, por favor, póngase en contacto con el remitente por teléfono y destruir todas las copias del mensaje original ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
