SQL Server Performance

Database properties...

Discussion in 'General DBA Questions' started by ramkumar.mu, Aug 2, 2006.

  1. ramkumar.mu New Member

    How can we see the database properties (at which drive mdf is stored, total size/unrestricted growth etc) of tempdb?
    I cant see the properties from the enterprise manager. is there any command to do it from query analyzer?



    Thanks,
    Ram

    "It is easy to write code for a spec and walk in water, provided, both are freezed..."
  2. Roji. P. Thomas New Member

  3. deepakontheweb New Member

    and if you do not provide database name with sp_helpdb, it will give you general information about all databases.. except database file informations.<br /><br /><img src='/community/emoticons/emotion-2.gif' alt=':D' /><br /><br />Deepak Kumar<br /><br />--This posting is provided “AS IS” with NO rights for the sake of knowledge sharing.
  4. FrankKalis Moderator

    Not always. [<img src='/community/emoticons/emotion-6.gif' alt=':(' />]<br /><pre id="code"><font face="courier" size="2" id="code"><br />sp_helpdb<br /><br />Server: Msg 515, Level 16, State 2, Procedure sp_helpdb, Line 53<br />Cannot insert the value NULL into column '', table ''; column does not allow nulls. INSERT fails.<br />The statement has been terminated.<br /></font id="code"></pre id="code"><br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br />Webmaster:<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>
  5. Roji. P. Thomas New Member

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><br /><img src='/community/emoticons/emotion-2.gif' alt=':D' /><br /><br />Deepak Kumar<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Guess I heard this name somewhere [:I]<br /><br />Roji. P. Thomas<br /<a target="_blank" href=http://toponewithties.blogspot.com>http://toponewithties.blogspot.com</a><br />
  6. FrankKalis Moderator

    Look at his profile. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br />Webmaster:<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>
  7. Roji. P. Thomas New Member

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by FrankKalis</i><br /><br />Look at his profile. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />I was kidding there Frank. He is my friend and fellow MVP from India <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />Roji. P. Thomas<br /<a target="_blank" href=http://toponewithties.blogspot.com>http://toponewithties.blogspot.com</a><br />
  8. FrankKalis Moderator

    Oops, didn't catch that joke. Looks like you guys from India are taking over here. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br />Webmaster:<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>
  9. satya Moderator

    Roji & Deepak
    Why don't you guys change the signature to state your MVP status... for uniqueness.

    Satya SKJ
    Microsoft SQL Server MVP
    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.
  10. ramkumar.mu New Member

    quote:Originally posted by Roji. P. Thomas

    sp_helpdb 'tempdb'

    ?

    Roji. P. Thomas
    http://toponewithties.blogspot.com


    I missed the database name and it was not showing me the required information. this is where i miss... Thanks Roji and Deepak

    Thanks,
    Ram

    "It is easy to write code for a spec and walk in water, provided, both are freezed..."
  11. deepakontheweb New Member

    Not exactly.. You are the great Champ.. [<img src='/community/emoticons/emotion-2.gif' alt=':D' />] [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by FrankKalis</i><br /><br />Oops, didn't catch that joke. Looks like you guys from India are taking over here. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br />Webmaster:<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 /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />Deepak Kumar<br /><br />--This posting is provided “AS IS” with NO rights for the sake of knowledge sharing.
  12. deepakontheweb New Member

    Yeah Sure, [^][<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by satya</i><br /><br />Roji & Deepak<br />Why don't you guys change the signature to state your MVP status... for uniqueness.<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Contributing Editor & Forums Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided �AS IS� with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />Deepak Kumar<br /><br />--This posting is provided “AS IS” with NO rights for the sake of knowledge sharing.
  13. FrankKalis Moderator

  14. deepakontheweb New Member

    Check this link<a target="_blank" href=http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=8832#39496>http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=8832#39496</a> You can correct it. [8D]<br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by FrankKalis</i><br /><br />Not always. [<img src='/community/emoticons/emotion-6.gif' alt=':(' />]<br /><pre id="code"><font face="courier" size="2" id="code"><br />sp_helpdb<br /><br />Server: Msg 515, Level 16, State 2, Procedure sp_helpdb, Line 53<br />Cannot insert the value NULL into column '', table ''; column does not allow nulls. INSERT fails.<br />The statement has been terminated.<br /></font id="code"></pre id="code"><br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br />Webmaster:<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 /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br /><b>Deepak Kumar</b><br />MVP, MCDBA - SQL Server<br /><br /><i>Disclaimer: This post is provided as is with no rights & warranty for accuracy, for the sake of knowledge sharing only.</i>
  15. FrankKalis Moderator

    Thanks! I'll pass this problem on to our DBA. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br />Webmaster:<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>
  16. Roji. P. Thomas New Member

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by FrankKalis</i><br />Thanks! I'll pass this problem on to our DBA. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />You are not one?<br /><br />Roji. P. Thomas<br /<a target="_blank" href=http://toponewithties.blogspot.com>http://toponewithties.blogspot.com</a><br />
  17. FrankKalis Moderator

    No! Look at my profile. I'm not even working in the IT department. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br />Webmaster:<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>
  18. Roji. P. Thomas New Member

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by FrankKalis</i><br /><br />No! Look at my profile. I'm not even working in the IT department. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Thats interesting, because I work for one of the largest web based asset management platform provider <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />Roji. P. Thomas<br /<a target="_blank" href=http://toponewithties.blogspot.com>http://toponewithties.blogspot.com</a><br />
  19. FrankKalis Moderator

    It's a small world indeed. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br />Webmaster:<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>
  20. Roji. P. Thomas New Member

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by satya</i><br /><br />Roji & Deepak<br />Why don't you guys change the signature to state your MVP status... for uniqueness.<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />DONE <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />Roji. P. Thomas<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://toponewithties.blogspot.com>http://toponewithties.blogspot.com</a><br />
  21. ramkumar.mu New Member

    What I have to do to include the signature (Microsoft SQL Server MVP) below my name???

    Thanks,
    Ram

    "It is easy to write code for a spec and walk in water, provided, both are freezed..."
  22. ghemant Moderator

    Hi Ram,
    to include the signature like gurus here in our SSP one has to contribute his / her expertise in newsgroup / thrid party forums (these activity is monitored by MS) , in INDIA one has to fill the nomination form for MVP award and MS then contact if you are eligible,this award given by MS to those who contribute the community with their expertise.

    Refer more on MVP athttp://www.microsoft.com/india/mvp/

    HTH
    Regards

    Hemantgiri S. Goswami
    ghemant@gmail.com
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami
    ------------------------
    http://hemantgirisgoswami.blogspot.com
  23. ramkumar.mu New Member

    Thanks Hemant.

    Thanks,
    Ram

    "It is easy to write code for a spec and walk in water, provided, both are freezed..."

Share This Page