piszczynski>Aleks No edit summary |
No edit summary |
||
| (5 intermediate revisions by the same user not shown) | |||
| Line 21: | Line 21: | ||
==SQL Server Service Accounts== | ==SQL Server Service Accounts== | ||
See useful info here [https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-windows-service-accounts-and-permissions?view=sql-server-ver16 MS Learn] | See useful info here [https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-windows-service-accounts-and-permissions?view=sql-server-ver16 MS Learn] | ||
== SQL Server Performance == | |||
see the following blog for some info: | |||
[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> | |||
== 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] | |||
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