View Database Used per file

GoMaD

Hi,

We are running a database of 30 GB in a 3.60 native environment. Last weekend we reïnstalled the server and created 4 partitions. C and D on 1 disk group in RAID 1, E on 1 disk group in RAID 1 and F on 1 disk group in RAID 1.

Prior to this reinstallation we had one DB file on which it was no problem to view the "database used %" in this file.

Now we split the DB file in 3 parts each on 1 disk group.
At this moment we can see the total "Database Used %", but does anybody know if there is a way to view this "Database Used %" per database file?

Greetings

eromein

A reason to split up a database in several parts is the have a better performance. This because Navision can now read and write in each database part at the same time.

Important to know it that this only works, if you split up the database and restore a back-up. If you do NOT do this, the whole splitting up of a database is useless. This because Navision will just handle the database as a normal database, all data will be in the fist part until this is full.

SO YOU"LL HAVE TO RESTORE A COMPLETE BACK-UP INTO THE SPLITUP DATABASE!

last part:
If you have done that you can now calculate the used % per database part. Or if the part are all the same in size, the % per part should be the same as the % of the complete database.

The last part I thought of myself. I'm not quite sure if this is indeed a fact or just my own fiction. The rest is true!

GoMaD

Well, we did a Backup and Restore so that has been done correct.

But I can't find the function or table where the information of "Database Used %" per database file can be found.

I can only see the "Database User %" for the whole database (total percentage used of 30 GB)

Greetings

eromein

I think... That this is the same. Navision devides all data "equaly" over all part (I think) so if your database is 10% full, every part should be 10% full more or less.... I think.

Unless something in Navision is not working the way I think it works.