
By using local storage you not only eliminate the cost and complexity of a SAN, you also ensure fast, efficient SQL response times.
SAN MATEO, CALIF.--Last month a company called SIOS Technology Corp. conducted a survey of large data centers to understand current trends and challenges related to providing high availability (HA) and disaster recovery (DR) for Microsofts SQL Server (a commonly used database for large amounts of data). The company hosting the survey said it has developed a better (more cost-effective) way of managing these two critical elements of data center and large file-based production operations.
Jerry Melnick, Chief Operating Officer at San Mateo, Calif.-based SIOS Technology Corp., said protecting SQL Server from downtime and disasters is essential.
For most survey respondents, controlling costs was the most significant challenge. The rising cost of Microsoft SQL licensing was next (17 percent), followed by vendor lock in (14 percent) and the cost of SAN storage (13 percent).
Jerry Melnick, Chief Operating Officer at San Mateo, Calif.-based SIOS Technology Corp., said video editing software also relies on powerful databases, such as SQL Server software, to store, find, retrieve, and manage video clips from their archives. For broadcasters, video production business, and other video-related businesses, protecting SQL Server from downtime and disasters is essential. However, the traditional way to provide high availability protection is with a shared-storage failover cluster, a potentially costly and complex process that can sometime slow performance. So, do you run your editing software without protecting SQL so end users have fast access to their video? Melnick said that means putting your systems at risk of complete downtime and significant data loss.
Most large data centers protect important SQL databases using clustering software. In a traditional cluster, the primary application server (where SQL is operated) is paired with a standby server in a cluster configuration. Both servers have access to the same data located on a shared storage device using a Shared Storage Area Network (SAN). If there is a failure on the primary server, clustering software moves the application (SQL) operation to the standby server. In a Windows environment, Windows Server Failover Clustering software is typically used. Since the standby server is using the same shared storage as the primary server, SQL operation can continue without data loss.
While traditional clusters protect SQL from downtime, the shared storage SAN required in these clusters is often expensive and complex to deploy. They can also slow SQL response times, making them impractical for video editing and production systems.
Melnick said that SIOS has developed an easier and more cost-efficient way to protect the SQL Server databases when deploying a Microsoft Windows Server Failover Clustering (WSFC) architecture. Its called SIOS DataKeeper Cluster Edition SANLess clustering software. The SIOS solution, he explained, allows you to use low cost, high speed server-side, local storage and eliminate the expensive SAN storage.
Melnick said the software uses real time, block-level replication to synchronize the local storage on the primary and standby servers, making it appear to the WSFC software as identical to a SAN.
If you are building a two-node cluster, he said, the companys DataKeeper software can save money on SQL licensing costs because you dont have to buy the more expensive SQL Server Enterprise Edition database typically required in SAN environments. Youre still getting the high availability of files required and, with the SIOS software, you have greater flexibility in configuring servers for HA and DR applications. At the end of the day, Melnick said media companies could save significant costs (tens of thousands of dollars) by adding the DataKeeper softwares HA and DR features to their SQL Server Standard Edition deployments.
SANLess clusters (B) use real time, host-based replication to synchronize local storage on the primary and standby servers, making them appear to Windows Server Failover Clustering as a traditional cluster.
By using local storage you not only eliminate the cost and complexity of a SAN, you also ensure fast, efficient SQL response times, he said. Unlike traditional clusters, SANLess clusters also allow you to use high performance SSD storage to ensure fast SQL performance and speed the process of finding and accessing the video information.
Shared storage presents its own set of costs and challenges, Melnick said, and the companys survey reflected that. According to our survey results, SANs are costly to administer. More than half (55 percent) spends more than $80,000 per year on SAN administration, including 15 percent who spend more than $250,000 per year.
More than half of respondents to the SIOS survey were from large enterprises with more than 1,000 employee (51 percent) and most were headquartered in the United States (76 percent); with 9 percent from EU countries. The survey pool represented a broad range of industries, including telecommunications (31 percent), healthcare (16 percent), and financial services (15 percent). Most had also purchased SQL Server Enterprise Edition licenses in the past two years.
Keeping operations running smoothly is the key to any data canter or video production and/or playout facility. Thats probably why most companies (68 percent) talking the SIOS survey said they purchased Microsofts SQL Server Enterprise Edition software instead of the cheaper SQL Server Standard Edition just to get the HA and DR features that are not included in the Standard Edition package. The Standard Edition does offer a Database Mirroring Mode (used for HA and DR), but some (7 percent) respondents found it too labor intensive to use.
Most recent headlines
06/10/2025
France T l visions, France's leading broadcaster, has received the 2025 EBU ...
04/09/2025
Monumental Sports & Entertainment (MSE), in collaboration with Dalet, has been a...
04/07/2025
By Lucy Spicer
Editor's note: We are deeply saddened by the passing of Robe...
04/07/2025
The Summer Reading Challenge has inspired children across the U.K. to embrace a ...
04/07/2025
Introducing CVP Auctions: Trusted Tech, At Auction-Only Prices
Brie Clayton July 4, 2025
0 Comments
A New Destination for Film and Broadcast Gear at U...
04/07/2025
Unveiling China's Ecological Wonders with URSA Mini Pro 12K
Brie Clayton July 4, 2025
0 Comments
Nature Documentaries Freeze Epic Momentsin Extrem...
04/07/2025
Create Any Planet in After Effects
Graham Quince July 4, 2025
0 Comments
The Advanced 3D renderer in After Effects makes it really easy to import 3D o...
04/07/2025
Custom Gradient Colorize for Resolve Fusion
Simon Ubsdell July 4, 2025
0 Comments
Digging into the theory of the gradient colorize process to build ou...
04/07/2025
Watching live sports on TV these days is a delicate balance for broadcasters how much information is too much?...
04/07/2025
WASHINGTON As Federal Communications Commission Chair Brendan Carr works to achieve his goal of a very busy, productive summer at the FCC, the agency has rele...
04/07/2025
Other World Computing Launches OWC Guardian USB-C Hardware-Encrypted Portable SS...
04/07/2025
CANAL Brings MotoGP to Vision Pro with Blackmagic URSA Cine Immersive
Brie Clayton July 3, 2025
0 Comments
Experience MotoGP like never before as CA...
04/07/2025
Friday 4 July 2025
Watch the trailer here https://youtu.be/Od5WpvWmDr8
Further...
04/07/2025
The Pitch comes to RT Radio 1 airwaves this Sunday at 7pm. The Pitch is a brand...
03/07/2025
For our Vario-Jib, as well as for a repertoire of weights, we now have carts that make transport easier...
03/07/2025
One of our latest innovations: Slider Drive Unit!
Our Vario Slider not only comes with improvements and new features, but also with its own drive unit!
Our i...
03/07/2025
The 360 EVO lives up to its name: 360-degree rotation not only on the pan axis, but also on the roll axis, enables filmmakers to take their creative visions eve...
03/07/2025
What a buzzing few days at BSCExpo in London!
We were thrilled to connect with so many talented professionals from the world of cinematography.
A huge thank ...
03/07/2025
ADOLESCENCE - Shot with Panther Tower"The whole rig had to be detachable mid-episode
Netflix limited drama series Adolescence has been gaining attentio...
03/07/2025
To achieve a true level of decisive overmatch, communication systems must be as ...
03/07/2025
The Broadcasters Foundation of America has named Ray Hopkins, president of U.S. distribution at Paramount Global, to its board of directors....
03/07/2025
SIOUX FALLS, S.D. In his first major policy speech, Federal Communications Commission chair Brendan Carr outlined his Build America Agenda for the agency'...
03/07/2025
As the industry is making a major push to transition to NextGen TV and develop new businesses that will fund the next generation of broadcasting, TV Tech's ...
03/07/2025
Despite enabling its subscribers to watch films and TV shows in the highest possible resolution, Netflix has revealed it is taking things old school with the in...
03/07/2025
WASHINGTON In response to news that Paramount Global has agreed to pay $16 million to settle a lawsuit by President Donald Trump, Democrats and other administra...
03/07/2025
WUPPERTAL, Germany Riedel Communications today launched RefSuite for professional sports workflows....
03/07/2025
WEITERSTADT, Germany LYNX Technik, a provider of modular signal processing solutions, has announced that founder and longtime CEO Winfried Deckelmann is steppin...
03/07/2025
WASHINGTON Representatives from six trade groups representing tech, pay TV, broadband, LPTV and other sectors recently met with Federal Communications Commissio...
03/07/2025
PLYMOUTH, Wis. Dan Whealy has acquired Heartland Video Systems and will be its new owner and president, the systems integrator said....
03/07/2025
Acclaimed filmmaker, educator, and industry veteran Jay Holben has released his most ambitious work to date: The Director's Guide to Everything a sweeping...
03/07/2025
For Los Angeles-based photographer Scout Pruski, documenting the annual Dyke Day LA is a way to honor and give back to the city's legacy queer community and...
03/07/2025
Modular, Travel-Ready Solution Matthews Studio Equipment launches the new Chimera V-Flat Panel Frame Kit, the lightweight and modular, ultra-durable alternativ...
03/07/2025
Dalet, a leading technology and service provider for media-rich organizations, today announced the release of Dalet Flex 2025.6 LTS (long-term support), introdu...
03/07/2025
Lightware's LARA Wizard makes it quicker and easier than ever to set up audio-visual (AV) room automation and control configurations, ensuring anyone, from ...
03/07/2025
Alfalite, the only European manufacturer of LED screens, has obtained both the NCAGE Code (NATO Commercial and Government Entity) and TAA (Trade Agreements Act)...
03/07/2025
nxtedition is implementing a new solution for WIN Network, based in its headquarters in Wollongong, New South Wales, Australia. The nxtedition integrated platfo...
03/07/2025
ORS Group and Insys Video Technologies today announce the launch of a new joint brand identity: Big Blue Marble. The move reflects the evolution of a long-stand...
03/07/2025
Evergent, a global leader in customer lifecycle management and monetization solutions for subscription-based businesses, today announced the successful results ...
03/07/2025
LYNX Technik, provider of modular signal processing solutions today announces an executive leadership transition, effective July 1, 2025. Markus Motzko has been...
03/07/2025
Chaos Releases V-Ray for Blender
Brie Clayton July 2, 2025
0 Comments
Production-Proven Renderer V-Ray Arrives Natively in Blender for the First Time;...
03/07/2025
Calvin University Adds Blackmagic Replay to Broadcasts and Streams
Brie Clayton July 2, 2025
0 Comments
Replay workflow joins 14 Blackmagic Design cam...
03/07/2025
Berklee's Gospel Performance Program Welcomes Jonathan Nelson as the Herb Al...
03/07/2025
Back to All News
Get Ready for Even More Action! Netflix Has Confirmed the Thir...
03/07/2025
Back to All News
Get ready for even more action! Netflix has confirmed the thir...
03/07/2025
In today's fragmented media landscape, advertisers expect more than just reach - they want seamless cross-platform campaigns that deliver measurable results...
03/07/2025
** MEDIA ALERT ** Shonen Jump Store Hosting Los Angeles Pop-up During Anime Exp...
03/07/2025
Thursday 3 July 2025
David Harewood and Matthew Broome in Mozart: Genius for Hi...
03/07/2025
The Sky WNT Fund supports Womens National Team players with a 30,000 bursaryThursday 3 July 2025
Sky Ireland has announced the four recipients of the 2025 Sky...
03/07/2025
The forecast this month is showing a 100% chance of epic gaming. Catch the scorching lineup of 20 titles coming to the cloud, which gamers can play whether indo...
02/07/2025
Hege Wik and Odin appear in FOLKTALES by Heidi Ewing and Rachel Grady, an official selection of the 2025 Sundance Film Festival. Courtesy of Sundance Institut...