Notifications
Clear all
Topic starter
Hello!
We have been experiencing some database slowness a couple of days a week on our Oracle DB. It seems to only last a few hours in the morning. Server utilization looks normal but it seems like no matter what we do it can take up to 45 seconds to load a chart.
I turned a ticket into GE about the slowness and they recommended that we turn on the Archive_Obs stored procedure.
So my questions are... Is anyone else utilizing this? If so have you seen performance increase? How does it affect those observations that are archived? Is it easy for the providers to look at the archived data?
Thanks!
Posted : September 21, 2015 12:50 pm
curious, how many records are in your observations table?
Posted : September 21, 2015 3:06 pm
Same question about how many obs in the table. Just loading SP10 shouldn't have effected it. But to answer your questions.
Is anyone else utilizing this?
Yes
If so have you seen performance increase?
Yep it can make a big difference. Depending on how many obs a pt has and how fast your DB server is.
How does it affect those observations that are archived?
Just doesn't download them when the chart is opened.
Is it easy for the providers to look at the archived data?
Yep they see missing where missing obs are and just have to hit the button get all obs to get all of them. Depending on the settings you use they may never have to hit the button usually the last 6 or so obs in any field is plenty.
Posted : September 21, 2015 4:07 pm
Topic starter
Is there a query or report I can run to see how many records are in the DB table?
Thanks.
Posted : September 21, 2015 4:15 pm
Yes I just don't know the Oracle one off the top of my head. (Sorry its been a long while since I was on Oracle) It might also be in the ArchiveOBS directions.
Posted : September 21, 2015 4:21 pm
Are you running your Oracle Database in a virtual environment?
Posted : September 22, 2015 3:58 am
Topic starter
No the Oracle DB is a physical box.
Bovie I looked in the directions but they just tell you how to enable and disable it and the different options for the tool.
Posted : September 22, 2015 4:45 am
Cody,
How long have you been on the EMR?
Posted : September 22, 2015 7:13 am
Topic starter
We have been on the EMR since 2005. We are a practice with 13 providers, so I am guessing that this would help us out a lot.
Posted : September 22, 2015 7:26 am
Oh ya I would just do it then. You can always go back if its an issue.
Posted : September 22, 2015 7:39 am
Topic starter
We have 83k patients in the DB. I am going to run it tonight but set it to only run for 6 hours to see if it completes or not.
Posted : September 22, 2015 7:50 am
Thanks for your response. If anyone is running Oracle DB in a Virtual setting and having this issue, please let me know how you are handling slowness/freezing as we are having similar issue and GE stated we are their only customer in a virtual environment.
Your feedback will be very valuable.
Posted : September 23, 2015 2:55 am
We are running Oracle DB in a virtual environment (VMware) and we have quite the opposite, our DB is fast and we rarely have speed issues that I know of. The DB itself is hosted on 8x SSD drives and the server has 4x vcpu and 24 gig of memory. We have spinning disks for OS, REDO, and arch.
We we have had issues before it was because our server was running off of 1 or 2 snapshots and those snapshots were hosted on the spinning disks and not the SSD drives.
We built the VMware environment to GE's specs and made sure everything was approved so I am not sure why they would tell you that no one is virtual.
Posted : September 23, 2015 5:03 am
To see how many records in your obs table in oracle (should work in sql as well):
select count(*) from obs
Posted : September 23, 2015 5:04 am
Topic starter
It's interesting that you would be told you are the only virtual customer. Ha. I'm sure a lot of GE customers are.
Our server is Physical. Specs:
Dell R710
Intel Xeon X5660 @ 2.80 GHz
24 Gig Memory
Windows Server 2008 R2
Disks: 4 x 300 GB 15K SAS in RAID 10
We do have the DB and Arch on one RAID and the OS on another.
Posted : September 23, 2015 5:10 am
Page 1 / 2
Next
