Thank you for your replies.

I'm moving report's SP's to a replicated Database and I'm tuning them as well.

I have also identified the worst performing queries and I'm taking them on...

Lynn Pettis (9/1/2015)

---

Welsh Corgi (9/1/2015)

---

DBCC CHECKDB

( 'database_name'

[ , NOINDEX

...

Eric M Russell (9/1/2015)

---

Here are a few TEMPDB related scripts...

Ed Wagner (9/1/2015)

---

Finding performance problems can be difficult. Fixing them can be difficult. However, it doesn't usually matter how hard it is to find or fix problematic procedures...

DBCC CHECKDB

( 'database_name'

[ , NOINDEX

...

There are hundreds of SP's that use Temp Tables excessively.

Issue resolved.

Unfortunately that is not a quick fix.

They are running a lot of SP's that use Temp tables. Hundreds...

For testing purposes.

I did not want have to restore the Database after each test.

The problem is resolved.

The archive procedure for the 1st table works but the second one is blocking it self?

I did a repair and it appears that it is working.

Eric M Russell (8/31/2015)

---

Welsh Corgi (8/31/2015)

---

Eric M Russell (8/31/2015)

---

TEMPDB will automatically shrink whenever SQL Server is restarted, which might be most reliable way to do this, if needed. However, unless...

Eric M Russell (8/31/2015)

---

TEMPDB will automatically shrink whenever SQL Server is restarted, which might be most reliable way to do this, if needed. However, unless your TEMPDB is competing for...

Steve Jones - SSC Editor (8/31/2015)

---

Don't use the GUI.

Use DBCC Shrinkfile( tempdbdata, 1500);

Or something close to the current size. Just get it to run. If it does, then work...

Steve,

I ran everything in T-SQL and threw the GUI.

Shrink Database

Shrink Files

ALTER DATABASE tempdb MODIFY FILE

(NAME = 'tempdev', SIZE = 1000)

DBCC FREESYSTEMCACHE('ALL') which ran 33...