how to reduce the memory useage of the sqlserver.exe process

We are having a SBS 2003 with about 30 users. I just wanted to know how can I reduce the memory usage of the sqlserver.exe process?

Please let me know as soon as possible. Thank you.

You need a tool called as Microsoft SQL Server Management Studio Express, aka SSMSE. It is a free easy-to-use graphical management tool for managing SQL Server. You can download it from here http://www.microsoft.com/downloads/d...displaylang=en

To determine which processes and applications are using the most memory, use Task Manager. Monitor the activity of these resources over a few days. If they continue to use a high level of memory and are less critical processes or services, try stopping and then restarting them. You can disable this alert or change its threshold by using the Change Alert Notifications task in the Server Management Monitoring and Reporting taskpad.

Open Performance in Administrative Tools.Add the followoing counters:

Performance object: MSSQL$MSFW-Memory Manager
Counter: Total Server Memory (KB)
Performance object: MSSQL$MONITORING-Memory Manager
Counter: Total Server Memory (KB)
Performance object: MSSQL$SHAREPOINT-Memory Manager
Counter: Total Server Memory (KB)

This will allow you to analyze which instance uses high memory.