Product has been added to your cart.

kCura Relativity

sp_AllNightLog: Creating Jobs Like I’m The President

Erik Darling
Backup and Recovery, Clients and Case Studies, ISV and SaaS Database Design, kCura Relativity, Log Shipping, SQL Server
0
Look, we need these things The setup for sp_AllNightLog creates jobs for four separate activities 1 job to poll for new databases to back up (primary) 1 job to poll for new databases to restore (secondary) 10 jobs to poll for backups to take (primary) 10 jobs to poll for restores to… whatever (secondary) And,…
Read More

sp_AllNightLog: Poll Vaulting

Erik Darling
Backup and Recovery, Clients and Case Studies, ISV and SaaS Database Design, kCura Relativity, Log Shipping, SQL Server
11 Comments
Carry on It turns out that the only thing harder than checking for new databases restored to a SQL Server, is checking a folder for a backup of a database that doesn’t exist on another SQL Server. These are both part of what sp_AllNightLog has to do. The other components, which use workers and a…
Read More

sp_AllNightLog: ¿Por que los queues?

Erik Darling
Backup and Recovery, Clients and Case Studies, ISV and SaaS Database Design, kCura Relativity, Ola Hallengren's Database Maintenance Scripts
16 Comments
Building stuff I sometimes really hate coming up with ideas, and much prefer someone to just say “I want this” so I can go out into the world and figure out how to do that. Occasionally though, I realize that I’m not going to get all that much direction. That’s what happened with sp_BlitzQueryStore. It…
Read More
Erik Darling blogs kCura Relativity

Introducing sp_AllNightLog: Log Shipping at Scale, Open Source

Brent Ozar
Backup and Recovery, First Responder Kit, kCura Relativity
9 Comments
In our Faux PaaS project, we need a backup plan – or rather, a restore plan. On each SQL Server instance, clients can create as many databases as they want, anytime they want, with no human intervention. We need those databases covered by disaster recovery as quickly as practical. SQL Server’s newer disaster recovery options – Always On Availability Groups and…
Read More
Brent Ozar reading

Building a Faux PaaS, Part 3: What the Ideal Engineering Team Looks Like

Brent Ozar
Architecture, kCura Relativity, Microsoft Azure
4 Comments
Background: I’m working with kCura to build a Faux PaaS: something akin to Microsoft’s Azure SQL DB, but internally managed. You can catch up with what we’ve discussed so far in Part 1 and Part 2 of the series. In the last post, I talked about measuring backup and restore throughputs across different instance types, regions, storage configs, and backup locations.…
Read More

Why I Love kCura RelativityOne Even Though I Don’t Use It

Brent Ozar
kCura Relativity, SQL Server
21 Comments
At RelativityFest this week, kCura showed more details about how their upcoming software-as-a-service hosted in Microsoft Azure works. I really like where they’re going with it. Presenting at Relativity Fest 2016 I’ve blogged about Relativity before, especially about how it uses SQL Server, but here’s a quick recap: It hosts legal data (think lawsuits, cases,…
Read More

I’m Presenting at kCura Relativity Fest 2015 in Chicago

Brent Ozar
kCura Relativity, SQL Server
2 Comments
This sounds really cheesy, but I’m honestly excited to be presenting again this year at kCura Relativity Fest 2015. Here’s what I’ll be talking about: How to Check Your SQL Server’s Health The Abstract: You’re a system or database administrator responsible for the uptime and performance of Relativity’s SQL Servers, but you’ve never received professional…
Read More

What Is Commodity Hardware?

Brent Ozar
kCura Relativity, SQL Server
8 Comments
You may have heard the term “commodity hardware” thrown around when describing solutions like Redis, Elasticsearch, or kCura’s new Data Grid. Commodity hardware refers to cheap, standardized servers that are easy to buy off the shelf from any vendor. Here’s a typical example of a 2u, 2CPU commodity hardware server: Supermicro SYS-1028R-TDW 1U rack server Two Xeon E5-2600…
Read More

Announcing kCura Relativity 9, Data Grid, Elasticsearch, and SQL Server

Brent Ozar
kCura Relativity, SQL Server
4 Comments
Today at Relativity Fest in Chicago, kCura Relativity 9 introduces the option to move some text storage out of Microsoft SQL Server and into kCura’s new Data Grid, a tool built atop the open source Elasticsearch. Is kCura abandoning SQL Server? No, but understanding what’s going on will help you be a better database administrator and developer.…
Read More

Tiering kCura Relativity Databases (Or Any SaaS Product)

Brent Ozar
ISV and SaaS Database Design, kCura Relativity, SQL Server
9 Comments
When you’re the database administrator working with a software product that stores every client’s data in a different database, the sheer number of databases can be intimidating. As you grow from dozens to hundreds to thousands of databases, you can’t treat all of them equally. Start by making a graph of the database sizes –…
Read More

Performance Tuning kCura Relativity

Brent Ozar
kCura Relativity, SQL Server
5 Comments
In the e-discovery business, kCura Relativity is the big gorilla, and I’ve been working with kCura and their clients since 2011. I think it’s one of the most interesting businesses I’ve ever worked with – up there with StackOverflow – and like Stack, they’re really open with their customers. George Nedwick and I staffing the…
Read More