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: Wednesday, June 22, 2016 1:14 AM
Points: 698, Visits: 2,747
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 @ 8:56 AM
Points: 6,695, Visits: 13,730
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: Wednesday, June 22, 2016 1:14 AM
Points: 698, Visits: 2,747
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, June 23, 2016 7:16 AM
Points: 251, Visits: 1,118
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 @ 2:35 PM
Points: 44,895, Visits: 42,902
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