No edit summary |
|||
Line 26: | Line 26: | ||
[https://www.nocentino.com/pure-storage-links/ Pure Storage Links - Anthony Nocentino's Blog] | [https://www.nocentino.com/pure-storage-links/ Pure Storage Links - Anthony Nocentino's Blog] | ||
== SQL Licencing == | |||
Check SQL licencing with the following query:<syntaxhighlight lang="sql"> | |||
SELECT SERVERPROPERTY('productversion') AS ProductVersion, | |||
SERVERPROPERTY('productlevel') AS ProductLevel, | |||
SERVERPROPERTY('edition') AS Edition; | |||
SELECT SERVERPROPERTY('LicenseType') AS LicenseType, | |||
SERVERPROPERTY('NumLicenses') AS LicenseNumber; | |||
EXEC sp_readerrorlog @p1 = 0 | |||
,@p2 = 1 | |||
,@p3 = N'licensing' | |||
</syntaxhighlight> |
Revision as of 11:27, 23 February 2024
SQL Server
Check on SQL server activity using:
- ctrl + alt + A
SQL Server Networking
Check status of the SQL server networkconfiguration with the SQLCheck app:
Also see the other tools:
SQL Server Authentication troubleshooting
If having issues with kerborous authentication you can use this tool to check spn + other possible issues:
SQL Server Service Accounts
See useful info here MS Learn
SQL Server Performance
see the following blog for some info:
SQL Licencing
Check SQL licencing with the following query:
SELECT SERVERPROPERTY('productversion') AS ProductVersion,
SERVERPROPERTY('productlevel') AS ProductLevel,
SERVERPROPERTY('edition') AS Edition;
SELECT SERVERPROPERTY('LicenseType') AS LicenseType,
SERVERPROPERTY('NumLicenses') AS LicenseNumber;
EXEC sp_readerrorlog @p1 = 0
,@p2 = 1
,@p3 = N'licensing'