|
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 .
|
|
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 .
|
|
What are the storage requirements for nvarchar(X)?
So for example, if the value in a column is much smaller than X, how much is actually stored in the database page?
Started by Thomas Bratt on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
For Microsoft SQL server "the storage size, in bytes, is two times the number of characters ... .
The exact size is probably dependant of the SQL server in use .
An nvarchar column is the size of the number of unicode characters stored inside + an overhead .
|
|
NJ Owner Occupied Property Can a landlord end a lease of an apartment at the end of the lease period without giving any reason. The landlord resides in one of the units in a 3 unit house in NJ. Loki.
Answer Snippets (Read the full thread at trulia):
The landlord can look out of his window whenever he wants and yes, he can check who is coming in and out of the... .
Remember, you are the tenant and it is his building .
Loki - The Landlord has the option to renew your lease or not without any reason to you .
|