SQL Server 2000 not using full memory on Windows server 2003

Hi everyone.

for a week now, I have had an issue with our SQL server not using the full amount of free space on the server.

We have a Windows Server 2003 Standard with 4gb on hyper-v.

I have allocated 3gb to SQL to use for itself in max allowance, however, SQL is only using 1733644K of memory. Leaving 2GB floating there.

I would not mind, but the server is slowly getting very slow and we have to restart the server every night to clear it.

Please, Please can anyone assist.

Thank you in advance
Baker
LVL 1
BakersvilleAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I presume you went through this document to fully configure the memory usage for your sql server:
http://support.microsoft.com/kb/274750

other than that, if your sql server becomes SLOW every day, it must be something else ...
0

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
ste5anSenior DeveloperCommented:
First of all: Don't restart the server every night.

Use first only DBCC FREEPROCCACHE to see whether you have plan problems.

In the next step clear the buffer pools using DBCC DROPCLEANBUFFERS.

And least, but not last, only restart the SQL Server Windows service, not the entire server.

These steps should help you, to determin whether it is a SQL Server or a Windows Server problem.
0
 
BakersvilleAuthor Commented:
Thank you both for your response. Did both things and seem to be working
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.