Check: http://www.sql-server-performance.com/jc_sql_server_backup_performance_with_imceda_litespeed.asp Luis Martin Moderator SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important Bertrand Russell Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte All postings are provided “AS IS†with no warranties for accuracy.
Logical Unit Number (LUN) http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_asphosting.asp Surendra Kalekar
Ranjan Why do you want to measure the LUN? DO you have any issues with the current Transaction log backups or sizes lately? Satya SKJ Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Then take help of below articles to manage the show: http://www.databasejournal.com/features/mssql/article.php/3339681 http://vyaskn.tripod.com/track_sql_database_file_growth.htm Satya SKJ Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
This is an undocumented procedure in the master db. You can have a look at the code there, then you'll see what it does. But its' name speaks for itself. [<img src='/community/emoticons/emotion-1.gif' alt='' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />
SP_MSFOREACHDB is an undocumented stored procedure that can help to execute any statement against all database on a sQL server, but be aware this can be deleted or changed in the future releases of Service pack or a hotfix. Satya SKJ Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
