Several hours after going live with my site, I got an email to an old email account I hardly ever use anymore about excessive database usage. Apparently, my webhost, (starts with an L and rhymes with dunarpages) missed my requests to not use that as my primary (or in this particular case, only) point of contact, and also, saw nothing wrong with just deactivating my domain without any warning or secondary attempt to contact me, despite the fact that they do have other email addresses and two phone numbers on file. Anyhow, here's the email I got...

During a routine check of the MSSQL server Castor this morning it was discovered that your database was using excessive resources on the server. Since the MSSQL server is a shared resource that provides database services to several of our shared Windows servers we simply can not allow a single database to monopolize on the server resources as that interferes with other databases and prevents those same services from being available to other databases. As such your domain letzgoout.com has been suspended. You will need to address this issue immediately to prevent further action against your account.

You database had over 127,000 reads and 132,000 writes and has the highest activety on the server. You will need to address the coding issues that are causing this resource usage and if you are unable to correct it you will need to look into upgrading to a dedicated server. It appears that there is a query that is looping and that is contributing to the resource usage. The query is provided below:

delete from dbo.SearchItemWord where [SearchItemID]=@SearchItemID

There have been 459 executions of this query in 90 seconds. This is excessive usage of the database services and is part of your overall resource usage that you will need to address.

--
Best Regards,
(the guy who nuked my account and was kind enough to send me an email to an old address, to tell me that they had done so, then ignored 4 hours of support ticket submissions by me trying to find out why my account was deleted)

So, my question is, why would so many hits to that database be made? I'm guessing it's a search indexing function, but maybe I'm wrong. Is this normal, is it because the site just got posted, or is there something configured wrong? Anybody else ever have this problem in the past?

oops, during further investigation I noticed, that this statement is called for each updated search item, i.e. text/HTML module, announecment module etc. if it was called that often, either you did a lot of work, ore there are modules, that misimplemented the search interface, causing to re-index all entries each time the indexer runs. incresing time between index runs may leverage the issue, but not solve it. try to identify the misbehaving module and contact the developer.

Thanks even more!

Unfortunately, you're talking to the developer.

I'm guessing it is that module with the 40k records, but, first, would it index it at all without implementing iSearchable, and if yes, would it reindex it entirely every time, or just new records?