Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

mamory status big diffrence Expand / Collapse
Author
Message
Posted Wednesday, March 25, 2009 10:17 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 5:54 AM
Points: 311, Visits: 531
Hi,

wen i check the memory status there is a difference in some area i can remove the proc cache but i dnt know abut the other ...please provoide me ur suggestion..

windows x64 ...sql standard version 14 gb ram ... i hav attach the memory status file before and afther the process.


  Post Attachments 
AfterMomoryStatus1.txt (27 views, 33.48 KB)
BeforeMemoryStatus.txt (11 views, 33.46 KB)
Post #683827
Posted Thursday, March 26, 2009 2:12 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 5:54 AM
Points: 311, Visits: 531
waitin for the reply plz .....
Post #683890
Posted Thursday, March 26, 2009 3:17 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 10:33 AM
Points: 344, Visits: 1,543
Hi,

I guess we are actually wishing to discuss memory here

May I suggest you take a look at the following thread.

http://www.sqlservercentral.com/Forums/Topic679203-146-1.aspx

Cheers,



John Sansom (@sqlBrit) | www.johnsansom.com
Post #683919
Posted Friday, April 3, 2009 3:12 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 5:54 AM
Points: 311, Visits: 531
this is not helpful for me..... jeff or ny one more suggestions..
Post #689671
Posted Friday, April 3, 2009 3:31 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 10:33 AM
Points: 344, Visits: 1,543
Hi,

Can you please re-explain exactly what your issue is?

Cheers,



John Sansom (@sqlBrit) | www.johnsansom.com
Post #689686
Posted Friday, April 3, 2009 11:08 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 5:54 AM
Points: 311, Visits: 531
this is the momory status before and after the our process i can check the proc cache and sys cache but i dnt know wat need to be done wen like MEMORYCLERK_SQLSTORENG (Total) and all are high in after the process ....

secondly we are having sqlserver 32 bit standard edition and windows x64 ..
14 GB ram
so do i hav to enable AWE..... in configure it is zero ...

As i check the counters total memory and target memory are same ..... it show 3 gb utilization while our process is on...

i hav given 10 gb to sql... page file size 4 gb ..


Wat shud i do m really counfused...

one more thing do i hav to enable lock pages memory
Post #690365
Posted Friday, April 3, 2009 11:35 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 5:54 AM
Points: 311, Visits: 531
John thkz for the reply ... plz provide ur suggestions
Post #690370
Posted Saturday, April 4, 2009 3:39 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 10:33 AM
Points: 344, Visits: 1,543
Hi,

So you are currently running.

1. Windows Server 64 bit?
2. SQL Server 2005 Standard Edition(32 bit)?

What Edition of Windows Server are you running Enterprise/Standard?

Cheers,





John Sansom (@sqlBrit) | www.johnsansom.com
Post #690412
Posted Monday, April 6, 2009 2:21 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 5:54 AM
Points: 311, Visits: 531
Enterpise...Edition,................ Sam
Post #690799
Posted Monday, April 6, 2009 10:58 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 5:54 AM
Points: 311, Visits: 531
waiting for the reply..
Post #691679
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse