Check the SQL in the stored procedures, make sure he is using the most efficent SQL Possible, Verify the indexes used , make sure he's not querying unnecessary fields, stuff like that. If the SQL is poorly written no ammount of memory can polish it.