weird memory usage on sql server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » weird memory usage on sql server

17 posts, Page 2 of 2

««1 2

weird memory usage on sql server

Rate Topic

Display Mode

Topic Options

Author

Message

djordan 4543

Posted Tuesday, December 18, 2012 11:12 PM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, February 21, 2013 9:37 AM
Points: 29, Visits: 129

thanks - i'll c what I can do with that.

Post #1398182

GilaMonster

Posted Wednesday, December 19, 2012 12:06 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:15 PM
Points: 37,651, Visits: 29,903

Just to reiterate here...

GilaMonster (12/18/2012)

Don't use Task Manager to check SQL's memory. It can be completely wrong.

Use Perfmon with either the SQL Server memory counters and/or the process-specific counters.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1398206

djordan 4543

Posted Thursday, December 20, 2012 5:56 PM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, February 21, 2013 9:37 AM
Points: 29, Visits: 129

yep used perfmon memory.avialable_memory and process.workingset for all the processes - did not see anything useful from that.
(i.e nothing spike in the working sets when avilable memory reduced dramatically).

I thought I might setup some monitoring with those dmvs bhuvnesh sent through.. gonna try now!

dj

Post #1399143

djordan 4543

Posted Monday, January 07, 2013 6:32 PM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, February 21, 2013 9:37 AM
Points: 29, Visits: 129

with the script provided - is there anything in particular to look for . I ran the script during high memory usage and low memory usage and I don't see anything of any particular concern (I don't profess to understand everything the script is doing though).

I thought perhap sql plans in the memory clerks may have been high (comparing values between high memory times and low memory times) but I appeared to be wrong here.

Post #1403943

Bhuvnesh

Posted Monday, January 07, 2013 11:16 PM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

djordan 4543 (1/7/2013)

i qam sorry there is no straight forward bread for this. you need to see the result of each query carefully and before result see "the commented line above of every query"
then you need to dig into the issues.

Are you still seeing continous memory usage ( any particular time period or pattern)? have you seen the sql error log ? or even the system log ?

Have you seen the tempdb usage ? do you have dedicated or separate disk for it ?
and any kind of IO high usage ?

see this link for memory http://blogs.msdn.com/b/karthick_pk/archive/2012/06/15/troubleshooting-sql-server-memory.aspx

-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1403978