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?

By Rick Magill

A continuation of the blog post Database 101-3: What is 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!)


Database Best Practices

 
Database Best Practices.jpg
 

·       Run daily / weekly Index Defragmentation

·       Ensure proper backups / disaster recovery

·       Install appropriate database integrity checks

 

What happens when the above isn’t executed? Here are some real-world issues that have been called in to SoftWriters, and how each situation resulted.

 


Issue: Over the last few months our system has slowed down.

snail.png

Discovery: There was no blocking on the SQL server. Ran an index fragmentation script. Over 100 indexes were over 80% fragmented.

Solution: Ran index maintenance overnight.

Results: Improved performance speeds achieved.

Best Practice: Run index maintenance at least once per week.

 

Issue: No one can log in. It shows an error about something missing?!

system error.png

Discovery: FrameworkLTC error that a stored procedure was missing. SQL was missing the entire FWDB; other databases were in a state of disarray. Ticketing system showed a recent upgrade from an older version that required a database migration. IT at the pharmacy had reverted from a backup of virtual machine that was mid-migration. SQL backups were being run daily, but were left on the virtual machine.

Solution: Restored the databases.

Results: The pharmacy lost three weeks of data.

Best Practice: Establish more efficient disaster recovery procedures like moving backups offsite for disaster recovery.

 

Issue: Complete pharmacy down!

DB Error.png

Discovery: All users were receiving the same error. Upon checking SQL, “FWDB (Suspect)” = Data corruption

Solution: Ran index maintenance overnight

Results: Restored the database

Best Practice: Follow better database maintenance procedures such as running index maintenance at least once per week.

 

Rick Magill is a Solutions Consultant at SoftWriters, a Pittsburgh-based company that offers pharmacy management software solutions to pharmacies serving the long-term care community. Rick is an integral part of our customers’ success with his forward thinking and commitment to excellence.

 

Database 101-1: Tables and Indexes

Database 101-1: Tables and Indexes

Ryan Huber and Rick Magill presented “Database Optimization and Performance Improvements” as a breakout session at our conference last month, and due to it’s popularity we’re sharing it as a series of blog posts. This post covers tables and indexes.

In 2018, let SoftWriters help train your pharmacy team!

In 2018, let SoftWriters help train your pharmacy team!

The New Year is the perfect time to take a holistic view of your current pharmacy operations and your goals for 2018. SoftWriters has assembled an all-star team of Consultants, Implementation Specialists, and Trainers in order to help you meet your operational goal.

Implementation Tips from a Trainer

Implementation Tips from a Trainer

Implementing a new software application often seems like a very daunting task, especially considering pharmacies typically don’t have the luxury of closing shop for a few days. The goals of improved workflow efficiencies, accuracies and business growth make the transition worth it, and with proper planning and expectation setting you can tackle implementing new technologies head on! Here are some helpful tips, best practices, and recommendations to help aid in the transition.

SoftWriters' New Extended Service Hours

SoftWriters' New Extended Service Hours

Starting April 3rd, 2017 our new hours of standard operation will be 8:30 a.m. to 8:00 p.m. EST.

After hours support will continue to be available until midnight Monday through Friday and emergency support will still be available 24/7/365.

Introducing Free Monthly Training Webinars

Introducing Free Monthly Training Webinars

SoftWriters is excited to initiate a new monthly training webinar series. This series will cover a variety of important training topics that will be beneficial for FWLTC users to attend. All customers will be able to have input on the topics covered each month via a quick survey; registration and format will be similar to the monthly Release Notes Webinars.

6 Ways FrameworkECM™ Helps to Ease The Burden of Audits

6 Ways FrameworkECM™ Helps to Ease The Burden of Audits

Audits are costly and happening at an increased rate. They commonly occur 12x’s or more each year, requiring your team to spend countless hours sorting through and organizing paperwork. Costs skyrocket when one singular piece of documentation is missing. With FrameworkECM content management solution, one staff member could respond to an entire audit in a matter of hours.

Support Your Facilities' Med Pass with 3 Customizations on Forms & Labels

Support Your Facilities' Med Pass with 3 Customizations on Forms & Labels

Customizing your service to meet the unique needs of each facility you serve can strengthen your partnership and assist in delivering quality care to the residents. One of the most common areas for customization is on forms and labels. FrameworkLTC offers you the ability to completely customize your forms and labels.