In some cases, we don't know how our database program/application has developed. Sometime, the developer don't consider how to create/make query for the best hardware performance.
For example, we use an windows application/program than use Sql Server as database storage. When we check our server, it looks a higher memory usages, what will we do?
First thing that you should know is, every program or service must consume a lot of memory. You can check through windows task manager, how much memory for each program/service.
In this case, assume the sqlserv.exe process consumes highest server memory (RAM), so we can adjust memory maximum / allocation for the sql server database service/process with this step:
1. Log in to SQL Server Management Studio
2. On the Server Instance, right click, select Properties
3. Set the maximum memory according to memory capacity of the server
4. We can set to 75% from maximum installed server memory (in MB), ie. 12,000 MB
5. If while this processes the memory usages higher than 12,000 MB, then this process will automatic shrink / adjust to 12,000 MB.
No comments:
Post a Comment