Stop blaming AC. Your setup is just wrong most likely. Let a SQL expert come in and measure your query times. It doesn't matter if you put the system on the Pentagon's servers. How much RAM are dedicating to the SQL server? Plus RAID 10 is the way to go. Or at least RAID 10 or RAID 6. Like James said, RAID 10 not used only due to cost, which I doubt is your issue.
We have two SQL experts. JamesNT and the guy I talked about in the private messages. Nothing against James, he knows his stuff. Just giving you another option. Like James, has 20 years of experience working for major companies. You need to have them jump in use SSMS to pull a chart and see if it is SQL or AC. On mine even with Express, the queries are like 2 ms and AC is about 5 seconds. Again, getting back to the amount of RAM on SQL. It needs more than 1 GB of RAM. Probably at least 5 to 10 GB to handle the pages. You are asking AC to bring over a lot of data for speed which, of course, does just the opposite.
Please don't take this wrong, but if this is a problem with your SQL-AC setup, then AC can't fix it. They have probably never seen this problem because it has never happened before. No SSDs, that is a problem. But, still 2 minutes to open a chart? Crazy.
This is my final piece of advice. Not sure what James charges. My friend, just to give a second opinion, is very reasonable. It is your setup, pure and simple. You could have the fastest CPU and hard drives and RAID 0 for speed (no redundancy) and it isn't going to fix the problem. How much RAM is dedicated to Standard?
Someone with SQl server experience could delete your log files and get your space down to 6 GBs. Hire James. Hire my friend (sorry James -- just giving him options based on time factors). This is obviously too difficult for AC -- I don't blame them at all -- and not solved by you yet. Spend the money and have a SQL
EXPERT look at your query times when you pull a chart. I am taking you installed SQL Server Standard yourself. It is extraordinary fast, no limit that know of on RAM or database (I could be wrong), but if someone who is SQL only didn't set it all up, then there is probably an issue there.
Last edited by Bert; 11/08/2023 7:50 AM.
