if not exists ( select 1 from dbo.HostSettings where SettingName = 'GUID' )

This query was executing 100 times per minute on my dnn installation. Does anyone know why this would happen?

I have had serious performance issues over the last several months and stumbled across this when analyzing my SQL DB.

Could this be part of the performance problem?

DNN Version: 4.9.1

Page State: Page
Module Caching: Memory
Performance: Low Caching
Authenticated Cacheability: ServerAndPrivate
Compression Setting: GZip Compression

Schedluer Mode: Timer
Event log buffer is enabled
Auto-Sync File System is disabled

My site is extremely slow even when CPU utilization is below 40%

 Also, for almost any change that updates or deletes settings or tabs, the web request times out. I can't create new portals either; it's like it takes a very long time to get through half the process then quits.

The first query I mentioned, as well as this query, have literally jumped up to 2150 executions/min and the portal has come to a halt.

select SettingName,
  SettingValue,
  SettingIsSecure
from dbo.HostSettings