http://sqlserver.ro/forums/14/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/902.aspxThu, 16 Nov 2006 23:02:47 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:902rremus0http://sqlserver.ro/forums/thread/902.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=902<p>Ce versiune de SQL Server? Ce versiune de OS?&nbsp;Cita memorie fizica? Cit de mare e pagefile?</p><p>Daca e SQL 2005&nbsp; ar fi interesant de vazut care clerk consuma memoria:</p><p class="MsoNormal" style="margin:0in 0in 0pt;"><span style="font-size:10pt;color:blue;font-family:'Courier New';">select</span><span style="font-size:10pt;font-family:'Courier New';"> <span style="color:blue;">top</span><span style="color:gray;">(</span>10<span style="color:gray;">)</span> single_pages_kb<span style="color:gray;">+</span>multi_pages_kb <span style="color:blue;">as</span> total_pages_kb<span style="color:gray;">,</span> <span style="color:gray;">*</span> </span></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><span style="font-size:10pt;font-family:'Courier New';"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style="color:blue;">from</span> <span style="color:green;">sys.dm_os_memory_clerks</span></span></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><span style="font-size:10pt;font-family:'Courier New';"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style="color:blue;">order</span> <span style="color:blue;">by</span> total_pages_kb <span style="color:blue;">desc</span></span></p><p>Numai de bine,<br />~ Remus</p>http://sqlserver.ro/forums/thread/895.aspxThu, 16 Nov 2006 13:55:03 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:895xmldeveloper0http://sqlserver.ro/forums/thread/895.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=895<p>Ce Service Pack folositi?</p><p>Scriptul foloseste cumva cursoare? </p><p>Textul exact al erorii este ?</p><p>&nbsp;</p>http://sqlserver.ro/forums/thread/893.aspxThu, 16 Nov 2006 12:32:04 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:893jasie270http://sqlserver.ro/forums/thread/893.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=893<p>Cand rulez un script in query analyzer, lung cu mii de linii , mi s-a intamplat sa primesc mesajul &quot;System out of memory&quot;</p><p>E nevoie de mai multa memorie fizica? sau e un bug?sau ce solutii pot fi pentru rezolvarea erorii?</p><p>&nbsp;</p><p>Va multumesc anticipat&nbsp;</p>