Imo, You can test up to a maximum of 30 days as passive nodes can function as active server for a maximum of 30 days.

http://www.google.com/url?sa=t&source=web&cd=3&ved=0CCQQFjAC&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2F1%2Fe%2F6%2F1e68f92c-f334-4517-b610-e4dee946ef91%2F2008%2520SQL%2520Licensing%2520overview%2520final.docx&rct=j&q=sql%20server%202008%20licensing%20explained%20site%3Amicrosoft.com&ei=VpfaTavOHtKGhQfy9IDYBg&usg=AFQjCNG-uwJLVzdsMDmXMjfsjof5SGObzA&sig2=x-k_FxVbKANqeCN3Ie3q-A&cad=rja

Doesn't categorically states primary should be...

lyle.schow 28602 (9/17/2015)

create scripts ot create the database objects needed in on the new server, attach the databases to the new server, then run the scripts to create the objects...

Depends on what kind of features you want to...

The windows account you are using is not recognized on the SQL instance you are attempting to login.

Please check if you are using the correct windows account to log...

2 options.

1) SQL Server errorlog - Gives detailed info on the failover from primary to secondary

2) On Always dashboard look for "View Always on Health Events" at the right hand...

Did you include step level output?

Anyways, can you check if checkdb completed for all databases at the scheduled time via SQL Error log?

May I know why opted for such a method... was that because it was on recovery pending after always on failover?

Was it just one db on always on group that...

Most likely it is still in recovery rolling forward the entries from t log..

run the following query and pay attention to the columns last_redo_time,last_harden_time, suspend_reason_desc

select replica_server_name as servername,db_name(database_id)...

Do configure the log to write to a text file to get the full error message. meanwhile, you may also check the SQL Server error log to see if the...

From SQL layer, its hard to track a sequential or random I/O. Refer to the link below for a good explanation.

http://sqlblog.com/blogs/linchi_shea/archive/2011/04/01/there-are-no-sequential-or-random-disk-i-os.aspx

Though I couldn't exactly get what you are doing in the package, the error message states that

Login failed for user 'nice\rmX$'. Connection name : rm.rm

Can you verify the connection...

Yes, I agree that MTL wouldn't totally account for all the missing memory. Just wanted to point out that, it is not covered in os_memory_clerks.

If my guess is right, the reason could be this.

physical_memory_in_use_kb shows the total memory usage of SQLServer process which includes Buffer pool + Memory to Leave (MTL) area.

Sum of...

Microsoft has already published an eBook for Always on troubleshooting.

http://www.google.com.sg/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&uact=8&ved=0CBwQFjAAahUKEwjK4dKrgt3HAhVGkZQKHUj0C38&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2F0%2FF%2FB%2F0FBFAA46-2BFD-478F-8E56-7BF3C672DF9D%2FTroubleshooting%2520SQL%2520Server%2520AlwaysOn.pdf&usg=AFQjCNGKDG-zRs_NpdDO3djlT3kn_MxhBg

Besides these, refer Microsoft white papers ( 3 of them ) on Always on itself , to get a clear...

Step 1 : Run the script I posted above.

Step 2: Try to find the...