Microsoft SQL(MSSQL) sqlservr.exe use all system memory.

Issue: MSSQL Server will consume as much memory as you will allow it. By default, that number would encompass 100% of your numerical memory on your machine. That’s why you’re seeing what you’re seeing. For an example if you give MSSQL Server 24 GB of memory, then SQL Server will do its best to use […]

Read More

SQL Server won’t start

If the error also includes “No such host is known”, it indicates that the Analysis Services server is not available or is refusing the connection. If the Analysis Services server is installed as a named instance on a remote computer, you might have to run the SQL Server Browser service to get the port number […]

Read More

Troubleshooting SQL Server Agent Notifications (Email)

Most of the time we face this issue on all the SQL server versions. This may cause unexpected server agent failures due to lack of resources. The resolution steps are given below; Step 01 – Validate SQL Server Database Mail. First test to see if the system is able to send email using the Database […]

Read More

SQL Server Authentication Types.

There are two possible modes: Windows Authentication mode and Mixed mode. Windows Authentication mode enables Windows Authentication and disables SQL Server Authentication. Mixed mode enables both Windows Authentication and SQL Server Authentication. Windows Authentication is always available and cannot be disabled. Disadvantages of SQL Server Authentication. If a user is a Windows domain user who […]

Read More

What is Microsoft SSRS, SSIS and SSAS?

You will find many services under the SQL server other than SQL server / SQL Browser and SQL server agent. SQL Server Reporting Services (SSRS) The SQL Server Reporting Services (SSRS) is a framework of reporting mechanisms such as the Report Builder, Report Designer, Report Manager and Report Server that work together through a Web […]

Read More