I have an Access front end and SQL Server backend database that is about 3years running and now having problems with speed. The problem is intermediate. I am not an expert in SQL and dont know where to start, can someone help me troubleshoot this?

Thanks in advance

if it's an intermittent problem and you're using Access as a front end, especially if you've linked straight into the tables, my immediate thought is you've got deadlocking going on.

Otherwise you need to provide more information.

The access front end has all the queries, forms, reports and macros. Tables are linked to SQL backend.
Would Indexing the foreign keys in the tables help with performance? Right now only the Primary keys are indexed.

Mostlikely if it is an intermittant problem there are 2 options
1) The server is periodicaly beeing used for (heavy) reporting duties, eating up the resources on the Server... or something simular
2) Network issues/Network traffic.
This can either be overall network traffic or traffic on the server itself.

The access front end has all the queries, forms, reports and macros. Tables are linked to SQL backend.
Would Indexing the foreign keys in the tables help with performance? Right now only the Primary keys are indexed.


Yes that would probably help, but I wouldn't do it until you are sure what the problem is.

Has the database been reindexed recently?