SQLServer: Difference between revisions

From Piszczynski
m (5 revisions imported)
No edit summary
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/posts/2021-10-06-sql-server-file-latency/

Revision as of 14:42, 23 November 2023

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:

https://www.nocentino.com/posts/2021-10-06-sql-server-file-latency/