Solved

Hardware congifuration of SQL Server

Posted on 2009-07-10
5
219 Views
Last Modified: 2012-05-07
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.
0
Comment
Question by:anushahanna
  • 3
  • 2
5 Comments
 
LVL 41

Expert Comment

by:pcelba
Comment Utility
1) Right click Computer and select Properties. If the properties window appear click on Device Manager.
2) Execute Sysinfo32.EXE

Device Manager needs admin rights. Sysinfo32 is not necessarily present on each computer.
0
 
LVL 41

Accepted Solution

by:
pcelba earned 500 total points
Comment Utility
Sorry, small correction:

2) MSinfo32.EXE
0
 
LVL 6

Author Comment

by:anushahanna
Comment Utility
that worked, thanks
0
 
LVL 6

Author Comment

by:anushahanna
Comment Utility
so, there's no t-sql commands for checking on hardware, right?
0
 
LVL 41

Expert Comment

by:pcelba
Comment Utility
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

0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now