So just to clarify if the maximum memory allocation is set to 3 Gb then SQL Server shouldn’t exceed this amount, even if AWE isn't enabled ?

Hello should have mentioned that the SQL server is 64 bit on a 64 bit Windows Server. Does this alter your answer ?

Anyone able to give me some help on this ?

If I could persuade them to drop the requirement to house the servers in different locations and rely on the inhouse generator, would clustering fufill the other points?

That was the error raised from checkdb on msdb.

I ran a check db on the msdb database (At the point when the server was at it's least highest level of usage) and recieved the following error message:

Msg 1823,...

Ninja's_RGR'us The SQL server instance effectively stops accepting connections to the Server. This is resolved by a stop and restart of the server.

I created a job which monitors the...

Thx for your reply. I could do but that will stop the application working which is not the intent of what I am trying to achieve. I am effectively attempting...

Thanks for the prompt help. This is what I am doing at the moment.

Unforunately this application is creating a number of connections and then not closing them. I am...

Thanks. I was wondering though is it possible to set a different level of parrellism at database level rather than server level ?

Thank you all very much for your brilliant replies. One final question I have had a look around but cannot find how I determine which objects (tables etc) are...

Assuming I could convince the business that some downtime was required, is there a better way to do this ?

They are all in different filegroups

This is the details of the data files:

File Size Space Left

D:\46 GB 130 GB...

thanks for the reply but global knowledge don't do 2008 and learning tree do a course but it not with the Microsoft MCTS SQL Server 2008, Implementation and Maintenance...