Policy based management.

No it doesn't break the log chain. A full backup contains only enough transaction log necessary to be able to restore that database to a transactionally consistent time - the...

Check the throughput of the SAN system as well as configuration of HBA queue depth.

See the virtual file stats if there are high IO read and Write stall( sys.dm_virtual_file_stats).

Capture IO,...

Please read the link i posted..

Yes.. Initially it creates a database file and initialize it to zero. In your case the first restore took long time as it has to create a data file and...

Take the copy_only backup whenever you require without breaking the log backup and do testing at your test server.

I agree with gail you will not get any gain if the database have more than one log file. Sql server writes and fills transaction log the file sequentially where...

Give me more information about what is the table structure and clustered index key and non clustered index built on it. If the clustered index key long and it is...

If the instant file initialization is not enabled then before restoring the data sql server zeroing out the data file and start process the restoration. Try enable the instant...

Hi,

Check sp_whoisactive procedure after running the above statements. It will tell you which session id is blocing the table.

OR

U can check the information sys.dm_tran_locks to see if there...

Thanks all

Please find the below link.

http://www.sqlskills.com/BLOGS/KIMBERLY/post/Companion-content-for-Chapter-6-%28Index-Internals%29-of-SQL-Server-2008-Internals.aspx