No edit summary |
No edit summary |
||
Line 38: | Line 38: | ||
,@p3 = N'licensing' | ,@p3 = N'licensing' | ||
</syntaxhighlight> | </syntaxhighlight> | ||
== SQL Server Upgrade == | |||
See the following articles on upgrading SQL server: | |||
[https://learn.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-sql-server?view=sql-server-ver16 Upgrade SQL Server] | |||
Start planning SQL server upgrade by running the Data Migration Assistant: [https://www.microsoft.com/en-us/download/details.aspx?id=53595 Data Migration Assistant Download Page] |
Latest revision as of 12:47, 18 March 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'
SQL Server Upgrade
See the following articles on upgrading SQL server:
Start planning SQL server upgrade by running the Data Migration Assistant: Data Migration Assistant Download Page