SQL Server Reporting Services Scale out Configuration


One of the major benefits that SQL Server provides is the scaling out the SQL Server Reporting Services. SQL Server Reporting Services are used as concept of hosting reports which various business processes requires. SQL Server Reporting Services does an efficient job in hosting all the reports. But the problem comes when the load starts increasing in terms of number of users accessing the reports. This may result in:
1.       Slow processing of SQL Server Reports
2.       Crashing of SQL Server Reports Server
In order to overcome the above issue, SQL Server Reporting Services can be overcome through the concept of scalability. This is implemented with the help of network load balancing (NLB) and Domain Implementation.
The following figure gives a clear cut picture of how to achieve the same:


In the above example, there are there servers in the NLB serving the clients through a Virtual NLB IP i.e. 192.168.1.25. The client only knows the Virtual IP, he/she does not knows the actual NLB setup. So the client sends the request of the report to the Virtual IP. Every server in the NLB is hosting the instance of the Reporting Services component for which the Report Catalog is hosted on 192.168.1.27 and actual database is hosted on the server 192.168.1.26. The above setup helps in dividing the control of report generation in 3 servers serving in the NLB. So if the number of users increase on the report server, then the 3 servers will divide the load and serve the request efficiently.
The above setup is still scalable. We can add more servers in the NLB as and when the load increases.

Comments

Post a Comment

Popular posts from this blog

Image
Capricornian Lucky Connections Colour: brown, green, black, gray, indigo Plants: yew, ash, hemp, weeping willow Perfume: musk Starstone: black onyx Metal: lead Tarot Card: the devil Animals: goat, donkey Ruling Planet: Saturn Lucky Numbers: 6, 8 and 9 black onyx Emerald ~ Panna Blue Sapphire ~ Neelam Pearl ~ Moti Blue Lapiz Lazuli
Read more

Now, send free SMS through Gmail chat

Now, send free SMS through Gmail chat It is finally here. The free SMS service right from your Gmail chat window.  Almost a year after the service was introduced in the United States and many other countries, the service has now been made available to Indian users. You could now send a text message to most mobile operators across the country from the comfort of your computer, although there is a prominent exception, at least for users in Bangalore. The Gmail Free SMS service is available for connection to mobile phones with SIMs of many operators, including BSNL, Aircel, Idea, Loop Mobile, MTS, Reliance, Tata DoCoMo, Tata Indicom and Vodafone. However, repeated test messages to Airtel mobiles failed to get the SMSes delivered. Once you send an SMS from the chat window to a mobile phone other than Airtel’s, you wait for a response. The replies will appear as regular chat replies  and conversations will also be stored in your chat history. The new feature was rolled out t...
Read more

CPA Gateway Company Leadbolt Why You Should Use Them

When searching for a CPA company often times you will have a hard time figuring out who to use as many companies sound promising but usually come short on what they promise. Many CPA companies fail to meet payments on schedule, cheat you out of legitimate conversions, or ban your account before you receive payments. Leadbolt isn’t one of those companies that you hear about from other Internet marketers as they are real company founded in the United States with a strong track record among the industry. Leadbolt is defined as a CPA Gateway company like CPA lead. When you visit a website with Leadbolt’s code installed into the website, a blocker will pop up and before they can enter the website they must fill out a survey from a number of advertisers. Once the survey has been filled out you will be paid a commission and the person will be able to enter the website. To incentivize people to fill out surveys to enter the website you can offer downloads, coupons, or adult content etc. Ra...
Read more