1

Topic: Whether it is possible with the help ms sql to collect the given configurations of the server on which costs ?

Whether it is possible with the help ms sql to collect the given configurations of the server on which costs ?
I want  a configuration of servers, it would be desirable to obtain such data on processors, storages, disks.
Gather given to write in a label.

2

Re: Whether it is possible with the help ms sql to collect the given configurations of the server on which costs ?

Google helped to find only for Orakla)
http://www.sql.ru/forum/401168/kak-polu … ki-servera

3

Re: Whether it is possible with the help ms sql to collect the given configurations of the server on which costs ?

- Write a system script, launch it through xp_cmdshell interposing the data into the table
- Write powershall a script, launch it
Whether

odisssey wrote:

it is possible with the help ms sql to collect the given configurations of the server on which costs ?

and why through a sequel,

4

Re: Whether it is possible with the help ms sql to collect the given configurations of the server on which costs ?

wrote:

- and why through a sequel,

Some tens  under observation. Collected them in local server groups and  requests at once to all server group.

5

Re: Whether it is possible with the help ms sql to collect the given configurations of the server on which costs ?

https://docs.microsoft.com/en-us/sql/re … ansact-sql
SQL Server Operating System Related Dynamic Management Views (Transact-SQL)
For example;
SELECT * FROM [master]. [sys]. [dm_os_sys_info]
SELECT * FROM [master]. [sys]. [dm_os_windows_info]
SELECT * FROM [master]. [sys]. [dm_server_services]

6

Re: Whether it is possible with the help ms sql to collect the given configurations of the server on which costs ?

rykl wrote:

https://docs.microsoft.com/en-us/sql/re … ansact-sql
SQL Server Operating System Related Dynamic Management Views (Transact-SQL)
For example;
SELECT * FROM [master]. [sys]. [dm_os_sys_info]
SELECT * FROM [master]. [sys]. [dm_os_windows_info]
SELECT * FROM [master]. [sys]. [dm_server_services]

That that is necessary! Thanks!

7

Re: Whether it is possible with the help ms sql to collect the given configurations of the server on which costs ?

exec xp_readerrorlog 0,1, "Manufacturer"
exec xp_readerrorlog 0,1, "socket"

8

Re: Whether it is possible with the help ms sql to collect the given configurations of the server on which costs ?

Whether

odisssey wrote:

it is possible with the help ms sql to collect the given configurations of the server on which costs ?
I want  a configuration of servers, it would be desirable to obtain such data on processors, storages, disks.
Gather given to write in a label.

1. Correctly formulated question already comprises an answer part:
Whether it is possible with the help ms sql to collect the given configurations of the server on which costs ?
Whether it is possible with the help ms sql to collect the given configurations of the server on which costs ms sql?
Whether it is possible whining to collect with the help the given configurations of the server on which costs ms sql?
Whether it is possible whining to collect with the help the given configurations of the server on which costs ?
2. What axis there where costs : ? ?

9

Re: Whether it is possible with the help ms sql to collect the given configurations of the server on which costs ?

Hupin wrote:

it is passed...
Widows server 2012 R2 Standart

10

Re: Whether it is possible with the help ms sql to collect the given configurations of the server on which costs ?

wrote:

exec xp_readerrorlog 0,1, "Manufacturer"
exec xp_readerrorlog 0,1, "socket"

Interesting, these requests will work on the server in Amazon RDS?

Posts [ 10 ]

Pages 1

You must login or register to post a reply