Notifications
Clear all
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
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
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
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
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
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
Topic starter
I'm just talking about the db.mdf file.
Posted : January 24, 2013 11:30 pm
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
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
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
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
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
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
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
