Database 101-9: Why should you care about database maintenance best practices?

Database 101-9: Why should you care about database maintenance best practices?

I thought we’d get into those best practices once more, and walk through a few cautionary tales of how not maintaining these best practices can impact your pharmacy. (Spoiler alert: all are less than ideal situations for your staff and customers!)

Database 101-6: What does Page Life Expectancy (PLE) do to your database?

Database 101-6: What does Page Life Expectancy (PLE) do to your database?

So how can you tell if you’re giving SQL a big enough “desk”? There are different metrics around memory usage that can help you figure that out, but the most common one is called Page Life Expectancy. 

Database 101-4: Why should you care about Index Maintenance?

Database 101-4: Why should you care about Index Maintenance?

In our last post, we said why it is extremely important to perform routine Index maintenance for your SQL databases. I thought we’d walk through a few cautionary tales of how not maintaining these indexes can impact your pharmacy. (Spoiler alert: all are less than ideal situations for your staff and customers!)