| Author |
Topic |
|
paulo.oliveira
Starting Member
5 Posts |
 Posted - 2008-09-26 : 13:49:44
|
| Hi,my current SQL Server processor has a heavy utilization. We have another SQL server with little use.We want to set up a NLB for these two servers.My question is what should I do to configure my SQL servers for load balance?Does they have to have the data base replication between each other?What are the requirements?Thanks for any help!I´m totally new to SQL server.Regards,Paulo Oliveira. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-26 : 14:02:07
|
| You can use Partition-Views for Load Balancing in SQL 2000. |
 |
|
|
paulo.oliveira
Starting Member
5 Posts |
Posted - 2008-09-29 : 11:48:10
|
| Hi,is this a free software? Where Can I find it?Is there any how to for make this configuration?Sorry for this bunch of questions, it is because I´m SQL newbie and a need to setup this NLB for these two servers.Regards,Paulo Oliveira. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-09-29 : 12:27:06
|
| You cannot do this without significant changes to your database and application. If you are new to SQL Server, forget about doing this.You would be better off spending the money to purchase a more powerful server with more memory, faster CPUs, faster disks, etc.CODO ERGO SUM |
|
|
|
paulo.oliveira
Starting Member
5 Posts |
Posted - 2008-09-29 : 13:32:58
|
| Hi,thanks for your reply. Very interesting point of view. :)Regards,Paulo Oliveira. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-09-29 : 13:43:05
|
| Michael is right. Implementing partitioned views isn't something that a newbie can or should do. Is there money in the budget to hire a consultant to help you out with this or is there anyone there with more experience that can take this on?How did you decide that you need to load balance? Are you sure that you don't have a design issue, hardware bottlenecks, missing indexes, fragmented indexes, out-of-date statistics or other things that can be fixed? What kind of performance analysis have you done to come to the conclusion that you need to load balance?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
paulo.oliveira
Starting Member
5 Posts |
Posted - 2008-09-29 : 15:14:39
|
| Hi Tara,you´re right, there´s a development team helping me up.The tools I used to monitor the server performance was Performance Monitor and Task Manager (both Windows integrated).One of hardware´s machine configuration is two dual-core processors and 4 GB memory.The other is two dual-core processors and 2 GB memory.We decide to load balance, because the % CPU utilization was too high (40-80). And we have a second server currently doing almost nothing (I mean no heavy processing).Is there any article/tutorial about this?Regards,Paulo Oliveira. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-09-29 : 15:45:44
|
quote:
Originally posted by tkizer...Implementing partitioned views isn't something that a newbie can or should do...
I really should have said that it isn't something anyone should do. I don't believe that I have ever heard of an actual production applicaiton that is using federated servers with partitioned views.As Tara mentioned you should spend time tuning the application first. That is ususlly the easiest way to improve database performance, and will not be wasted even if you later upgrade the hardware.CODO ERGO SUM |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-09-29 : 16:30:29
|
| I read an article about MySpace, but didn't see anything about that. I thought that they had one central DB for for logins and a pointer to the actual Server and DB where the users info was stored, and then connected to that database to get the users site info.Edit:Found the article I was looking at:http://www.baselinemag.com/c/a/Projects-Networks-and-Storage/Inside-MySpacecom/3/"There is still a single database that contains the user name and password credentials for all users. As members log in, the Web site directs them to the database server containing the rest of the data for their account. But even though it must support a massive user table, the load on the log-in database is more manageable because it is dedicated to that function alone."CODO ERGO SUM |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-09-29 : 16:55:00
|
| Perhaps they changed their architecture, but the last article I read showed SQL Server 2005 in use with partitioned views across many servers. You would connect to a central database though with partitioned views as that's where the view would be.We'll be implementing partitioned views in the next couple of months for a system that is going to have a ton of data in just a few tables. We won't federate it until we exhaust the hardware.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
paulo.oliveira
Starting Member
5 Posts |
Posted - 2008-09-29 : 18:13:06
|
| Hi,thanks all for really helpfull information and considerations about this subject.Really appreciated.Regards,Paulo Oliveira. |
|
|
|
|
NLB SQL 2000