.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

What are Best practice for setting up databases in a distributed load balancing environment

Posted By:      Posted Date: September 26, 2010    Points: 0   Category :WPF


What is the best practice out of the following in a distributed load balancing environment:

keep application database and persistent/tracking database seperate

Keep application , persistence , tracking data all in one database.



View Complete Post

More Related Resource Links

SharePoint 2007 feature deployment in a load balancing environment


I'm looking for information to know how to deploy a Sharepoint 2007 solution (via WSP) in a load balancing environment.  Is it possible to isolate one server at a time.

Daniel Siconnelli There is neither good nor evil... only mogwais and gremlins

Load balancing and Custom Filters in WCF 4.0 Routing Services

Hi, Couild someone please guide me to various ways of achieving load balancing using Router Service. i tried seeing few Blogs and tried to understand the round robin concept and the custom filters conceptr. but i m not able to see any specific site which would guide me on various examples of custom filters .And round robin seems a bit complex. http://blogs.msdn.com/b/routingrules/archive/2010/04/14/load-balancing-at-the-routing-service.aspx The above link gave me some insight  . is there any othe way of achieving load balancing other than Round robin. I did go through the samples of Routing services in WCf training Kit Thanks

Laptop configuration for setting up SharePoint 2010 development environment

guys, i see a lot of new intel processors out there like I5\ I7, my question is which one is good to set up a complete hosting environment while taking it for travels. i would like to have SP 2010\ Sqlserver 2008 in VM environments. Also what kind of RAM?   thanks in advance sameer

Load Balancing/Load Sharing features in SQL Server 2005/2008

Is there any load balancing features in SQL Server? My understanding is that SQL Server Clustering is not a load balancing feature.  Other features seem to be more like load sharing features: Degrees of Parallelism Table Partitioning Resource Governor seems to be more like a resource allocation feature.          

Load balancing using web service

Hi Friends                 Presently we are developing a windows product using dot net, combined with sas (another language). If sas not get installed in local machines then we are in need of using server machine which has sas with it, we are using socket programming to communicate with server machine, Problem is when more number of requests comes to the server for processing sas it is becoming slow, so we need  Load balancing If we go with web service which is having same domain name but different ip address mapped using Domain Name System (DNS) We will get work done faster     What i want is will this work fine, what else i have to done for achieving this, how can i test itWaitingBalaji Manoharan  

Is network load balancing improved for TCP remoting in .Net 2.0 ?


The MSDN TV broadcast for improvements in .Net remoting 2.0 says that the Socket Cache for TCP has been improved to allow for better load balancing.

I cant find any other information about this.

Does this mean that Network Load Balancing is now viable for .Net Remoting 2.0 using the TCP channel ? ( some previous posts say that NLB does not work ideally with older .Net remoting TCP connections )


BCS: Best practice of Toggling external content types between staging and production databases



Environment :
Sharepoint 2010
using BCS to point to external database
create two Secure Store Application ids , one with production credentails and another with staging credentails

I have several external content types (ECT) using an external system(ES) pointing to staging databases.
Now i want to change only one of my ECT to point to production DB but suprisingly the only way i could achieve this was by modifying the ES that all the other ECT are using, this is not practicaly because this makes all the ECTs point to production and not just the one that i want.

Question is how can i have different ES and how can i make only one ECT out of all the ones to point to production, i tried using the "Switch connected systems" but did not like it and below are the details:

Created a new ECT pointing to production which would show the ES being used in BCD services and then i  used the "Switch Connected Ssytems" option under designer to switch the staging ECT to the production ES. Dos the job but the problem is that if there are no ECT pointing to staging ES then it does not appear under BCS services which mean neither can i switch my ECT back to it nor would it be available when i am creating new ECT whch need to point to staging.

Hope i was clear, please suggest how to handle this sit

Popup window config setting not functioning in CRM environment inside IFRAME?


Hi friends,

I used the Javascript command to open a configured window with the following attirbutes and it works well on my HTML page but strangely when I copy the same command into MS CRM a aspx application inside an IFRAME it open the window but without any config with some standard height menubar and everything.

window.open('http://www.google.de', 'help', 'width=320,height=210,scrollbars=yes')

Thanking you in advance,



ETL in distributed environment (Scale out architecture)



Currently I'm using SSIS packages, C#,Powershell, BulkInserts technique for ETL and I’ve one database with different schemas.
for example core.table1, core.table2, trans.table1, trans.table2 in SQL-2008.

I would like to create 3 different SQL physical nodes for load balancing, performance and to handle large scale of data.

Two simple questions:
1) create same table structure in all 3 node, and load data parallel,
 for example if I’m receiving 1000 records- distribute 1000 records in 3 nodes (300 + 300 + 400),
 To retrieve the data I should have same algorithms, three separate thread process parallels and get me the result form 3 nodes.

2) Create one schema on one node, another in second node and dump the data accordingly.
       for example all core. tables are under node1, trans. tables are under node2 and so on..

please let me know the pros & cons of above approaches?

Is that Store procedure adviseable in distributed SQL environmnet?
I feel LINQ-SQL is more convineant as application get the data by using DBML Schema? Please advise


Which would be preferable approch on ETL,
1) Extract > Transform > Load
2) Extract > Load (Flat file Load) > Trnasform > Load

 I'm conf

setting dropdownlist item in page load


 I can't get the following to set on page load.  I want the month selected be the current month, on page load.  What needs to change here?

DropDownListCCExpMo.SelectedItem.Selected = Date.Today.Month


Need Help Setting Up Developer Environment


If your environment looked like the following how would you set up your developers with VS2010?

Our SharePoint development server farm has two VMWare VMs with a separate SQL server on SQL 2008 R2. We've currently got 6GB of RAM and a total of 40 GB of disk space on the WFE. We will be utilizing RBS on the SQL server as well - data will go out to SAN storage.

We have requirements for building dashboard solutions using BCS and tying into other SQL or Oracle-based applications, creating complex workflows and maintaining consistency across the farm. We are moving to Windows 7 for all of our users - some of our developers have migrated and some have not. There is an existing unwaiverable policy that no desktop can have IIS enabled. We've got source code configuration control software available. None of our developers currently have MSDN licenses - they have stand-alone VS licenses.
Given all that, how would you set things up to give the developers the assets they need to do the development working within policy constraints and keeping the cost manageable?


Load Balancing WSS WFEs (2007)

I have a CentralAdminServer which hosts an application, which users use and can navigate to at http://server/site.  I added an application server to the farm to support the application; users cannot browse to this because it is purely an application server.  I want to add a WFE on http://server2 so that users can browse to the application as http://server2/site.  Instead of using AAM, I want to use a load balancer.

If I add a WFE to this configuration (as stated previously), can I simply add http://server/site and http://server2/site to the load balancer?  And then add the Load Balanced URL to the application settings in central admin?

I shouldnt have to set AAM, right?  The load balancer will determine where the requests go and then the application will determine which app server to use, correct?


Setting up a hardware load balancer between WFEs and App servers in SharePoint 2010


I am looking for any information I can find about setting up a hardware load balancer between WFEs and App servers in SharePoint 2010.

While the load balancing procedure is simple for WFEs since you just set up DNS to point to network load balancer (NLB) and NLB can be configured to load balance between the WFEs, NLB in this case is sitting outside the farm. How will you insert NLB inside the farm?

I know Application Servers can load balance on their own (WFEs can direct traffic to multiple App Servers) but I want to configure a hardware load balancer nonetheless. I have seen architecture diagrams on TechNet which show NLBs between App and WFEs but no guidance on how it will be configured. Since the app servers will be registered as part of the farm (Configuration DB), how do I tell WFEs to direct traffic to NLB rather than to the App servers directly.


Load balancing on SQL 2005 Standard ?


SQL 2005 Standard.

Hi I would like to find the best approach to load balancing some SQL 2005 Servers taking in mind also the future scaling out of tens or hundreds servers.

I found this article: http://goo.gl/zP1R that writes about P2P replication, Table partitioning and Database mirroring but:

- P2P replication is limited to 12 servers
- table partitioning is not related to our case
- From what I know Database mirroring is only a high-availability solution, isn't it ?

What do you think ? Which is the best solution ?

Is SQL 2008 better in this area ? Could I upgrade to better meet these points ?


WCF Service configuration in Web Farm and Load Balancing envrionment.


I want to configure ASP.NET Website Project using WCF Service[NetTcp] (both in c#) for web-farm (for website) and NLB Load balancing (for service). I would like to configure following options for same.

NetTcpBinding.maxConcurrentCalls, NetTcpBinding.ListenBacklog and NetTcpBinding.MaxConnections

Note: During single machine configuration when I changed value of NetTcpBinding.ListenBacklog and NetTcpBinding.MaxConnections in WCF Service project to more that 10, which is default value. I got exception. When I changed this value in Website it was working fine. Due to this I had to keep in default configuration. Not sure why this is the case. If anyone could explain this it would be helpful.

Following reference gives idea how to configure in given environment but does not tell how to go about it.

Ref: http://msdn.microsoft.com/en-us/library/ee377061%28BTS.10%29.aspx

Let me simplify a bit. Lets say I have following configuration.

  • 2 IIS servers in Web Farm.
  • 3 WCF Service Servers (NetTcp) in NLB
  • Default config. for single instance.
    • NetTcpBinding.ListenBacklog: 10
    • NetTcpBinding.MaxConnections: 10
    • NetTcpBinding.maxConcurrentCalls: 16

I need complete tutorial about MSSQL 2008 Database mirroring for load balancing


I need complete tutorial about MSSQL 2008 Database mirroring for load balancing

i want to load balance my SQL workload

all database insert update and delete queries will be mirrored

all select queries will be load balanced

sql servers will run at windows server 2008r2 at different computers (VPS)

Browser based Pokemon MMORPG Pokemon Craft Developer Used asp.net 4.0 routing at it's Pokedex

Distributed applications with databases communicating with each other, is this possible?


I have a web application which has a resource hungry module. I am planning to take the module out as a separate application.

Main Application (with database A, on host A) will connect to Module B (with database B, on host B) . With data sent from Application, Module will read Database B and start working. When data has been processed, it will be returned to database A.

Is this even possible? If yes, what is the best way to do this? Set Module B as a web service?


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend