System Resources

ByDr. SubraMANI Paramasivam

System Resources

Below are the main system resources and are the key elements for better performing server.
CPU: We definitely require more than one CPU to perform multiprocessing and helps any program to be healthy enough with all I/O operations.
RAM: Even if you are not a DBA, you should be aware of the memory that is allocated for your SQL Server instances. Memory Sizing can be done based on the number of transactions that is going to hit the server. Any environment having high transaction should have highly allocated memory to process multiple operations in parallel.
Disk: Disk is the storage area where every single transaction stores and retrieves data from as part of the request from applications, users. Having good amount of understanding and knowledge on database & log files and their location, on these sort of storages is a must, even for non DBA’s. Monitoring and maintaining the data storage, RAID levels, etc., are some of the key activities for every single DBAs.
I/O:  Any Input and output to and from applications/users is calculated with the I/O level. As part of the user or application’s request the I/O part plays a major role and any performance issues will affect the time taken to retrieve the data.

About the Author

Dr. SubraMANI Paramasivam administrator

Dr.SubraMANI Paramasivam is a Data Platform MVP, Power BI Group Leader, International Speaker, Microsoft Certified Trainer and Principal Solutions Architect at DAGEOP Ltd, having 20+ years of DB, BI & Analytics experience. Dr.SubraMANI Paramasivam is a frequent speaker in SQLBITS, PASS Summit, PASS SQL Saturdays, SQLRelay, Data Platform Summit, MCT Summit, SQLServerGeeks Summit, INSIDESQL UK, Data Awareness Programmes, Data Day Events. He likes to enlighten the education & data and started his own journey with FREE Data Awareness Programme (, in remote areas who are in need. Mani speaks a lot about Visualization, Data Science, R Analytics, Azure concepts, Performance Tuning, DB & SQL Server Architecture, DBA, Partitioning, Resource Governor, Disaster Recovery, High Availability, Development, T-SQL Programming and Microsoft certifications.

Comments Are Closed!!!