teodor76
asked on
sql server 2008 and sql server 2008 R2....
I would like to find the number of sql server 2008 and sql server 2008 r2 between 150 sql servers on our domain and then I would like to find which sql server 2008 and 2008 R2 were installed in 2010 and 2011? after finding these servers, I need to determine how many cpu do each server have on it? I think to determine the numbers of cpu, I should log in on each server then find them from task manager? how can I achieve this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I'd like to suggest Policy Based management. You won't get exact number of processors but you could audit server with processors number >,< or = some value (see Server facet, @Processors value):
Using Policy-Based Management in SQL Server 2008
Policy-based Management in SQL Server 2008
Administering Servers by Using Policy-Based Management
Tutorial: Administering Servers by Using Policy-Based Management
Or you can use registered servers and query them by using:
SQL Server 2005 - Registered Servers
Using Policy-Based Management in SQL Server 2008
Policy-based Management in SQL Server 2008
Administering Servers by Using Policy-Based Management
Tutorial: Administering Servers by Using Policy-Based Management
Or you can use registered servers and query them by using:
exec xp_msver 'ProcessorCount'SQL Server 2005 - Registered Servers
ASKER
where can I find installation logs? I think I can find that which date and time were these servers installed?
It is located at %programfiles%\Microsoft SQL Server\100\Setup Bootstrap\Log\.
http://technet.microsoft.com/en-us/library/ms143702.aspx
http://technet.microsoft.com/en-us/library/ms143702.aspx
@teodor76: any luck with above suggestion?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
To discover SQL Servers
http://ryanfarley.com/blog/archive/2003/11/11/218.aspx
If you want to look for "instances installed" then you may want
to try SQLPing or SQLRecon at
http://www.sqlsecurity.com/Tools/Fre...5/Default.aspx
which will use various methods to determine what instances are running on the network.