[DBM] SQL Server self-hosted setup: docs don't distinguish GRANT VIEW SERVER STATE vs GRANT VIEW SERVER PERFORMANCE STATE by version

[HassData]

Documentation Page

https://docs.datadoghq.com/database_monitoring/setup_sql_server/selfhosted/

Issue Description

Customers on SQL Server 2016/2017/2019 hit a hard syntax error (Msg 102) when following setup instructions that include GRANT VIEW SERVER PERFORMANCE STATE — this permission did not exist before SQL Server 2022 and causes an immediate failure on older versions.

GRANT VIEW SERVER STATE (the pre-2022 syntax) continues to work on SQL Server 2022+ due to backwards compatibility, so there is no breakage in that direction. The issue is one-directional: older versions cannot use the newer grant.

The setup page should add a version-conditional note clarifying:

• SQL Server 2022+: use GRANT VIEW SERVER PERFORMANCE STATE (least-privilege, recommended)
• SQL Server 2016/2017/2019: use GRANT VIEW SERVER STATE

Evidence: ZD ticket with customer on SQL Server 2016 hitting Msg 102 on the 2022+ syntax; confirmed by Microsoft DMV permissions docs