DX Infrastructure Manager

Expand all | Collapse all

How do we get a SQL version off of a device

Jump to Best Answer
  • 1.  How do we get a SQL version off of a device

    Posted 01-15-2020 12:43 PM
    ​Hi All,
    We have looked through all the probes, and are unsure what probe can provide what SQL version a SQL server is running. We have looked through the sqlserver probe, but it does not show that information..

    TIA


  • 2.  RE: How do we get a SQL version off of a device

    Posted 01-15-2020 12:50 PM
    You could use the sql_response probe and run SELECT @@version to obtain the version.

    Steve​

    ------------------------------
    Support Engineer
    Broadcom
    US
    ------------------------------



  • 3.  RE: How do we get a SQL version off of a device

    Posted 01-16-2020 09:59 AM
    ​So to get a response that would be recorded in the database to post on a dashboard, a separate sql_response 'connection' has to be made to each individual device? That seems like a great deal of work for that one response.


  • 4.  RE: How do we get a SQL version off of a device

    Posted 01-16-2020 02:30 AM
    The sqlserver probe will give you the version when you test a connection.


  • 5.  RE: How do we get a SQL version off of a device

    Posted 01-16-2020 10:00 AM
    ​How do you get that as a metric though, so you can put it to a dashboard?


  • 6.  RE: How do we get a SQL version off of a device

    Posted 01-16-2020 10:39 AM
    You can create a custom checkpoint using SQL to return a version that you then publish as QOS


  • 7.  RE: How do we get a SQL version off of a device

    Posted 01-16-2020 10:12 AM
    You could use powershell to accomplish this using logmon to run a command or nexec etc., and there are probably other methods that could be leveraged.

    https://www.sqlservercentral.com/forums/topic/get-version-details-of-multiple-sql-servers

    Steve

    ------------------------------
    Support Engineer
    Broadcom
    US
    ------------------------------



  • 8.  RE: How do we get a SQL version off of a device
    Best Answer

    Posted 01-16-2020 01:52 PM
    Just to be aware,  QOS is numeric and so you'll need to either deal with truncated versions like "10.2" though usually SQL server versions are typically 3 or 4 dotted numbers or encode the data.

    https://www.mssqltips.com/sqlservertip/1140/how-to-tell-what-sql-server-version-you-are-running/

    Getting that into a comfortable human readable form will take an SQL Query and you'll need to translate the version into a numeric identifier that can be stored in a qos table and then translate it back for display.