October 17, 2006 at 6:40 pm
How can i be monitoring the memory that the SQL Server is taking from my server?
How can i administrate it, and how can i know why is taking so much memory?
Is there a way to know wich processes of the SQL Server are taking a lot of memory?
October 17, 2006 at 10:06 pm
hi
Use the performance monitor to know how much memory is being consumed by sql server.
to know which processes in SQL server are taking more memory u need to use the profiler.
search this site for more details.
"Keep Trying"
October 19, 2006 at 6:44 am
In general, SQL Server will take all the memory it can get, mostly for caching data pages to minimize disk i/o. SQL Server tries to get along with the rest of the system by releasing memory when the available physical memory drops below a threshhold (4 to 10 MB), but if other processes frequently need to allocate megabytes of memory then there will be conflicts (excessive paging). If you want to limit this you can use the "max server memory" configuration option, keeping in mind that this will affect SQL Server performance if you set it too low.
You can find out what the memory is being used for by using dynamic management views in SQL 2005, otherwise you can use perfmon (SQL Server: Buffer Manager: Total Pages, SQL Server: Buffer Manager: Page Life Expectancy, SQL Server: Memory Manager: Total Server Memory (KB), Memory: Available Memory, etc). If SQL's Page Life Expectancy is low it implies that SQL Server needs more memory, If system Available Memory is too low, the other applications or the OS need more memory.
You can also download a trial version of a tool like Quest Software's Spotlight on SQL Server. It will show you in great detail how the memory is being used.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply