Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

CPS database size

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

14 Posts

5 Users

0 Reactions

72 Views

RSS

lic08

(@lic08)

Posts: 286

Reputable Member

Topic starter

Has anyone notice that the CPS database size (especially cps 10) growing at rather fast pace?

Posted : December 27, 2012 11:52 pm

joshua.tilson

(@joshua-tilson)

Posts: 130

Estimable Member

Did you just upgrade?

Is it the MDF file or the LDF or both?

In our experience a new SQL install will set logging method to Full, which GE does not do anything with, so unless you are using the full logs, make sure to set the logging method to simple.

Posted : December 28, 2012 12:31 am

lic08

(@lic08)

Posts: 286

Reputable Member

Topic starter

it's the mdf file. We upgraded to cps 10 about a year ago and it's has double in size.

Posted : December 28, 2012 12:34 am

joshua.tilson

(@joshua-tilson)

Posts: 130

Estimable Member

I don't know what size you started on, or what size you have now. But when we went to the 9.x range of CPS, we have at least doubled in size since then, our biggest problem has been the time the backup window needs to complete.

Posted : December 28, 2012 12:46 am

lic08

(@lic08)

Posts: 286

Reputable Member

Topic starter

I don't know the size when we started with 10.0 but in the past 6 months, the database increased by 50 gigs to 170 gigs. We have been hosting CPS for a few years now and never seen this pace. At this rate, it's quite scary. I was wondering if anyone else is having this problem.

Posted : January 23, 2013 3:42 am

jdibiasio

(@jdibiasio)

Posts: 66

Trusted Member

could it be logs? or do you use the MIK? sometimes the MIK leaves tons of files behind in the interface folders (should be on the same partition as your DB). We have over 12 years worth of data and I haven't noticed anything out of the ordinary in terms of growth

Also make sure your SQL backups are overwriting the previous nightly backup, that's another common problem that occurs.

Posted : January 24, 2013 4:33 am

lic08

(@lic08)

Posts: 286

Reputable Member

Topic starter

I'm just talking about the db.mdf file.

Posted : January 24, 2013 11:30 pm

DavidShower

(@davidshower)

Posts: 1255

Noble Member

Recently add ePrescribing or increase the number of events you have auditing turned on for?

David Shower

OU Tulsa School of Community Medicine

Posted : January 24, 2013 11:34 pm

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

Have your offices been scanning in a lot of images?

How long is it taking to backup your database and what method are you using, SQL Server itself or a third party agent? Why is the backup time causing a problem? Online SQL Server backups shouldn't be causing any problems at all.

Posted : January 25, 2013 12:44 am

lic08

(@lic08)

Posts: 286

Reputable Member

Topic starter

Based on the CPS SQL tables usage report, all tables increased at a consistent pace month to month. The tables that increased the most are OBS, DOCDATA, AUDIT_EVENT, DOCCONTB, AUDIT_EVENT_, FMYCOVQUANTI, FMYCOPDRUGD,EDIREPORTFILE. These tables represent 80% of the increase.

Posted : January 25, 2013 12:55 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

I have a query you can run that will tell you specifically how many rows of data each table has and the specific size of each table as well. I think another poster hit the nail on the head with audit events.

You also have 2 other good sized tables (likely), OBS and DOCDATA.

If you want the query email be offline at [email protected]

Posted : January 25, 2013 1:02 am

lic08

(@lic08)

Posts: 286

Reputable Member

Topic starter

The report shows the number of rows and size of each table. The problem is that why are they growing so fast. It's not like one table is causing the issue. They are all growing consistently every month. I was wondering if cps version 10 was designed to capture more data. I don't remember version 9.5 ever grew like this.

Posted : January 25, 2013 1:07 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

I would run your report every day and highlight the tables that are growing the most. Once I identified the table(s) that is/are problematic I'd use SQL Profiler on that database and target all the transactions against the particular table(s). That should tell you what process is responsible for all the new data.

Posted : January 25, 2013 1:13 am

lic08

(@lic08)

Posts: 286

Reputable Member

Topic starter

I did a test upgrade on the production database to 10.1.3.3 and i noticed the database size dropped 7 gigs and the database backup file dropped 20 gigs. Anyone else noticed version 10.1.3.3 manage size better than the 10.0.2.218?

Posted : February 5, 2013 6:45 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0