July 4, 2013 at 4:46 am
how to restrict memory at query level and also at server level?
July 4, 2013 at 4:57 am
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
July 4, 2013 at 5:02 am
i would like to know how can we acheive this ?
July 4, 2013 at 5:25 am
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'
July 4, 2013 at 6:20 am
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply