Viewing 15 posts - 601 through 615 (of 1,129 total)
ALZDBA (4/14/2011)
Set it to an...
April 14, 2011 at 1:29 pm
Thanks. My question was based on the results from a trace file. I just need to know which takes precendence over the other:-)
April 14, 2011 at 1:26 pm
sqlbuddy123 (9/13/2010)
Total Memory >= Target Memory ------> Represents Memory Pressure
Total Memory < Target Memory ------> Represents No pressure.
http://www.sql-server-performance.com/tips/performance_monitor_memory_counter_p1.aspx
...
April 14, 2011 at 1:16 pm
NO AWE is not enabled.I have enabled locked pages in memory though. Could this be an issue?
April 14, 2011 at 12:37 pm
Patrick_Fiedler (4/13/2011)
Look at the instance reports -> server dashboard and then non-default configurations.
Execute following statements to get details of the memory usage:
-- Buffer...
April 13, 2011 at 10:53 am
GilaMonster (4/13/2011)
Do not use task manager to check SQL's memory usage. It does not show accurate values if you are using locked pages, as the post that Nils referenced explains.
That...
April 13, 2011 at 9:31 am
Patrick_Fiedler (4/12/2011)
what shows the task manager. How much memory is free of the physical memory? Because the sql server would only take physical memory and not page file memory.
Is the...
April 12, 2011 at 7:50 pm
AlexSQLForums (4/7/2011)
sqldba_icon (4/7/2011)
AlexSQLForums (4/7/2011)
April 9, 2011 at 12:59 pm
Grant Fritchey (4/7/2011)
April 7, 2011 at 12:49 pm
AlexSQLForums (4/7/2011)
April 7, 2011 at 12:31 pm
Thanks everyone for the inputs. Still some of my questions are unanswered.
i) Why do i see two different plans one from mgmt studio and one from the application? The sql...
April 7, 2011 at 9:17 am
OK, i just realized my procs are also using functions. Now, i know the the procedure is using different plan when i run from management studio Vs being called from...
April 6, 2011 at 3:15 pm
Grant Fritchey (4/5/2011)
April 6, 2011 at 12:59 pm
Viewing 15 posts - 601 through 615 (of 1,129 total)