Download - Woodard

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]om
954-447-0250
#QBConnect
Mario Nowogrodzki, CPA/CITP
[email protected]
954-447-0250
9