Not sure I agree, too many unknown variables.

I would take a well run, well maintained SQL Server machine that was remote over a poorly run, un-maintained SQL Server machine that...

Andrew,

I think that you are really going to have to work with their networking group to make sure that traffic is allowed out on the required port.

If this...

... it will be grayed out before you make any changes, but the tool-tip should still pop up on hover.

-Dan B

Hey Frances,

Yes, from the design window, the leftmost icon on the design toolbar should be the Save Changes Script. It looks like a little disk with a piece of...

Hello,

Could it be a permission problem with the SQL Server Agent account? Could it be a problem accessing a remote system?

Sincerely,

Dan B

Perhaps the easiest thing to do is to make the change you want in Management Studio but don't click save. Then click the button at the far left to...

You could set up monitoring to watch tempdb or data/log space used and have it send you alerts when the threshold you set is met.

Sincerely,

-Dan B

Congrats everybody - good essays!

Props for the Haiku, by the way...

-Dan B

I think that is a good point and certainly addresses the performance problem that brought this to light, but I find it hard to believe that page life expectancy can...

Yeah... that's what I was afraid of... 🙂

I'll post back if there are any updates.

Thanks again.

Sincerely,

Dan B

I'm not sure that I am using the table properly, but I think it is sufficient for my needs to just repeatedly check the values in sysperfinfo. This is...

Thanks for the input.

Users are certainly hitting this server. When certain application routines are run, I can watch page life expectancy drop from the thousands to the tens. ...

Physical Memory - 1 GB

Min/Max Memory in SQL Server - 4/2,147,483,647

Target (Avg) - 461,903

Total (Avg) - 70,550

More info...

After I run my script to create the plan and the job, if I check properties of the job first, it works fine. However, if I open the...

Thinus,

Did you ever find a resolution for this problem?

I am attempting something very similar and get the same results.

I can create the maintenance plan and I can create the...