Believe it or not there was a DBCC running every 15 minutes in the backround. This ran before each Transaction log backup, it was not set to do so. Every so...

It ain't baseball

http://football.guardian.co.uk/Match_Report/0,1527,1565033,00.html

This is good as well

http://www.sqlservercentral.com/columnists/RDyess/ospr.asp

Thanx for all your help.

Now if only Ireland had a decent striker

So you think that my sp complitation keeps disappearing - Therefore forcing a recompile each time it's run?

Still looking -

That's it. I ran DBCC DROPPROCCACHE. The reran the SP. Same speed (Slow) - Ran it again it went to normal speed. Changed One of the input param (Added and extra day...

I changed the Param and the SP goes back to the OLD poor performance levels. Head wrecking

Cheers RGR'us

Well that worked. You're a genius.What just happened?

Also will that return to the old speed with different params? 

I suppose I'm pushing it to ask why Profiler on one server is showing...

My bad. Yeah same Params. Same everything. Just completed a reboot. No effect. Do you think it's got anything to do with use of the tempdb? They are saying the...

Try disconnecting and reconnecting to the Server on EM

Im' quite laz:y as re,gards . punctuation,: and emoticons  make me feel child,ish

Erm... Andrew. I wasn't referring to you being rude. I was refering to Suk being rude to you and wondered why you even bothered to help him.

Apologies for the misunderstanding

In EM. Right click on the relevant server. Select edit sql server registration properties. Then check the "Display SQL server state in console" box.

Don't know why you bothered with the second reply Andrew. Nothing worse than rudeness.

suk - "Please be polite - If U R  cruel in sql"