Advanced Technology

2. Advanced Technology Thomas StevensClient Services January 22

3. Log readingTools for DocuTrack IT Integra Logging, the layout 1/29/2013 11:06:55 AM :: IN :: 5900 :: Log.ConfigurationChangeWatcher :: Setting up the watcher to monitor configuration file Date/Time Level Thread Text message Logging Level described TR Trace extreme verbose DB Database call VB Verbose ST Stopwatch duration of call DI Diagnostic like Trace AU Audit IN Information WA Warning could be bad EX Exception is very bad ER Error is bad

4. Log readingTools for DocuTrack IT Integra logging log filter tool

5. Log readingTools for DocuTrack IT BareTail – The log viewing tool Highlighting text Filtering text Source: http://www.baremetalsoft.com/baretail/

6. Log readingTools for DocuTrack IT BareGrep – The log finding tool http://www.baremetalsoft.com/baretail/

7. Log readingTools for DocuTrack IT NotePad ++ – The handy text editor with macros Source:http://notepad-plus-plus.org/

8. Dialogic Brooktrout VS Diva fax cards • Two different telco. card companies purchased by Dialogic • BrookTrout 1034 • Original player on the market, manufactured by Brooktrout • Brand name for telco cards • Limited troubleshooting and monitoring options with in use • Generally more expensive per port • Generally more difficult to configure, more options • Diva • Originally manufactured Eicon Networks • Less expensive • Simple configuration less options • Troubleshooting on the fly while in service • Use caution if purchasing UM board ( 50% of channels can fax) • Longevity of this product in question( DocuTrack no longer ships with Diva cards) • Don’t Mix and match BrookTrout and Diva cards! • Don’t Mix and match analog and digital cards

9. Fax servers Facsys vs Faxcore • Two different fax server providers • Facsys by Solgenia • Original fax server used with DocuTrack • Uses Email to transfer fax messages from the Fax server to DocuTrack ( SMTP is best effort delivery) • Uses Facsys Client Dll to send outbound faxes • No further enhancements of this product • Faxcore • Requires 2008 R2 and above • Requires DocuTrack 5.2 or above • DocuTrack web services to poll Faxcore ( guarantee delivery) for inbound faxes • DocuTrack uses web services to create outbound Fax • Can use etherFax for Disaster Recovery or Integra Fax Cloud Solution (ICFS) • Supports multiple fax cards on multiple servers (FaxAgents)

10. FaxCore with etherFax Source: http://www.faxcore.com/pdfs/etherFAXBrochure.pdf

11. Virtualizing DocuTrack • Benefits • Increased uptime if used with technology like vMotion • Improved disaster recovery • Isolation of applications • Possibly reduce footprint (economy of scale) • Save energy(economy of scale) • Flexibility of hardware • Drawbacks • Fax cards are not supported virtual device • Increased knowledge of the technology required by IT operations • vMotion benefits from external storage i.e. SAN = $$$,$$$.$$ • Virtualization loses benefits if only one application • The design and configuration of the Virtual server can greatly effect performance! Source: http://www.infoworld.com/d/virtualization/top-10-benefits-server-virtualization-177828?page=0,0

12. Virtualizing DocuTrackFurther reading • http://www.brentozar.com/archive/2009/03/why-your-sysadmin-wants-to-virtualize-your-servers/Improved disaster recovery • http://www.brentozar.com/sql/sql-server-san-best-practices/ • Tools for testing disk performance • SQLIO (measures disk performance) • CrystalDiskMark ( one button measure tool) • SQLIOSim (SQL stress utility, applies load to disks)

13. Virtualizing DocuTrackSQLIO Reference system Purposed system

14. Virtualizing DocuTrackSQLIO

15. DocuTrack PerformanceThe cookie cutter way • DocuTrack for a large number of customers is deployed: • Similar or exactly the same hardware • Similar or exactly the same software • Very similar usage • Resulting in the performance and characteristics extremely the same between installations • SQL performance • Services memory foot print and CPU usage • Document load times • When something goes wrong what is different about this site? • Are other installations have this same issue? • Is their hardware different ? • Is the shape of their data different? • Is this installation the only ones using the product like this?

16. DocuTrack PerformanceMost common environmental performance issues • SQL server is starved for memory • Most common Server 2003 standard with SQL 2005 • Because of the 4 GB memory limitation 2 GB for OS 2 GB every thing else • Use SQLServer:Buffer manager / Page life expectance, MS recommends over 300 seconds. • Disk performance on SQL data drives • 15K SAS drives and H700 controller recommended • Many SATA drives don’t always equal a SAS drive • If using a SAN do you have bottlenecks in the pathways? • Use Physical Disks \ Disk sec/Read, MS recommends under 10 MS • Over use of VM ballooned memory • If the SQL server is running on a VM is the memory over subscribed? • See http://www.brentozar.com/archive/2012/11/how-to-set-sql-server-max-memory-for-vmware/

17. What is an acceptable amount of data loss? What is an acceptable duration for an outage?Are you practicing what is needed to prevent data loss? • Have you tested a restore from the backup system in the last 90 days? • Are you verifying that backups are finished before changing media? • Is backup technology outside of the scope of the people in your business? • Do you know if your RAID array in the server or SAN are not degraded? • Do you have UPS that is capable of shutting down the server in the event of a power loss? • Do you have a server that is out of warranty? • If you are using a Fax provider? What type of redundant Internet connection are you using? • If you have multiple Pharmacies geographically separated what is the SLA on the connection, what is the backup plan when the connection goes down?

18. What is an acceptable amount of data loss?Is online backup service a good fit for your business? Online backup services Source: http://www.pcmag.com/article2/0,2817,2288745,00.asp

19. What is an acceptable amount of data loss?Is online backup service a good fit for your business? Online backup services • Read the SLA of the backup service! • How long does a backup take? I have breaking news, your restore is going to be no faster than the backup duration! • Do you have sufficient bandwidth on your internet connection(s) to support Online backup services • Is it HIPAA compliant? Source: http://www.computer-it-support-services.com/carbonite-backup.html http://www.forbes.com/sites/tonybradley/2013/07/23/the-myth-of-online-backup/

20. DocuTrack MigrationsThe basics Database contains Pointer to PDF file DB PDFs Database contains Pointer to product folders Folders SMTP Host Service Users

21. DocuTrack Migrations • Pre steps • Install DocuTrack on the target system • Stop the DocuTrack services on target except the Host service • Copy the PDF files from the source system to the target system, RoboCopy is most often used. Copying only documents that are newer or non existent. • Backup the database from the sources system and restore on the target system. • Adjust folder settings in the database to match target system • Validate functionality Source: http://technet.microsoft.com/en-us/library/cc733145.aspx

22. DocuTrack Migrations • 1 day before cutover • Backup the database from the sources system and restore on the target system, WITH NORECOVERY • At cut over • Stop all DocuTrack services both systems • Backup the database from the sources system and restore on the target system, using differential backup • Adjust folder settings in the database to match target system • Finish the Copy the PDF files from the source system to the target system. • Validate functionality

23. Redundant / Failover solutionsEvaluation order most critical first • Data protection • Disk redundancy RAID(1,5,10) • Hot spare • Current backups • Fax solutions • Some method to get faxes if there is a Telco failure • Some method to get faxes if there is a hardware failure • Higher risk for site that are geographically separated • Hardware protection • Keep warranty up to date, Integra ships the DocuTrack server with 24/7 4hour warranty. • Some method to get faxes if there is a hardware failure • Higher risk for site that have multiple VM servers running on one physical host. Source: Text goes here

24. Redundant / Failover solutionsRedundant Fax servers DocuTrack PDFs DB

25. Redundant / Failover solutionsRedundant Fax servers/Stand by DocuTrack servers DocuTrack DocuTrack Double take PDFs PDFs DB DB SQL mirroring • Constraint connect recommended • Software like double take recommended • Knowledge of SQL mirroring required • AD required

26. Redundant / Failover solutionsRedundant Fax servers/Full redundancy Load balancer NAS DocuTrack DocuTrack PDFs SQL witness SQL primary SQL mirror DB DB DB

27. Thank You