I  think you did answer your question. you do agree that to take advantage of AWE, you should have a max server memory of 3 GB or greater. right !....

You can get admin privilege on the machine and if you have not revoked access to the BUILTIN\ADMIN group, you should be able to get into SQL server and then...

The below should work perfectly fine.

inst1 - 4gb

inst2 - 4gb

inst3 - 1gb

inst4 - 1gB

 Let us know what kind of behavior you see after re-allocating the memory.

Its actually 7-4.0. The 4.0 gig is the combination of kernel mode + usermode. The additional memory would be available as physical extensions to the existing memory. Note that this...

David,

I totally agree with you. Active/Active is not a load balancing solution.

I think rcavill has explained Active/Active nicely. it gives you redundancy at the hardware level and os level.

The...

Check if the article below helps.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_0ijm.asp

If you are planning to use more than 4 GB of memory, you cannot add up all the memories assigned to various instances and sum up to the total amount...

Check the article below.

http://support.microsoft.com/default.aspx/kb/310834

It seems you might be having some hardware issues.

select user_name(b.uid)as username ,object_name(id) as objectname , case when action = 26  then 'References'

      when action = 178 then 'CREATE FUNCTION'

when action = 193 then 'SELECT'

when action = 195 then...

Can you try closing your Enterprise Manager Session and opening it back. Also Can you run sp_helpdb in query analyzer and see if the database comes up.

I think you might have figured this out by now but just a side note that the time recorded in the cluster log is displayed in GMT.

Just a thought. When you failover SQL server, the services gets re-started. With your system coming back up after a failover, its possible that there might be some open transaction...

One of the possible reasons why the database is in suspect mode is that there is not enough space for the transactions to be committed/rollbacked. You can copy the data...

A clustered index scan is the same as a table scan. Note that this is different than index seek. An index seek is only performed on the column on which...

Frank,

Heartly Congratulations. One more reason why SQLServerCentral is considered one of the better sites on the web.