memory in use so high

how can I stop temporarily  sqlservr.exe (Description-SQL Server Windows NT ) and w3wp.exe (Description-IIS work process ) temporarily as well in windows server 2008 -32Bit?
FSPLAsked:
Who is Participating?
 
NJComputerNetworksConnect With a Mentor Commented:
It sounds like your doing too much with that server.  You may need to add additional RAM.  Normally it is not recommended to run SQL on a domain controller.

If you are using Windows backup, you do not need to run SQL.  Some other programs (3rd party) may require a SQL database.  In general, if you have a small environment, there would be no reason for SQL to be running.

I would stop and disable the SQL service... and then test to see if you can still run your backups successfully.  

I would also add more RAM (maybe 4GB) to this server.
0
 
andeporterCommented:
Disable or stop the services under Computer Management.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you could stop the corresponding services (services applet)

now, I presume all you really need to do is to configure the sql server's max memory setting to a value of +-50% of the RAM of the machine, and eventually restart the sql server process to quickly release the memory indeed.

you can do it with the sql management studio GUI interface, or via sql
0
 
FSPLAuthor Commented:
 <!--[if gte mso 9]>   Normal  0      false  false  false                     MicrosoftInternetExplorer4 <![endif]--><!--[if gte mso 9]>  <![endif]--><!--[if gte mso 10]><![endif]-->The problem I'm facing is users cant access the files fromShared drive from the server sometimes. When they try to save the file, opened applicationis not responding.Once it happened, we have to restart the server and then only allusers can access the files from shared drive.
 
 
I'm keep receiving error message in Event viewer which is:

((((The description for Event ID 33002 from source MSSQL$MICROSOFT##SSEE cannot befound. Either the component that raises this event is not installed on yourlocal computer or the installation is corrupted. You can install or repair thecomponent on the local computer.
If the event originated on another computer, the display information had to besaved with the event.
The following information was included with the event:
table
dbo.backupmediaset
The specified resource type cannot be found in the image file)))))

Event ID is 33002
whenever I check memory usage in Task manager, memory usage is about 1.25 GB.
My total physical memory is 2GB
when I check in process, sqlservr.exe [Description-(SQL server windows NT) ] isusing a lot of memory.
Also 2 processes of w3wp.exe [ Description ( IIS worker process) ] is runningas using a lot of memory
 
I'm using windows server 2008 32bit.It is domain controller.
We have 1 shared drive from the server.
Our server is not database server, not web server.
But we use backup feature from the server.
Backup feature require Sql ?
My main problem is users cant access files from shareddrive and we have to restart server to be able to use. I checked in eventviewer, before this happened, I see error  with EVENT ID 33002 mostly.Is that the cause ?
It is really annoying for all users
Any suggestion to fix this issue ?
Thanks..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.