Great Idea!

Thanks Phil.

This would work if they were loading a full set of data each day, but unfortunately its an incremental load, meaning 24 hr of data are inserted into...

Thanks Steve,

We've been looking into it and we do have a large amount of unrestored log on the secondary side for the mirror.
42,402,530 KB with an estimated...

2 hours, 34 views, no replies.
Must be a good one!

I have found a way to get it working though, feel free to read, but don't bash me...

I have updated the post with a scenario where sp_clean_db_free_space dosnt seem to work. Please see original post for details.

Thanks Jeff,

The reason we wanted these options was due a view that was being queried via Excel. We wanted the view to return rows even if there was an error...

After further investigation I have found that the CPU Time also counts CPU Waiting time.

The 2nd SP that increased frequency massively, but not CPU usage was probably adding contention to...

He there.

Yeah- that is a possibility. It could be that the params being called weren't the usual ones.

What happened was a bot crawled our site and was hitting a lot...

yep 4 years old 🙂

But yes- this table does give the references i was after...

Good to have as a reference for future searches.

Many thanks!

Thanks for the reply.

No- its just being run as a SQL query from Enterprise Manager.

Lowell (7/5/2012)

---

Yes this is all true, but I am not running it via the stored procedure- i am just running SQL code with the parameters passed directly , as in...

For clarity here is what I am running:

I put this SQL in, and run it. It takes hours. This is the one using synonyms.

--set up variables and define...

declare @StartDate datetime

declare...

Whats the best way to post execution plans?

Lowell (7/5/2012)

---

yeah i'm more sure than ever it's parameter sniffing, and nothing to do with synonyms at all;

my first clue:

if @EndDate is Null

select @EndDate = getdate()

i'll assume that the costructor...

Lowell (7/5/2012)

---

I'm thinking the issue has...

capn.hector (7/3/2012)

---

Taking a wild *** guess here and wondering if its because when using the synonym the query optimizer does not see the index on the view?? not sure...