Windows Server

Eric Torstenson · Guest

I made a mistake a few weeks ago in trying to have a weekly report mail me a
copy of the IIS logs, and several others. The file count & sizes were too
big for the program, and it went a couple of runs before I noticed it was
giving me error messages instead of logs (text messages explaining that the
logs were to big to mail...)

I've since eliminated those reports, but it seems that the reporting SQL
instance grows in size over time. I can restart the service, and the memory
resumes a reasonable size.

When I first noticed the problem, it had taken over 1 Gig of RAM & paged
memory. I originally assumed this was caused by my erroneous reports, but as
I said, those don't exist any more. I do get performance and resource usage
reports daily.

It seems to grow at just under 10s of megs each day.

BSA indicates that I'm up to date on SQL server stuff, and this particular
instance seems unlikely for a compromise. I've also scanned the logs and
seen nothing in any of them that caused me any real concern.

Any ideas?

eric

Charles Yang [MSFT] · Guest

Hi Eric,

Thank you for posting here.

From the description, I understand that you want to manually configure the
memory usage for a particular SQL instance. Based on my research, you can
assign the minimum and maximum memory allocation value by using osql
utility. Please see the steps below:

Open a command prompt. Input the osql command and press Enter to open the
SQL instance:

osql -E -S ServerName\InstanceName

You will enter the osql console. Follow the commands below:

1> EXEC sp_configure 'show advanced options', 1
2> reconfigure
3> go

1> EXEC sp_configure 'min server memory', 0
2> reconfigure
3> go

1 EXEC sp_configure 'max server memory', 1000
2> reconfigure
3> go
Please note: this is an example;, please allocate this value according to
your server setting.

After performing the above steps, you may input:
1> EXEC sp_configure
2> go

More information for you:

321363 INF: SQL Server Memory Usage
http://support.microsoft.com/?id=321363

I hope the above information is useful to you, if you have any questions
please feel free and let me know.

Have a nice day!

Charles Yang
Online Partner Support
Partner Support Group
Microsoft Global Technical Support Center
Mailto: v-chayan@microsoft.com

Sincerely,

Charles Yang (MFST)

Microsoft Partner Online Support

Get Secure! - www.microsoft.com/security
====================================================
When responding to posts, please "Reply to Group" via your newsreader

so that others may learn and benefit from your issue.
====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

	Windows Server Forum Index -> Small Business Server 2003	All times are GMT
Page 1 of 1