I don't advise to tweak msdb sprocs. Ssms uses these to start kinderen.

write a stored procedure for which you grant them exec auth.

With that sproc use the "execute as" for an account that has the auth to start the wanted job.

just start it from the commandline adding the -m parameter and you should be fine.

I haven't tried to add a fourth registry parameter with the -m .

(each entry can only...

I would think of a blocking situation causing many waits for your jobstep to proceed.

If you don't have a blocking sampler or monitoring app, this is hard to prove 100%.

change you db so it uses "auto_close"

( alter database xyz set auto_close ON )

This way your applications - if any - should be able to work, if their timeout survives...

You don't need to take your instance nor db offline to create valid sqlserver backups.

Have a look at "backup database" in books online.

Keep in mind you also need "backup log"...

Options were cholera or plague. What did...

M_E_K (10/20/2011)

---

Ooops... just realized that you can't uploaded images directly from laptop to this forum.. I don't have the images on a public server, but basically graphs are described in...

I would NOT take a troublesome db offline !!!! ( unless pss tells me to )

I must have overread it, but anyway here's my primitive Q:

- Does your service account...

So, that's what do you get when suffering a SQLServer overdose at SQLpass ... Pantoriosis

😀

G'night y'all

My second place to check would also be io/ram related.

Any hints in the windows evenlog files ?

Are there other startup processes on these boxes ? (that have the need for...

Roy Ernest (10/17/2011)

---

Jack Corbett (10/17/2011)

---

SQLRNNR (10/17/2011)

---

Evil Kraig F (10/17/2011)

---

Thanks for the link to that Gail, everyone in the office was wondering if I was dying slowly as I'm trying not...

best is to set a different value for min and max server memory.

SQLserver can have issues when these values are equal.

If this is a dedicated box, why would you enforce...

Roy Ernest (10/17/2011)

---

Back to work after the summit. It was a pleasure to meet everyone there. I had a blast. Once again Jeff, Johan and me did some sight seeing...

Perry Whittle (10/17/2011)

---

ALZDBA (10/17/2011)

---

Perry Whittle (10/11/2011)

---

Oracle...