Hardware congifuration of SQL Server
How do I check SQL Server (Windows 2003)'s hardware configuration?
Are there t-sql commands to check that?
If not, where in the server can I go to understand what kind of SAN, RAID we have on the server.
Thanks.
Are there t-sql commands to check that?
If not, where in the server can I go to understand what kind of SAN, RAID we have on the server.
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
that worked, thanks
ASKER
so, there's no t-sql commands for checking on hardware, right?
The t-sql command for device listing is not a standard but you could call .NET assembly as user defined function directly from SQL 2005/2008. The hardware enumeration is a standard Windows API call.
Some example is e.g. here: http://www.developer.com/net/csharp/article.php/3399881 and here: http://www.codeproject.com/KB/system/DevMgr.aspx
Some example is e.g. here: http://www.developer.com/net/csharp/article.php/3399881 and here: http://www.codeproject.com/KB/system/DevMgr.aspx
2) Execute Sysinfo32.EXE
Device Manager needs admin rights. Sysinfo32 is not necessarily present on each computer.