Slow Accpac running on SQL on a new fresh install of server 2003 and sql and acpac?
Posted on 2005-04-27
Well the question is posted in the MSSQL category because it's might be the cause of it.
Here I go:
Fresh install of a SQLServer on a win2003 Small Business Standard
Then Fresh install of AccPac on that same server, data is good server is blasing fast, with a raid 0 and a 3rd HD for logs, Machine is new and again fast !!!!!
Fast but not when I go into accpac, it's actually quites slow, as if I had over 80% of my CD being used... but it's not the case.
The "Expert" of SQL and Accpac told me it could be that the server is not configured right.
It's right now aa domain controler as it was suppose to be my main server, and now after a lost of data, it is now my accpac / sql server.
So what can I do to my new win2003 Server to lighten the load or speed up the accpac data entry.
Right now when running accpac of the server it self, it takes 5 seconds to go from Gneral legers to Accounts receivables, and it's the same no matter what I click on.
So from a client station it is slow, but right off the actual sever it seam to be as slow as anyother computer.
Anything to un install, or modify the server as a non Domain Controler, just to make it faster
note: everything else on the server is Super fast, internet, word, excel... what ever.