Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scottpt
Posting Yak Master
186 Posts |
 Posted - 2005-03-21 : 13:19:59
|
| I need sql to pull 1) Physical memory2) Drive Sizes3) # of cpus4) speed of cpus.Need this so I can document our 80 servers quickly. I have them all linked so I can run the query from one machine to pull the data. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-21 : 13:41:36
|
| Not an easy one for SQL Server...You are going to have to read the registry for this information via xp_regread. You can get free space of drives from xp_fixeddrives. For number of CPUs, HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager. For other information though, you'll have to search to find out where it is stored.You should be using a package to gather this information for you and not SQL Server. Do you not have monitoring tools that can provide this information?Tara |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-03-21 : 13:55:54
|
| What kind of servers are these? Most server provide a reporting functionality for this. It will let you, from a central location, pull this information for all servers in the enterprise. HP, DELL, IBM, etc all support this. In addition, you can then export the information.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2005-03-22 : 09:17:28
|
| We have multiple vendors. MOstly Compaq, but also have IBM, HP and Dell |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-03-22 : 10:05:11
|
| All of the named vendors have this ability. There's no reason to write anything for this. Have you looked at MOM?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2005-03-23 : 09:52:02
|
| xp_msver N'PhysicalMemory'goxp_msver N'ProcessorCount' |
|
|
|
|
|
|
|
|
Easy One