For performance reasons. I have a know it all application owner "wanna be DBA" telling me that the users are complaining about slow performance. He sees high utilization...

Thanks alot for the info. I have been doing it correctly from the beginning. Since we don't do these things all the time, I get a little nervous....

Oh yeah, I forgot to run the SQL. This is what I have right now. Ask your colleague what he thinks.

physical_memory_in_bytes

------------------------

8587436032

virtual_memory_in_bytes

------------------------

8796092891136

Number of 8KB buffers...

Adam,

Looks like after I did the recofigure the memory messages stopped. I am waiting to have the server rebooted due to windows patches are being applied also. ...

Adam,

I am following http://support.microsoft.com/kb/918483 to lock memory. Let me know if this is not correct.

Thanks so much for you and your friend for helping me...

Can sp_reconfigure be run and it take affect immediately? If not, this will not be implemented until I can plan for a shutdown/restart.

Adam,

I figured that it wouldn't matter if I ran it now before making any changes just in case it sheds more light on the problem.

Here is the...

Hey Adam, do I run this sql after I run sp_reconfigure and lock memory, or run it now?

Also, I looked in SQL Server - Min Server Memory set to 0

...

I'm sure I haven't locked memory.

Here is what I snapped yesterday from task manager. I added a few comments just so it makes sense (somewhat) to me....

Do you mean the adhoc sql cache is bloated or the Buffer usage by database?

--Buffer usage by database:

BESMgmt 794

OperationsManager726

BosBesMgt245

rtc ...

Thanks Adam. I will run these sql scripts and see what happens. I have DBArtisan and I am trying to figure out how to use it at this...

Hey Perry, I am probably being a little thick, but when I choose the method of installation that I am planning is that a files only install? I have...

I am planning to run control panel>add/remove programs>SQL Server 2005>Add Components>Database Engine. Then setup runs where I select Reporting Services and the instance. Is the reporting services database...