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

memory Expand / Collapse
Author
Message
Posted Thursday, July 4, 2013 4:46 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: Today @ 2:35 AM
Points: 526, Visits: 2,032
how to restrict memory at query level and also at server level?
Post #1470397
Posted Thursday, July 4, 2013 4:57 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:47 AM
Points: 5,386, Visits: 9,962
This sounds like an interview or homework question. What research have you done?

If I'm wrong about that, what is the exact problem you're trying to solve?

John
Post #1470403
Posted Thursday, July 4, 2013 5:02 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: Today @ 2:35 AM
Points: 526, Visits: 2,032
i would like to know how can we acheive this ?
Post #1470404
Posted Thursday, July 4, 2013 5:25 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 4:59 AM
Points: 217, Visits: 866
I'd start with server properties in SSMS and have a good old read here:

http://technet.microsoft.com/en-us/library/ms181453.aspx


'Only he who wanders finds new paths'
Post #1470410
Posted Thursday, July 4, 2013 6:20 AM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 1:14 PM
Points: 39,977, Visits: 36,340
Resource governor (though it may not do what you expect) and server memory settings.


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 #1470418
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse