December 24, 2010 at 2:40 am
Hi,
one of my sql server 2008 EE 64 bit taking more than 75% of memory utilization.
plz let me know what are the reasons for this problem?
where to start the analysis to resolve this
Subha
December 24, 2010 at 3:42 am
You might want to have a look at Gails article.
At least this should get you started.
From my point of view, performance tuning is an art all by itself. No secret though, but something that requires some experience...
December 24, 2010 at 4:27 am
use sql profiler..tune all your queries/sp which are taking more time by applying recomendations given by the tuning advisor..if it still does not work then check in books online it might help you
December 24, 2010 at 4:31 am
abhishek.8604 (12/24/2010)
use sql profiler..tune all your queries/sp which are taking more time by applying recomendations given by the tuning advisor..if it still does not work then check in books online it might help you
Profiler is a good choice to begin with.
But I'd vote against the tuning adviser. It might give you a hint what columns should be part of an index, but this needs to be evaluated carefully. Don't take the recommendations for granted.
December 24, 2010 at 4:34 am
ya very true...you can carefully check and go according to that...
January 6, 2011 at 11:39 am
Why do you think that the memory usage is a problem? Are things running slow?
How is min and max server memory configured?
What is the value for the "page life expectancy" and "buffer cache hit ration" counters? You can get it from perfmon or sys.dm_os_performance_counters.
SQL Server uses the buffer cache mainly to store data pages and execution plans for fast lookup when data is needed. As you probably know it is faster to read data from RAM than from disk.
So again, why do you consider 75% memory usage a problem?
January 6, 2011 at 11:39 am
deleted! double post.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply