Since you didnt provide info on your current backup strategy, have a read through the following and see if it applies.

http://support.microsoft.com/kb/321836

ELSE....(hehe)

provide more information on what and when you backup with...

might want to add:

High CPU, Memory and disk utilization....log percentage used....

Change in DB Status (Online -> offline/Single_User etc..)

Is it a scheduled Job, or part of your maintenance plan?

Scheduled Job?

Have a look at the steps, you'll see all the properties if its T-SQL Based commands, and you'll have...

As far as I know, it's 1 temp datafile per CPU Core....

I agree with Gail, leave your CPU Affinity to default, and rather set your memory usage if you need...

Just as a test, change the account to a domain admin account, and see if the agent starts automatically.

Have you checked your...

Full path on my workstation:

"C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn\SQLAGENT.EXE" -i MSSQLSERVER"

check the account that you specified to start the service first, sounds like you have a permission issue....

Whats your current settings?

Properties tempdb, Files, and have alok at our current config please.

remember to set AUTOGROW by a fixed MB size, and not percentage...

Have the same setup running live in my environment, no issues except of course the extra load on the Server.

I'll have to agree with Randolph, prices seems unrealistically high for smaller companies in South Africa, who need the ent, and all the bells and whistles offered.

I am not too...

Hi Gail

Sent it to the Members@sql******.co*** address as instructed on the SASSUG site, to subscribe.

I'll sent you a pm just in case.

Thanx Gail, sent the mail.

Looking forward to the sessions.

GilaMonster (1/12/2010)

---

Henrico Bekker (1/11/2010)

---

I know this is a bit off topic, but somehow relates..

Except for Gail's workshops every now and then, are there any other and more regular events in...

Thank you, will have a look.

Thank you, will have a look.