Have you looked into SQL Agent? That's how I schedule most stuff on SQL Server instances.

It's also possible, even though the plan changed, that you ran into resource contention or blocking or something else entirely.

Without lots more detail, it's hard to know. Based on everything...

But, almost forgot this, that assumes no compression. If you're using compression, all bets are off on making that estimate.

The backup consists of the actual space used in the data and log files (not the space allocated) plus a bit of room for meta data and some more for...

I think it's possible that might lead to multiple plans (sort of, actually you're likely to see multiple plans for the different strings, but a single plan for the proc),...

Congrats Brandie. That's really wonderful. Well done.

Brandie Tarvin (2/10/2011)

---

Ninja's_RGR'us (2/10/2011)

---

kasaranenikiran-725528 (2/10/2011)

---

This was DEV envoronment . ANd I have already revised the Backup strategy as Full Backup once a week. I will also look in to putting...

Ninja's_RGR'us (2/10/2011)

---

kasaranenikiran-725528 (2/10/2011)

---

THanks for the Info... This was DEV envoronment . ANd I have already revised the Backup strategy as Full Backup once a week. I will also look in...

As soon as you need to start taking direct control over what is running within Maintenance Plans, you've just out-grown them. This is actually kind of a great moment. Now...

I think your assessment of the issue is accurate. I'm glad things are back on track. I'd suggest you might want to set up some statistics maintenance. The auto update...

m.s.blake (2/9/2011)

---

I used to believe the same. Trust your instruments. Today PerfMon starting reporting zero for all my commonly used memory counters (Buffer Hit Ration, Buffer Manager Total...

Not seeing the code, I'm guessing, but I'll bet one or more of your queries are dynamic using EXEC or sp_executeSQL. That would explain why you have two apparent plans...

I'd favor going for the Developer version over SQL Express. There is just so much you can't do with SQL Express that is a standard part of SQL Server. If...

From what you've supplied, it's hard to be sure where the problem is occurring. You're saying that the query is a loop? That could be the problem right there. I...

Jan Van der Eecken (2/9/2011)

---

You know, I read through that whole thread, and somewhere mid-way I started wondering whether nadabadan himself wasn't actually the interviewer. I guess I am certainly...