Spiritual support is also acceptible. But when you do get back into gaming... @=)

It's not services you necessarily have to worry about. It's all the little things, like Linked Servers, jobs or SSIS packages that specifically call those accounts, etc.

The only way to...

Are your servers within the same domain and both inside the firewall?

If not, is your firewall open to the ports being used in the mirroring?

Crashes as in it brings SSMS down or freezes SSMS or what?

Describe what happens step-by-step please.

Do these password changes...

I don't use Data Mirroring so I couldn't even begin to answer that question. Sorry.

I don't use proxies, so I'm just guessing that your problem is the underlined one...

This is what I found in BOL.

Books Online

---

SQL Server Agent proxies use credentials to store information...

I...

SP4? Whoohoo!

And here I thought they weren't planning any more SPs for 2k5.

That's Microsoft standard warning on all hot fixes and CPs. They don't want to take responsibility for Bad Things happening to your server if you put something on it that...

RE: Lock Pages in Memory. We have it set on our prod server and it hasn't caused any problems. I've never heard of the situation you've referenced, though.

Just keep watching it. Also, write down what times of day you're seeing this stuff happen. Maybe it's happening at the same time every day and that'll help you narrow...

Glad we could help. Let us know if you need anything else.

You have to make sure both are running at the same time. When both are done, open up Profiler and import the server side trace. Then go to File ->...

You really should run PerfMon and a server side trace to determine at what point the cache is eating the memory and to see if it's even related to SQL...