No announcements
Found 2661148 threads
-
0 VotesRuntimeBroker consumes large amount of memory (4.5Gb) after running a simple file query
It will repro so long as there are lots of large files.Unanswered | 2 Replies | 1656 Views | Created by Tristan2 - Monday, September 16, 2013 8:11 PM | Last reply by Tristan2 - Wednesday, September 18, 2013 8:18 PM
-
6 Votes
Azure Backup cbengine.exe consuming high memory utilisation
I have tried a local repro with MARS agent, but was unable to do so, memory usage in idle state was constant after subsequent backups.Answered | 12 Replies | 20341 Views | Created by Werner Linnemann - Monday, July 20, 2015 3:50 AM | Last reply by ayushbansal - Thursday, March 19, 2020 9:21 AM -
1 Votes
Query to find long running transaction and high memory consumed process
After you load your trace file you need to import your performance data.Answered | 15 Replies | 115937 Views | Created by Preetha7 - Wednesday, January 8, 2014 5:29 AM | Last reply by tracycai - Thursday, January 9, 2014 9:51 AM -
1 Votes
How to calculate the memory a query consumes
I am trying to find out if the server must page because the query is using all the memory.Answered | 5 Replies | 894 Views | Created by Stefan_Kr - Wednesday, February 26, 2014 9:33 AM | Last reply by Shanky_621 - Wednesday, February 26, 2014 11:05 AM -
4 Votes
large object "out of memory"
You could try to force a garbage collection run prior to allocating the memory.Answered | 14 Replies | 5612 Views | Created by megabitee - Wednesday, April 6, 2011 4:27 PM | Last reply by Evan Machusak - Friday, April 8, 2011 8:04 PM -
1 Votes
Loading a very large XML file with SSIS runs out of memory
If it runs with no destinations, try bringing them back in one by one until you find which one is causing the issue.Answered | 8 Replies | 11772 Views | Created by Lourens8000 - Tuesday, May 25, 2010 8:58 AM | Last reply by Karthikeyan Anbarasan - Monday, November 21, 2011 9:09 AM -
0 Votes
Manipulating large amounts of data
"However, I'd recommend leaving your .dat files externally on the file system, and storing a reference (filename) to the .dat file in the data table in SQL" ...Answered | 7 Replies | 2899 Views | Created by malik_abu_sabri - Monday, May 25, 2009 4:16 PM | Last reply by masher2 - Monday, May 25, 2009 6:38 PM -
1 Votes
Inefficient Query Plans due to Large Amounts of RAM (KB2413549)
If I can ask - were the queries that ran slower accessing humongous amounts of data, say either reading or writing more than 82gb ... hmm, make that more than say 60gb of ...Answered | 8 Replies | 5754 Views | Created by LSC - Monday, October 11, 2010 2:35 PM | Last reply by Vijay Sirohi - Friday, October 22, 2010 12:38 AM -
0 Votes
sleeping SPIDs consume CPU and memory ?
What are you looking at to determine the SPID is consuming memory?Answered | 8 Replies | 1611 Views | Created by juniorkiran - Monday, September 25, 2017 2:59 PM | Last reply by Tom Phillips - Monday, October 2, 2017 12:18 PM -
0 Votes
SQL server consumes memory
"we have on this sql server a database it's size around 1GB but its log file grows dramatically and becomes around 90 GB and the file still grows .Answered | 3 Replies | 3108 Views | Created by ThunderbirdSN - Saturday, December 1, 2012 5:22 PM | Last reply by anuragsh - Monday, December 3, 2012 1:05 PM -
0 Votes
Record available amount of memory when exception occurs ??
The typical hogs are large datasets and bitmaps.Answered | 7 Replies | 3002 Views | Created by Serge Calderara - Thursday, July 23, 2009 11:35 AM | Last reply by nobugz - Thursday, July 23, 2009 6:56 PM -
0 Votes
where is the memory consumed
Here is the result I get for your query, seems only 341MB in use.Answered | 4 Replies | 3580 Views | Created by George Zhou - Friday, September 7, 2012 5:11 PM | Last reply by George Zhou - Friday, September 7, 2012 7:55 PM -
0 Votes
Out of Memory Exception while reading large file
" A simple console application will simply have more memory available.Answered | 11 Replies | 9686 Views | Created by Ajit Porlekar - Saturday, June 22, 2013 9:07 AM | Last reply by Mike Danes - Monday, June 24, 2013 7:58 AM -
6 Votes
Insufficient memory to run the query
You've got a large memory clerk block on spid203 and a large CACHESTORE_SQLCP (a type of memory clerk associated with storing plan caches in ...Answered | 9 Replies | 6272 Views | Created by HunterHuang - Tuesday, January 8, 2013 2:44 AM | Last reply by HunterHuang - Friday, January 11, 2013 8:13 AM -
5 Votes
Large amount of data in ComboBox
from what i have read, even dynamic t-sql queries are cached.Answered | 14 Replies | 9777 Views | Created by Sharfudeen - Thursday, August 6, 2009 6:41 AM | Last reply by Jeff - www.SRSoft.us - Saturday, August 8, 2009 4:05 PM -
1 Votes
C#, Large Arrays and Virtual Memory
As far as I know, the only way to exhert any control over your process' memory is to use memory mapped files, and even there you still do not control ...Answered | 5 Replies | 13897 Views | Created by Matthew Watson - Thursday, January 21, 2010 3:41 PM | Last reply by Tergiver - Saturday, January 23, 2010 8:09 PM -
1 Votes
MEMORYCLERK_SQLCONNECTIONPOOL consuming memory
It has been fixed after installing the SP2 in SQL 2008 R2 instance and appropriate SQL Native client in Websense application server.Answered | 5 Replies | 5164 Views | Created by deepakgupta86 - Monday, July 1, 2013 11:14 PM | Last reply by Vashistar - Monday, August 5, 2013 5:50 AM -
1 Votes
Find what is consuming most of my memory in SSAS database
Now I want to find out that which column/calculate column/measure is consuming my memory at large?Answered | 6 Replies | 5593 Views | Created by SFatimi - Friday, February 2, 2018 1:52 PM | Last reply by willson yuan - Tuesday, February 6, 2018 7:36 AM -
1 Votes
Processing large amounts of data in SSIS ?
But 2-3 million rows is not considered large amount nowadays.Answered | 14 Replies | 1672 Views | Created by blastoSO - Thursday, October 24, 2013 5:11 AM | Last reply by Uri Dimant - Sunday, October 27, 2013 7:31 AM -
6 Votes
Can a large log file impact query performance?
Hi, As previously stated, log file growth consumes resources and can block processes until complete.Answered | 5 Replies | 12601 Views | Created by OldEnthusiast - Tuesday, February 28, 2012 12:48 PM | Last reply by Sean Gallardy - Wednesday, February 29, 2012 1:23 PM - Items 1 to 20 of 2661148 Next ›
No announcements
