Author: Ross Chesley

Finding Resource Usage Details in MSSQL

Posted on October 15, 2019 by Ross Chesley

Category: Tutorials | Tags: Microsoft, Microsoft SQL, MSSQL, optimizaiton, optimization, Performance, SQL Server, Windows

Reading Time: 8 minutes

When running MSSQL or Microsoft SQL Server, we need to determine whether it is optimized or will it need more resources to achieve better performance. This article reviews what behaviors to look for, where to find them, and how to view signs of distress.

Continue reading →

How to Check Server Load on a Windows Server

Posted on March 18, 2019 by Ross Chesley | Updated: March 10, 2021

Category: Common Fixes | Tags: CPU, Disk Usage, IIS, Memory, Monitoring, Network, Performance, Processes, RAM, Services, Users, Windows

Reading Time: 7 minutes

What Does Server Load Mean?

Checking a server’s load allows us to evaluate server resources and confirm they are sufficient for any running application. It enables us to troubleshoot slow performance and reliably pinpoint any server resource that may need attention.

Continue reading →

How to Setup and Use Microsoft SQL Server Management Studio

Posted on March 13, 2019 by Ross Chesley

Category: Getting Started | Tags: Connections, Install, MSSQL, ssms

Reading Time: 6 minutes

What is SSMS?

SQL Server Management Studio (SSMS) is a free Windows application to configure, manage, and administer Microsoft SQL Server (MSSQL). SSMS includes an Object Explorer to view and interact with databases and other elements, a Query window to write and execute Transact-SQL queries, and script editors for developers and administrators.

Continue reading →