SQL Server Performance

what is LUN?

Discussion in 'General DBA Questions' started by ranjandba, Dec 22, 2005.

  1. ranjandba New Member

    what is the meaning of LUN in sql server 2000?How can i measure the LUN size of particular database?
  2. Luis Martin Moderator

  3. surendrakalekar New Member

  4. satya Moderator

    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.
  5. ranjandba New Member

    yes satya i want to measure each database size and growth rate for every month
  6. satya Moderator

  7. ranjandba New Member

    what is the use of "sp_msforeachdb" stored procedure.How can i execute this procedure?
  8. FrankKalis Moderator

    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 />
  9. satya Moderator

    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.

Share This Page