I'm NOT seeing these warning messages when I restart the nodes in below order:

Restart Node1 (Active)

Restart Node2 (Active)

Restart Node3 (Passive)

If I did not follow the above order to restart the...

Thank you

I have set the SQL Server services Start up mode in cluster environment as below:

sql server --manual

sql server agent--manual

sql server fulltext search --manual

sql server integration services--Automatic

sql server browser --automatic

Please...

Thanks Steve,

We are using maintenance plans for Maintenance tasks, so we need SSIS

and we do not need SSRS & SSAS and I already skipped those. But my question is about...

Hi Gail,

Do we need to enable lock pages in memory option on Passive node too?

please advice

thanks in advance

Thank you,

We have a one more 3 node cluster setup & we restarted the nodes after some windows maintenance (this is the 1st time we rebooted the nodes after the...

Could you please point me to...

Hi Gail,

I have followed the below link to enable lock pages in memory (Is the right method to enable lock pages in memory?)

http://msdn.microsoft.com/en-us/library/ms190730%28SQL.90%29.aspx

We have 3 node a/a/p cluster...

Thanks Jeff, It's really helpful

I went through the link http://support.microsoft.com/default.aspx/kb/899000?p=1

But here is the scenario: We have 3 instances for BizTalk on Same SQL Server as below:

On instance 1,...

Finding memory pressure for a particular instance:

I ran the below query to investigate the memory pressure on the server.

select r.ring_buffer_address,

r.ring_buffer_type,

dateadd (ms, r.[timestamp] - sys.ms_ticks, getdate()) as...

I went through the link http://support.microsoft.com/kb/139609 and it says:

Is this applicable to Windows 2003 R2 X64 with SP2 too (It...

All the instances are for Biz Talk and the BizTalk databases are very small. The max database size that we have is 4 GB.

But PLE<300 coming once in a...

A

re you seeing deteriorating performance?

As

Your memory available could be a result of the AV and max memory setting on your SQL instance.

I suggest you go ahead and do the...

It's a separate Sevres for SQL Server. No other applications installed except Anti...

If this is the problem...

Yes, I ran the profiler and from the results I did NOT see any connections to the log shipped content databases (In recovery...