Hey MyDoggieJessie,

Thanks so very much for your replies.

All disks are local to the server, no DAS or SAN yet.

MDFs: 6GB/s SATA SSD

LDFs: 6GB/s SAS 15K spinning

In general, we don't have performance issues. But I've seen an uptick in index scans on one of the 100 million row tables.

We are lucky to have a generous maintenance window, so running fullscan for stats is not an issue at the moment. But thanks for pointing out that we have alternatives.

Yes, index maintenance is done nightly, via Ola Hallengren backup scripts.

Just wanted to clarify that for a lot of the reports, they do call stored procedures, and we can modify those if there are performance issues. It's the framework-generated stuff that's a problem (and it has the added benefit of not really being human-readable).

Thanks again for your suggestions.

sqlnyc