أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.
What will be the method to analyse the cause of CPU and memory usage in windows2008 server. In my case the server is running IIS and Mysql , The physical RAM installed is4 GB. which is always high along with CPU.
If you want the easy way, you can use MS taskmgr tool and check by process.But for more details with MS SQL server you can use "DBCC MEMORYSTATUS" in your SQL server management studio.Depends of the size of your SQL base but4GB of memory may be a little too short