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

get current version of SQL server:

SELECT @@VERSION;

Can use the following spreadsheet to work out what build the SQL server is on and what it can be upgraded to:

SQLServerBuilds

There are GDR builds, RTM builds and CU updates. You can upgrade the GDR builds with security updates and go from one GDR build to the next OR do CU updates that contain all the changes. Once you use a CU update from a GDR build you cant go back to GDR. GDR+RTM builds contain all security and updates.

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