Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, April 18, 2016 6:54 AM
Points: 696, Visits: 2,740
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:42 AM
Points: 6,437, Visits: 13,117
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
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, April 18, 2016 6:54 AM
Points: 696, Visits: 2,740
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: Friday, April 22, 2016 9:45 AM
Points: 251, Visits: 1,105
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 @ 4:30 PM
Points: 44,477, Visits: 42,082
Resource governor (though it may not do what you expect) and server memory settings.


Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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