|
Hi,
I am using sqlserver 2008, How can I calculate the total memory occupied by the Database with tables (>30) and also data in it.
I mean if I have DB (DB_name) and with few tables(tblabc, tbldef ) with data in it, how to calculate the total memory...
Started by Aditya on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Be aware that if you are using FILESTREAM, the actual files are... .
See where your db is stored and these files are files you need .
You need the lof file too.
See the sizes of mdf and log files
EDIT: Sql Server stores its db in mdf files(one or multiple) .
|
|
I have a Perl script where I maintain a very simple cache using a hash table. I would like to clear the hash once it occupies more than n bytes, to avoid Perl (32-bit) running out of memory and crashing.
I can do a check on the number of keys-value pairs...
Started by Nikhil on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at stackoverflow):
You're looking for Devel::Size
NAME Devel::Size - Perl extension for finding the memory usage of Perl variables
SYNOPSIS use Devel::Size qw(size total_size); my $size = size("A string"); my @foo = (1, 2, 3, 4, 5); my $other_size = size(\@foo); my $foo... .
|
|
Hi all,
I use C# to automate an excel file. I was able to get the workbook and the sheets it contains. If for example I have in sheet1 two cols and 5 rows. I wanted o get the range for the occupied cells as A1:B5. I tried the following code but it did...
Started by Sarah on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Will now be the occupied cell range.
|
Ask your Facebook Friends
|
Where we work the bathroom is down one hall, around a corner, and at the end of another long hall. The walk to the bathroom isn't so bad, but too often one will walk all this way only to find the door locked and the facilities occupied.
I don't mind taking...
Answer Snippets (Read the full thread at superuser):
Sounds like you to get some ideas from this post ... .
Free as in beer solution....
A little flippable sign in the office saying Occupied/Free - when someone leaves for the toilet, they flip it to Occupied, when they return flip it to Free.
|
|
I need to programmatically find out exactly how much memory a given Java Object is occupying including the memory occupied by the objects that it is referencing.
I can generate a memory heap dump and analyse the results using a tool. However it takes ...
Started by Kishnan on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
The resulting piece of code is too complicated for me to post here (although it will soon be available as part of a GPL toolkit I am building... .
You will need to use reflection for that.
You can investigate your object graph during runtime by using reflection .
|
|
As long as I see when I position an element (for example flash player) relatively to previously placed image as in the example
style="display: block; width:216px;height:164px; position: relative; top: -306px; left: 63px"
the place that it intended to ...
Started by Maksee on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
You....
Relative positioning
One way is to place the child element as absolutely positioned inside another container with position set .
A relatively positioned box keeps its normal flow size, including line breaks and the space originally reserved for it .
|
|
I have read several times that after you delete a row in an InnoDB table in MySQL, its space is not reused, so if you make a lot of INSERTs into a table and then periodically DELETE some rows the table will use more and more space on disk, as if the rows...
Started by raquo on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
This is because for both operations InnoDB....
This could hint at you should do:
From http://tag1consulting.com/InnoDB_Performance_Tuning :
Don't empty a table with DELETE FROM or TRUNCATE
Emptying a large table using DELETE FROM or TRUNCATE is slow on InnoDB .
|
|
Doesn't the space occupied by a variable get deallocated as soon as the control is returned from the function??
I thought it got deallocated.
Here I have written a function which is working fine even after returning a local reference of an array from ...
Started by deovrat singh on
, 12 posts
by 12 people.
Answer Snippets (Read the full thread at stackoverflow):
If you change your code to do some significant work between populating that memory and... .
The contents of the memory taken by local variables is undefined after the function returns, but in practice it'll stay unchanged until something actively changes it .
|
|
How can I find out how much memory does my Iphone app occupy in any given moment from within the app itself? I'm interested in this on the device, not in the simulator. Is it an API to call for that? As another approach, how can I find out how much free...
Started by luvieere on
, 4 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
But libtop for Mac OS is open source and you can have a look into... .
See here why.
Memory usage is a bit complicated, since there is no easy number to determine .
You can use Instruments, especially the "Object Allocations" template, to track memory usage .
|
|
Hey all, is this a bug or is it now that an occupied port can no longer block resources from getting into the town of the occupied port? So basically resources can come and go but not military units? Everything's paid and we're feeling fine on the Devils...
Started by Wylde
Slinger on
, 11 posts
by 6 people.
Answer Snippets (Read the full thread at ikariam):
|
