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
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, May 21, 2015 6:57 AM
Points: 624, Visits: 2,371
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: Friday, May 22, 2015 8:52 AM
Points: 5,685, Visits: 10,916
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
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, May 21, 2015 6:57 AM
Points: 624, Visits: 2,371
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: Thursday, May 21, 2015 8:32 AM
Points: 238, Visits: 946
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-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 10:00 AM
Points: 41,841, Visits: 38,478
Resource governor (though it may not do what you expect) and server memory settings.


Gail Shaw
Microsoft Certified Master: SQL Server, 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