Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » MEMORY AND TEMP TABLES
Add to briefcase
14 posts, Page 2 of 2
««12

MEMORY AND TEMP TABLES Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
TheGreenShepherd
Posted Wednesday, September 26, 2012 5:51 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, May 02, 2013 3:40 PM
Points: 522, Visits: 374
Answer this question, please - how much memory do you believe SQL Server is using and where are you seeing this information?
Post #1364986
GilaMonster
Posted Thursday, September 27, 2012 2:53 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 8:44 AM
Points: 37,645, Visits: 29,898
What does the following return? (exact output)

SELECT value_in_use FROM sys.configurations AS c WHERE name = 'max server memory (MB)'

What does the Total Server Memory perfmon counter show?

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 #1365098
sql007
Posted Thursday, September 27, 2012 9:11 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 10:36 AM
Points: 64, Visits: 129
Hi Gail,
It was set at 2048mb, but anyways did a fresh install of the win 7 OS/sql2008r2 with the updates and patches last night. now it listens....
Post #1365340
TheGreenShepherd
Posted Thursday, September 27, 2012 10:19 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, May 02, 2013 3:40 PM
Points: 522, Visits: 374
I don't think you're quite getting it.
Post #1365372
« Prev Topic | Next Topic »

Add to briefcase
14 posts, Page 2 of 2
««12

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.