SQLServer

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:

SQLCheck DL

Also see the other tools:

SQL Networking tools wiki

SQL Server Authentication troubleshooting

If having issues with kerborous authentication you can use this tool to check spn + other possible issues:

Microsoft® Kerberos Configuration Manager for SQL Server®

SQL Server Service Accounts

See useful info here MS Learn

SQL Server Performance

see the following blog for some info:

Pure Storage Links - Anthony Nocentino's Blog

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'

SQL Server Upgrade

See the following articles on upgrading SQL server:

Upgrade SQL Server

Start planning SQL server upgrade by running the Data Migration Assistant: Data Migration Assistant Download Page