Well, I'm not sure you're getting the best advice here. I'm not sure how uninstalling modules that you are not using will reduce your SQL server usage. It might reduce your footprint, but won't reduce your database usage. Your ISP is not complaining about the 'size' of your database, but the number of transactions that are being executed. I would check your log settings and scheduler settings. First it would help us to understand the scope of your site before we can get more specific...
Let me see if answer questions. Your questions about traffic are valid, but the ISP has been less than helpful in getting information on this to resolve the issue.
- how many portals? just one? or do you have multiple portals?
I believe we have just the one.
- how many tabs?
We have 10 tabs and each has a submenu that go 1 to 3 levels deep.
- how many registered users?
Good question, but I couldn't tell you without the database and they're blocking access to it at the moment. I am working at trying to get a backup of the database, but have not yet.
- what is your site's approximate usage per day? # hits?
Again, this is an excellent question but we do not have access to the IIS logs for analysis.
- If you are unsure how to get access to your site logs, ask your ISP. Check the site logs, take a look at your SQL database. There are some simple queries that you can run against your database that might help you determine what all the transactions are that are being executed. If you can see what the huge volume of SQL transactions are you should be able to backtrace them to DNN to see what's causing them.
THeir network configuration of the ISP prevents direct access to the SQL server, so I can't run those queries yet, though I have an idea of how I might be able to. What would this queries be?
As I mentioned, the first things I would check are your logs to see if something unexpected is happening. It could be an error condition that is causing a lot of log records to be written.
- Go to Admin->Site Log and see if any application errors are being logged
- Go to Admin->Event Viewer and look to see if a large number of exceptions are being thrown
- Go to Host->Schedule and see which scheduled events are turned on
Alas, this seems to hinge on having database access. I have some ideas on how I might be able to do that.
Thanks!
Rory