Wait Events and Workload Analysis screens show no data
説明
Wait Events and Workload Analysis screens show no data.
対策
RESOLUTION 1: Missing Permissions. Check the account used for SQL Server connection in Spotlight to monitor this instance. If this account is not part of SA role, then grant one of these permissions: -----for SQL Server 2008 and above: Grant CONTROL SERVER to TrustedUser -----for SQL Server 2012 and above: Grant ALTER ANY EVENT SESSION to TrustedUser
RESOLUTION 2: Extended Events are disabled. 1. On main menu, go to Configure tab | Diagnostic Server. 2. On new window, click the link "Use of Extended Events". 3. Ensure the box "Use Extended Events" is checked and click OK.
If it is checked; then it can also be controlled by connection and check for the specific connection to ensure it's enabled: 1. Right-click on SQL Server connection | Properties. 2. Check the box "Use Extended Events". 3. Click OK.
RESOLUTION 3: Possible Defect on Previous Version of Spotlight. There is a defect in certain versions of Spotlight and it's recommended to upgrade to the latest version of Spotlight. Click here to get the latest version of Spotlight.
RESOLUTION 4: Compatibility Level on instance. In the support bundle, the following error may appear when this issue is seen:
“Collection 'LookupSQLText' failed : "sqlHandle" is not a recognized table hints option. If it is intended as a parameter to a table-valued function or to the CHANGETABLE function, ensure that your database compatibility mode is set to 90. [321]”
If possible, please change the instances where you see this problem to be Compatibility Mode 90 or greater.