But I need something quantifiable to tell me where the largest Create/Update/Delete activity is coming from or where its occurring.

I kinda get the "where" with this:

SELECT...

The instance is pretty busy and when I query i see mostly reads, using the insane adhoc sql that this application likes to send.

I tried using this query which does tell me what is getting updated most frequently. But those are not necessarily the same tables. I could have very large writes going...

Thanks for the replies. No, this is happening continuously. It is not the maintenance.

The database is used by a third party application. If I could just tell which queries are...

this sql is really ugly but if you execute it on the table described above it will give the dupes combined into one row for each.

using it you insert them...

You can also set the database's autogrow property. Right click on the database, click properties, select files and click on the ellipsis for the data file in the Autogrowth column....

sorry i have probably just stated the obvious if you are an old hand :).

we are running 2008 R2, I wish we had an SP3.

If at all possible I would bounce the server after an SP update. Do make sure you take full backups prior to it, and have a backup plan in case...

We use Confio Ignite and Dell SQL Spotlight Enterprise. I like Ignite's breakdown of the SQL analysis, Spotlight for overall monitoring and alerting.

The current version of Confio Ignite will also do this.

Thank you sir!

I'm surprise no one has one, trying to identify differences between multiple dev instances, DR/HA instances and prod can be a pain.

We're using Confio Ignite8. It has helped a lot.

There's a free version here http://www.ignitefree.com/

makes sense i can see why it'd be on for msdb but not sure about tempdb. anybody out there know the answer?

thanks,

scott

Thanks - yes i found a script (could be yours) that identifies the FKs without indexes. I just used it not to long ago. I think I just had a...