How to calculate the total memory occupied by the database
-
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 occupied by the database in the server. Kindly Help me. Thanks Ramm
-
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 occupied by the database in the server. Kindly Help me. Thanks Ramm
-
Like this:
use YourDBName
SELECT size FROM sys.database_filesIt's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD
Hi D@nish, I executed the query, it showed, 1408 and 2768 without data in database. even with data it showd the same numbers. please help me. Thanks Ramm
-
Hi D@nish, I executed the query, it showed, 1408 and 2768 without data in database. even with data it showd the same numbers. please help me. Thanks Ramm
Well have a rat around the management studio, sysobjects also has lots of info. Take a look at the system views, they are design to give you info on your databases.
-
Hi D@nish, I executed the query, it showed, 1408 and 2768 without data in database. even with data it showd the same numbers. please help me. Thanks Ramm
Right Click your database in Object Explorer, Select Reports - Standard Reports - Disk Usage explore these reports for common reqs.
I don't speak Idiot - please talk slowly and clearly I don't know what all the fuss is about with America getting it's first black president. Zimbabwe's had one for years and he's sh*t. - Percy Drake , Shrewsbury Driven to the arms of Heineken by the wife
-
Hi D@nish, I executed the query, it showed, 1408 and 2768 without data in database. even with data it showd the same numbers. please help me. Thanks Ramm
Size is the size of mdf and ldf file in 8K pages. Divide the value by 128 to get the size in MB. It might come same with/without data depending upon the amount of data your DB holds.
It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD