Check Egenera blade technology servers(http://www.egenera.com). The beauty is you can fix or allocate the resourses based on your

needs like (2 cpu to SQL server, 1 CPu to...

http://msdn2.microsoft.com/en-us/library/ms188396.aspx

Hi ,

Check that SQL is using the RAM properly after enabling the AWE option.

--Total amount of dynamic memory the server is currently consuming

select object_name,counter_name,'Amount of memory used in(GB)'=convert(float,(cntr_value))/(1024*1024),cntr_value from master.dbo.sysperfinfo

where...

Hi Rick,

You can use the Microsoft e-learning courses which are free for the time being and are pretty good to start with.

https://www.microsoftelearning.com/catalog/ITProDev.aspx#sqlServer

And as always my favourite BOL 2005.

Hi,

Have you recently put SP4 and the hotfix (and AWE enabled)

I recently upgraded my production server and log shipping server with SP4 and hot fix 899761(but AWE...

• Log in with the SQL server serive account to the box.
• Make sure you create a outlook profile with this account.
• Open the SQL agent properties
• select the outlook profle name in...