Bhuvanesh,

Socket is the basic unit of hardware to hold processing units. Say if you have dual-core, then you mean 2 processing units in 1 socket. "SQL_Server_2012_Licensing_Reference_Guide".Google this search.The pdf is...

Did you able to check what session/process is blocking alter statement by running sp_who2?

Guess you are using "Generate Script" in ssms.

Ensure you have selected "Script Logins" and "Script Object-level permission" to TRUE( they are in Advanced option).

Please verify your upgrade process with this link.

http://msdn.microsoft.com/en-us/library/ms191295(v=sql.105).aspx

Yes, You can do it as long as mdf file should reside in different path from the original mdf file.

Use either sp_attach_single_file_db (deprecated feature) or CREATE DATABASE FOR ATTACH.

Where did you see this? Did you properly do "Add Node" in passive node?

We were examining plan cache size. Actually cache size of most of the adhoc queries are more than 40KB. We are working to convert them either parameterized or SPs.

Thanks Gail.

Google it sp_spaceused.

I would prefer a clean Sql Server shutdown , not by just windows shutdown.

http://www.sqlservercentral.com/Forums/Topic667203-146-1.aspx

Try to use Central Management Server.

http://msdn.microsoft.com/en-us/library/bb934126(v=sql.105).aspx

Sure,

http://msdn.microsoft.com/en-us/library/cc645993(v=sql.105).aspx

Also edition of mirrored server plays a significant role when it comes to synchrnoization.Enterprise editon will use "Parallel redo" using more threads available to mirroring session If you have more...

Yes, modifiying min or max server memory will flush cache memory.

Full database backup will not reduce Tlog size.

Have you verified the status of...

Do you take tape backup? What are the wait types your backup session is hanging on? Check with your backup team to verify the backup throughput (mb/secs).