I have a Cloud Site running locally using SQL DB that is running exceptionally slow. It takes a long time to 'publish' a page and then even longer to refresh any page in the site. Whilst it is slow everything else is fine. Where can I begin to start debugging this issue? Are there common pitfalls when running a cloud site locally, especially from a SQL DB rather than SQLite?

No, should be super snappy. No idea where to start though! 😅 Assuming SQL server is on the same machine and not in a VM or Docker or anything.

mine super snappy running locally. Is it a big site?

Yep - same machine, vanilla setup really

You said the frontend is slow, add

?umbDebug=true

to your URL and check out the mini profiler https://cdn.discordapp.com/attachments/1260886472513556502/1260912885362589738/image.png?ex=66910c22&is=668fbaa2&hm=821c3b514b6940a0b70c6c5016f84ea2ad6aa7fedabb7999a517afc8e1554439&

Thanks @Sebastiaan I have installed this but it does not seem to do anything? https://cdn.discordapp.com/attachments/1260886472513556502/1260946401475690556/image.png?ex=66912b59&is=668fd9d9&hm=98bc9727e4b3c0cce3a566f44092684b2c35e6b3d15032ca310a45ac2cf53095&

I don't know what that is.you don't need to install anything. You just add the query string

Oh I thought I needed to insyall this to get the Umbraco mini profiler!

You probably need to set debug to true https://docs.umbraco.com/umbraco-cms/v/13.latest-lts/fundamentals/code/debugging#miniprofiler

Hehe great thank you