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...

All,

This is a duplicate thread. Responses can be found at Fatal Error.

Yeah, well, I tried to be nicer about that point in my first point on this thread.

Well the OP isn't clear if the second server is on the cluster or not. I'm just assuming that's what (s)he meant.

But it wouldn't be the first time this week...

You can log ship to a server that has no instance?

I thought log shipped databases were in a state of Recovery? I thought they needed an instance to reside on....

Active / Active has a SQL instance on both nodes. Active / Passive has the instance only on one node. If you have instances on both nodes, you're running A/A...

It amazes me that someone would expect you to restore backups with no alternative cataloging system to identify this information. Automated backups through the maintenance plan or a third party...

Depends on what kind of cluster you have set up. If it's Active / Active, then yes, you shouldn't have a problem. If it's Active / Passive, you have a...

Job_ID is not an int. You have to use uniqueidentifier or char / varchar data types for your variable.

EDIT: And yes, what you want to do is possible. Just adjust...

Google that first sentence. There are tons of responses from 2008 and 2009.

First one on the list is this one about 64 bit OS patches.