Sorry, that refers to the location of the Default Trace. Also the previous query has the database name set there.

Run the following to find the default trace and...

Trace flag 845 needs to be enabled in standard edition for LPIM to work.

I'd say you need to restart the SQL instance. Also is it Enterprise Edition?

Is it SQL Enterprise edition?

Run this select * from sys.dm_os_process_memory

Is there a non 0 value for locked_page_allocations?

From http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

SELECT

loginname,

loginsid,

spid,

hostname,

applicationname,

...

Neither of those backup types exist in SQL server. You have Full, Differential and Transaction Log backups only.

An incremental backup would be a Windows based file backup that only...

The RAID 5 will obviously be slower, so you'll need to be careful, especially with tables that are written to quite a lot.

You could move the non-clustered indexes...

Check wait statistics. Is SQL the only software installed on the server?

For the SQL trace, what sort of logical IO are you seeing?

7 second queries are quite slow...

But memory usage is tied mostly to the buffer pool for your database. You can check the amount of memory assigned to a session which is currently connected though:

SELECT

...

SQL will buffer as much as it can according to the Max Memory setting.

To check which database is using most of the buffer pool, run the following query from http://www.mssqltips.com/sqlservertip/2393/determine-sql-server-memory-use-by-database-and-object/

--...

After the power plan and server settings (including any global trace flags), compare the execution plans and IO statistics

You cannot perform an in-place upgrade of a clustered Windows 2003 server to Windows 2008 (R2).

You can't cluster between different versions of Windows. Not only that, you will need to rebuild it anyway since you're starting from scratch by installing a new OS.

sp_helpdb is good to run manually to view db information, but no good for storing in a table for later comparison. It returns the database size as a char...

Is your your Windows logon account a domain account or local Windows account? You'll need to add it (or a group you are a member of) to SQL Server...