Home Cloud Computing Hitting the limits of your SQL Server: Time to scale out?

Hitting the limits of your SQL Server: Time to scale out?

0
Hitting the limits of your SQL Server: Time to scale out?
0

When complaints about slow systems reach a fever pitch, there’s no ignoring them. You’ve exhausted all the hardware options at your disposal. Maybe now is the time to scale out your SQL Server. It’s a trendy thing these days, isn’t it? Just like they’re doing in the cloud.

In theory, scaling out seems easy enough, and has definitely worked well with web servers. A little help from load balancers to direct traffic and you’re all set. Or maybe not. Don’t make the mistake of underestimating the level of effort and expertise necessary to partition databases (1) from one machine to two. Check out these articles from a variety of creditable sources and you’ll see what I mean.

There are a lot of considerations before you scale SQL Server. Should you shard (2) the database horizontally using ranges of rows — only to find that you’ve aggravated the hot spots? Or maybe you should split it vertically. Whichever you choose, some significant upfront testing and modeling must precede these decisions. This is when the hard work truly begins.

Read the entire article here, Hitting the limits of your SQL Server: Time to scale out?

Via the fine folks at DataCore Software/a>.

Categories:
DataCore DataCore is the authority on real-time data. The company pioneered software-defined storage and is now bringing its technology to hyperconverged and workload optimization. DataCore empowers IT organizations to achieve always-available, high-performance and highly efficient data. Its patented technology eliminates storage bottlenecks with adaptive parallel I/O optimization, enables zero-downtime synchronous mirroring, and provides a true hardware-agnostic architecture — resulting in flexibility, resource efficiencies, and cost savings. DataCore software is the cornerstone of the next-generation, software-defined data center. DataCore’s value has been proven in more than 10,000 customer deployments across traditional, hyper-converged, cloud, and hybrid environments.

Featured Resources:

Related Articles:

| LATEST FEATURED RESOURCES

White Papers

    Application Lifecycle Management with Stratusphere UX – White Paper

    Enterprises today are faced with many challenges, and among those at the top of the list is the struggle surrounding the design, deployment, management and operations that support desktop applications. The demand for applications is increasing at an exponential rate, and organizations are being forced to consider platforms beyond physical, virtual and cloud-based environments. Users […]

    Downloads

      Download Commvault VM Backup and Recovery: end-to-end VM backup, recovery and cloud management

      Commvault’s ability to provide end-to-end VM backup, recovery and cloud management creates a significantly better way to build, protect and optimize VMs throughout their lifecycle. Our best-in-class software for VM backup, recovery and cloud management delivers a number of significant benefits, including: VM recovery with live recovery options; backup to and in the cloud; custom-fit […]

      On-Demand Webinars

        What’s Going on in EUC Printing – A Technical Deep Dive!

        The IGEL Community and ThinPrint invite you to watch the following technical deep dive webinar. The agenda is to technically bring you up to speed on what’s going on in the EUC Printing space today along with a deep dive into new methods, technologies, printing scenarios and a discussion on why printing still matters. You […]

        Latest Videos

          Views All IT News on DABCC.com
          Views All IT Videos on DABCC.com
          Win big $$, visit ITBaller.com for more info!

          Visit Our Sponsors

          Close