How to find??? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to find???

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…"
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…"
When you edit your original question, I think you can move it to another section. I’m not sure, but can you try it? —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
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…"
Hm, I always thought that it is possible for a user to change the section.
What section do you think is more appropriate? —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
"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…"
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>
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…"
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
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…"
]]>