Introduction

The aim of this project is to show the Windows Server past and present performance.

Technologies Used

• Powershell Script
• C Sharp
• MSSQL Server
• SQL Server Reporting Service

Working Concept

1. Powershell Script collects CPU & Memory Usage and saves it in a text file.
2. Powershell program is scheduled to run on an regular interval basis.
3. C Sharp program inserts data from databuffer.txt file into MSSQL Database.

Task Scheduler

Powershell program is scheduled to run on an regular interval basis on Task Scheduler.

MSSQL Database

CPU & Memory Data of each servers will be saved in CPURAM SQL Table

SSRS Report File

SSRS Report has been designed in Visual Studio using SQL Query to show the server performace in chart.

Final Output:

Select the following parameters and click on View Report to see the server perfomance as visual chart.

• Server Name
• From Date
• To Date