Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

SQL server user access cut down from 8pm - 9am. During this period our SSIS scripts would run to load data(from Oracle/mainframe/Access) to sql, large database(s) & too much data - mortgage information. Data center is at discrete location & users are located throughout US.

Can we do anything to improve this condition. 1. So that SQl users can do their job anytime or at least start 6am - 10pm. 2. Do we need to do load balancing on sql server.

Note: Sql users typically write query for reporting purpose or create SSIS package or use SSRS. Any idea would be appreciated!!

share|improve this question
1  
Load balancing for reads is quite easy. Log shipping, mirroring, etc. Load balancing for writes is a lot more difficult. Can you clarify exactly what types of operations are included in "their job"? –  Aaron Bertrand Dec 13 '12 at 16:03
    
Basic jobs Inserts/update/Delete/Truncate. Is that what you're asking.. –  vitthala Dec 13 '12 at 16:06
5  
Yes. If they are doing write operations there are only a few approaches to scaling out onto multiple machines - two I can think of are merge replication and distributed partitioned views. However before you go too far down the path of "only load balancing can help me" try to focus on the things that your overnight maintenance is doing that make it take so long and be so disruptive - surely the most expensive / long-running processes can be optimized. –  Aaron Bertrand Dec 13 '12 at 16:17
    
How much data are we talking about here? How much is moved on a daily basis that needs to be loaded into the database? –  mrdenny Dec 13 '12 at 22:27
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.