Folks,
I have 25 stores running SQL 2008 R2 Express all connecting to one single HQServer process which reads/writes back to a SQL 2005 Enterprise database.
We deployed RMS v2 back in 2010 and we started to noticed some slowness on the HQServer processing HQClient requests (data uploads without journals).
I'd like to hear your suggestions on how to best optimize HQServer processing.
Thanks in advance for your support.
...Alex
*This post is locked for comments
Hi Jerry,
Which tables are safe to delete rows from?
I can automate the process, but I am not sure what data can be deleted.
Please let me know.
Thanks,
...Alex
Hi. You need to clean out your databases. If it was fine before. I have done much of this horrible tedious work and would love to know a short cut if anyone has one!
-Jerry
#1
André Arnaud de Cal...
291,431
Super User 2024 Season 2
#2
Martin Dráb
230,503
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
