MT 6.15 and Data Repository | Forum

Topic location: Forum home » Reporting » DR Reporting
Jul 27 '17
2017-07-27 13:56:59
Hi all - We are a two facility hospital and have been on 6.15 for less than year. Our M-AT db has gone from 300GB to 800+GB in less than a year since we upgraded. Just looking for any other multi-hospital sites running 6.15 and using the DR to see how you are dealing with large data growth.
Ryan Pighin
MEDITECH System Administrator
Information Systems Department
Waypoint Centre for Mental Health Care
500 Church St. Penetanguishene L9M 1G3
Rm A313
(705) 549-3181 ext. 2631
This electronic transmission and any accompanying attachments may contain privileged or confidential information intended only for the use of the individual or organization named above. Any distribution, copying or action taken in reliance on the contents of this communication by anyone other than the intended recipient(s) is STRICTLY PROHIBITED.
If you have received this communication in error please notify the sender at the above e-mail address and delete this e-mail immediately.
Jul 28 '17
2017-07-28 17:51:18
Hi Ryan,
There are a few things you can look at to determine the cause of this much growth, which is not uncommon with 6.1 Data Repository.

1. Do you know if MEDITECH has enabled all of the tables for transfer to DR? If so, you can ask them to only enable what is commonly referred to as the "core tables" list, those used most frequently for reporting. . If you know you are using specific tables not on the core list, they of course can selectively turn them on as well.
2. You can determine which tables are using the most space by using the Object Explorer Details view in SQL Management Studio, then adding the "Data Space Used" column to the window. The column can then be selected to sort the results by the data in that column. There are many "Stats" tables in DR (especially in ABS and BAR) intended for aggregate reporting they may be unnecessary - as in previous MEDITECH platforms, all the detail tables that contribute to these statistics are also available, and we've learned that our clients almost never need to rely on these tables. As such, they are candidates to turn off for transfer to DR to save space going forward. Conversely, a table like BarAcct_Txns (which will be very large) is commonly used for reports, and should be left enabled (don't let size alone determine which tables to turn on or off).

1. Lastly, SQL Server does offer a feature that allows individual tables (and indexes) to be compressed, but this requires a bit of configuration to set up and implement correctly, so I would explore this as a last option in the event you are almost entirely out of disk space - better to address the problem up front by reducing the amount of new data flowing in to DR.
Hope this helps,
Ian Proffer
781.329.4300 x202
Data Repository Experts Since 1998

chenjinyan May 14 '18

mont blanc pens wedding shoes cheap nba jerseys air force 1 coach handbags snapbacks wholesale under armour outlet nike air force wholesale nfl jerseys polo ralph lauren balance shoes kobe 11 air max michael kors outlet coach outlet online birkenstock outlet jordan 8 oakley sunglasses polo ralph lauren tag heuer watches barcelona jersey ralph lauren uk louis vuitton jordan 4 beats by dre fingerlings monkey flops jordans dansko shoes tory burch outlet coach factory outlet air jordan 14 adidas ultra boost nike mercurial vapor true religion jeans jordan shoes polo ralph lauren jordan 5 air max 270 louboutin nike uk adidas outlet baseball bats air jordan 11 jordan shoes asics running shoes air huarache louis vuitton jordan xx9 nike shoes converse shoes juicy couture outlet adidas jeremy scott scarpe mbt air max timberland boots adidas stan smith jordans michael kors outlet flip-flops coach outlet nike outlet supreme outlet nike outlet flip flops michael kors outlet off-white clothing nike free kate spade handbags coach outlet stuart weitzman shoes air jordan oakley sunglasses wholesale burberry outlet online cheap mlb jerseys jordan retro pandora jewelry canada nike tennis oakley sunglasses true religion jeans red bottoms pandora jewelry converse herve leger dresses cheap nfl jerseys adidas yeezy 350 cheap jerseys stussy hoodie oakley sunglasses nike free run louis vuitton outlet online cartier jewelry replica watches oakley vault fitflops outlet undefeated shoes nike air max coach outlet michael kors outlet pandora jewelry off-white clothing supreme uk rolex watches longchamp outlet coach factory outlet oakley sunglasses air max 90 ray ban sunglasses nike shoes for men coach outlet online van cleef & arpels jewelry superdry clothing nike lunarglide new balance sandals adidas outlet store jordan 3 louis vuitton outlet toms outlet michael kors outlet adidas flip flops ralph lauren uk michael kors outlet light up shoes burberry outlet michael kors outlet nike uk coach factory outlet nike outlet online burberry outlet salvatore ferragamo air max 95 polo shirts jordan kate spade coach roshe run belstaff jackets audemars piguet ralph lauren nike huarache shoes nfl jerseys wholesale ray ban sunglasses wholesale coach outlet online flip-flops birkenstock sandals burberry outlet canada christian louboutin longchamp coach outlet cheap mlb jerseys nike presto coach outlet online michael kors outlet online red bottom shoes nike cortez converse shoes polo ralph nike blazer ray ban kate spade adidas slides links of london mulberry handbags lebron 15 celine outlet coach outlet online puma fenty sandals true religion jeans louis vuitton outlet ralph lauren bcbg birkenstock shoes james harden shoes ray ban sunglasses nike outlet nike air max louboutin timberland pro basketball shoes nike sb air max 2017 curry shoes ferragamo shoes louis vuitton handbags nike dunks louis vuitton outlet giuseppe zanotti shoes swarovski new balance ray ban longchamp outlet jordan 12 coach outlet oakley sunglasses louboutin pandora jewelry canada air max jordan polo ralph air max hermes outlet prada prada louis vuitton nike free run manolo blahnik shoes hermes kelly bag ray ban sunglasses louis vuitton outlet marc jacobs cheap nfl jerseys suicoke sandals louis vuitton nike epic react mont blanc birkenstock sandals malone souliers mules yeezy 500 blush givenchy handbags louis vuitton handbags cheap rolex watches puma slides michael kors hermes birkin bags jordan 6 nike revolution air jordan adidas wings pandora jewelry air jordan shoes ray ban air max plus supra shoes nike outlet valentino shoes oakley sunglasses bottega veneta hollister outlet nfl jerseys mont blanc pens nike shox nike free swarovski jewelry polo outlet cheap oakley sunglasses longchamp handbags mac cosmetics supreme coach outlet online cheap nfl jerseys adidas football boots asics timberland boots yeezy shoes hermes uk timberland boots louis vuitton dior handbags air jordan nike shoes bvlgari rings birkenstock cheap nhl jerseys michael kors handbags air max 2018 ray ban sunglasses michael kors handbags ray ban nike outlet store tod's shoes flip flops ralph lauren nhl jerseys tory burch outlet nike tn toms outlet online mishka clothing alexander mcqueen shoes breitling watches coach handbags jordans balenciaga shoes ralph lauren balenciaga sandals coach factory outlet online rolex watches michael kors ferragamo outlet ray ban louboutin michael kors handbags outlet louis vuitton mbt shoes adidas uk pandora uk louis vuitton handbags true religion jeans gucci slides jordan 1 nike air max coach factory online vibram five fingers breguet watches michael kors outlet clearance air max 97 nike roshe prada handbags baseball jerseys adidas superstar hermes balenciaga shoes vans shoes oakley sunglasses polo outlet louis vuitton adidas shoes jimmy choo shoes vans shoes ray ban nike blazer flops cheap ray bans true religion jeans true religion tory burch adidas nmd supreme polo outlet miu miu shoes air jordan cheap replica watches pandora outlet gucci outlet michael kors taschen dolce and gabbana nike kyrie 3 beats by dre mizuno running shoes michael kors uk mlb jerseys longchamp soccer jerseys adidas yeezy nike air huarache louis vuitton outlet michael kors handbags jordan shoes nike air pandora charms coach outlet online polo ralph lauren timberland outlet kate spade cheap rolex watches adidas nmd carnival shoes michael kors outlet adidas outlet swarovski crystal adidas outlet store burberry scarf kate spade outlet pandora charms louis vuitton outlet jordans manchester united jersey harden vol 1 fitflops coach kate spade y3 shoes asics running shoes coach factory outlet online polo ralph lauren outlet mcm bags longchamp nike flip-flops kevin durant shoes adidas stan smith shoes oakley canada fila sneakers louis vuitton jordan pas cher air max 1 michael kors outlet blackhawks jersey ralph lauren uk louboutin christian louboutin outlet christian louboutin christian louboutin shoes christian louboutin outlet coach outlet coach outlet online michael kors outlet store kobe 12 nfl jerseys wholesale tory burch tory burch bags prada bags prada handbags columbia sportswear 20185.15chenjinyan