you can read this

http://technet.microsoft.com/en-us/library/ms142560.aspx

i'm running SQL profiler into production for only RPC:completed et SQL:batchcomplete for every queery more then 500 ms into my production server and is low impact into performance.

depend with san you have but is possible use clone drive to connect your SQL on this clone on same SAN. and reuse the Same clone id each time you...

other solution is use to SAN BOX whith replication like netapps or equalogics solution is verry fast replication depending if you are on lan or Wan replication.

is totaly different aproche...

i'm using this script

Const FILE_NAME = 0

folder = "\\zz60\d$\SQLBackupTemp\"

'get files name into folder

Set objShell = CreateObject ("Shell.Application")

Set objFolder = objShell.Namespace (folder)

For Each strFileName in objFolder.Items

'pour chaque fihier...