SQL Server Performance

How to find???

Discussion in 'Performance Tuning for Hardware Configurations' started by ramkumar.mu, Jun 18, 2006.

  1. ramkumar.mu New Member

    How to find the following in a server...

    CPU L2 Cache
    Total Number of Physical Drives in Each Array
    Total Number of Physical Drives in Each Array
    RAID Level of Array Used for SQL Server Databases
    Location of Swap File
    Number of Disk Controllers in Server
    Type of Disk Controllers in Server
    Size of Cache in Disk Controllers in Server


    I am having user access to the server. is that possible to find the above values without admin access???

    Thanks,
    Ram

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

    i think i have posted this question in the wrong area.

    Moderators, can any one of you move this under the appropriate topic???


    Thanks,
    Ram

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

  4. ramkumar.mu New Member

    Frank,<br />i didnt find any option to change the topic. As far as i get replies and answers for the topic, i am not gonna worry about the topic [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />Thanks,<br />Ram<br /><br />"It is easy to write code for a spec and walk in water, provided, both are freezed..."
  5. FrankKalis Moderator

  6. ramkumar.mu New Member

    "Performance Tuning for Hardware Configurations"<br /><br />I see here lot many words like RAID, ARRAY etc.. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br /><br />Thanks,<br />Ram<br /><br />"It is easy to write code for a spec and walk in water, provided, both are freezed..."
  7. FrankKalis Moderator

    There you are. [<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>
  8. ramkumar.mu New Member

    Thanks...[<img src='/community/emoticons/emotion-1.gif' alt=':)' />] but Xpecting some answers [<img src='/community/emoticons/emotion-6.gif' alt=':(' />]<br /><br />Thanks,<br />Ram<br /><br />"It is easy to write code for a spec and walk in water, provided, both are freezed..."
  9. joechang New Member

    for most of the above, learn to do WMI scripting, that is, go to the Microsoft web set, and search "WMI"

    for the RAID related info, use muse use the tool provided by the RAID vendor
  10. ramkumar.mu New Member

    oh! cant we do that without third party tools??? i thought there must be a simple way like right click my computer and so on... [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />Thanks,<br />Ram<br /><br />"It is easy to write code for a spec and walk in water, provided, both are freezed..."

Share This Page