Post reply

cost accounting databases

  • August 19, 2008 at 7:02 am

    #191452

    Hi!

    I have a problem and i hope you can help me.

    I´m working as technical Database administrator in germany (so sorry for bad english) in a government office. We offer Database Hosting on central servers. Now the question istisow can i calculate the cost of a database? At the moment we calculate only the database diskspace on SAN plus Backup-Size. Now my Boss wants me to calculate the costs of the used RAM per Database.

    But, how can i see how much Ram a Database consumes? The guys of the Oracle Department can give those information like memory consumption per database (instance), so my Boss wantewantssame from me.

    Are there other things i can calculate easy per month?

    Thanks in advance for your advice!

    Mario

  • August 19, 2008 at 1:38 pm

    #860252

    hi there,

    have you considered looking at performance counters? In 2005 there is a system view that provides you lots of information

    SELECT * FROM sys.dm_os_performance_counters WHERE counter_name LIKE '%mem%'

    If you aren't using 2005 you would have to use the windows's perfmon thing instead

    I am not sure if you will find everything you need broken down by databases... You can do something like this as well:

    SELECT * FROM sys.dm_os_performance_counters WHERE instance_name = 'YourDatabaseName'

    You can look at the counters matching "counter_name LIKE '%cache%'" to make some rough estimates... but I have no clue if it would give you anything remotely valid or not,

    I am sure another member will post something more helpful 🙂

  • August 21, 2008 at 8:44 am

    #861317

    sadly, performance counters dont deliver the information i need, or i´m just too blind to see that.

    Thanks for your answer!

    Bye

    Mario

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply