10/13/2014 #QBConnect QuickBooks Data File Management: Increasing Performance & Stability #QBConnect Mario Nowogrodzki, CPA/CITP www.qbspecialists.com • Master of Accounting Info Systems • Adv Cert QB, POS & ES ProAdvisor • Original ISP Advisory Council • Intuit Trainer/Writer Network • Industry awards: Top 100 ProAdvisor, Top Technologist VAR Stars, Technology Pacesetter, Killer VAR • Mendelson Advanced Training Academy #QBConnect 1 10/13/2014 What This Session is About #QBConnect Good practice…? #QBConnect Good practice…? #QBConnect 2 10/13/2014 What to do when… #QBConnect Data Management Fundamentals Data File Maintenance • File Size Considerations • Speed Up QB Troubleshooting • Verify, Rebuild, and more • Network Setup • Backup Power! #QBConnect Data File Size Considerations • Pro / Premier v. Enterprise • What to Do - Start new QBW - QB built-in ‘Condense Data’ utility - 3rd party utilities • Types of QB Use, Size of Transactions - “It’s not the number of columns in a database that slow things down, it’s the number of rows” [Chuck Vigeant] #QBConnect 3 10/13/2014 Speed, Performance • File size – QBW & TLG • Number of items, sites • Number of transactions… • Free space – Server & Local Workstation • RAM on local workstation • Number of concurrent users • DB file fragments… • Network latency / bandwidth – Gigabit everywhere #QBConnect Speed Up QuickBooks • Tips & Tricks - Backup with Verify - DB File Fragments (F2) - QBM* round-trip • QB Enterprise DB Server • Data Archiving • QB Preferences… • Network Environment… #QBConnect Speed Up QuickBooks • Tips & Tricks - Backup with Verify - DB File Fragments (F2) - QBM(endelson) round-trip • QB Enterprise DB Server • Data Archiving • QB Preferences… • Network Environment… #QBConnect 4 10/13/2014 Speed Up QuickBooks QB Preferences • Do not auto-open Home Page • Do not save QB desktop upon exit • For very large files - Modify Report Window before running reports - No auto-refresh of reports #QBConnect Speed Up QuickBooks Network Environment • Terminal Server (Remote Desktop Server) • Gigabit Ethernet—everywhere • QB DB Mgr on dedicated machine… #QBConnect Speed Up QuickBooks QB Database Manager • Registry Tweak - HKEY_LOCAL_MACHINE/SYSTEM/ControlSet/Services/QuickBooks DB25/Parameters - –ch xxxM –c yyyM o xxx > QBW file size o yyy = ½ xxx - Also applicable to QuickBooks DB24, 23, etc #QBConnect 5 10/13/2014 Speed Up QuickBooks QB Database Manager • Edit QBW.INI - [DBSERVEROPTIONS] InitialCache=256 (if set to 0, meaning “None”) MaxCache=512 (if set to 0, meaning ‘Unlimited’) • Download “Cache Settings Fix Tool” • KB Article ID# SLN65343 #QBConnect Troubleshooting #QBConnect Troubleshooting • Type of network setup - Peer-to-Peer, Client-Server - Network speed • Watch for Multiple QB Hosts on the network - May be sign of other trouble • Check .ND file… #QBConnect 6 10/13/2014 A Look Inside the .ND File #QBConnect Troubleshooting • Sort All Lists - For Names list: Ctrl-L while in Write Check function • Rebuild - From QB server / where QBW resides - Check QBWIN.LOG o “A Rebuild w/out reading the Log is no Rebuild at all” [Mario N.] - May need to run back-to-back-to-back (up to 3 times) - May need to fix some things manually #QBConnect What To Do? #QBConnect 7 10/13/2014 Backup! • Backup, Backup, Backup, Backup, Backup, Backup, Backup • Backup, Backup, Backup, Backup, Backup, Backup, Backup • Backup, Backup, Backup, Backup, Backup, Backup, Backup • Backup, Backup, Backup, Backup, Backup, Backup, Backup • Backup, Backup, Backup, Backup, Backup, Backup, Backup #QBConnect Backup! QB Backups • Backup Automatically • Backup on a Schedule External Backups • Server Automated Backups • USB / Flash / Thumb Drive • Online Backups • “Asteroid Proof” Backup System #QBConnect Review and Takeaways • Speed up QB - File size considerations - Maintenance - Preferences - Network environment • Troubleshooting - Rebuild and more - Backup, backup, and backup… #QBConnect 8 10/13/2014 Thank You Mario Nowogrodzki, CPA/CITP [email protected] 954-447-0250 #QBConnect Mario Nowogrodzki, CPA/CITP [email protected] 954-447-0250 9
© Copyright 2024 ExpyDoc
