Certainly was/is.... man talk about unloading the team in one fell swoop... wow.

Check the SQL Server logs for what else might be going on. Are other databases in an odd state? Did you restart the server and msdb go into...

AH... THE DTA tables are from the database tuning advisor. Log into that and you will see saved tuning profiles.... delete them if you don't care to have them...

Man... I am at a loss.

Hum... I don't know what to tell you... that table is quite large though.

Try doing a backup of msdb and restoring it as a different name and see if you...

Run a report on the MSDB data with Standard Reports, Disk usage by table. Find the largest tables and rebuild the indexes on them. You still have active...

There are several reasons for it. Typically the rows that are active are at the end of the file so it isn't shrinking. Rebuilding indexes on the tables...

I can't put the TEMPDB files on a local drive because this is a cluster.

I think I found a smoking gun....

I copied a 32 gig file from another server to...

No. TEMPDB is not trying to grow. I have it set to grow at 500MB. I have run the UPDATE Stats and DBCC CHECKDB many, many times...

scogeb (11/7/2012)

---

Markus (11/7/2012)

---

Very difficult to tell you... if fluctuates.....

The left side of the graph from 0 to 100 goes up and down but if I highlight one of the lines...

Very difficult to tell you... if fluctuates.....

The left side of the graph from 0 to 100 goes up and down but if I highlight one of the lines below the...

So I am using PerfMon to monitor

physical disk performance Obj

avg dis sec/read counter

avg disk sec/write counter

avg dis sec/transfer counter

based on this article:

http://blogs.technet.com/b/askcore/archive/2012/02/07/measuring-disk-latency-with-windows-performance-monitor-perfmon.aspx

but I cannot figure out what the information...

Thanks for the ammunition. I will see what I can find out about this.

Perry Whittle (11/7/2012)

---

As i said, you have all the components in between the SAN and the SQL instance.

HBAs

HBA drivers

multipath drivers

Fibre channel switches

Etc, etc

Initially, check the Queue depth settings on the...

When I run Update Stats on large tables and Integrity checks is the only time I see these. In Activity Monitor the DataFile I/O Response time in MS goes...