data inconsistency on two drives

FREDITSI — Thu, 05 Jun 2025 06:25:25 GMT

Hi,

I have a v series 3210 and two sql servers that have 3.91TB presented to each server. They are seup as follows

windows 2008, sql2008 and the sql is configured for sql mirroring for failover. The size of the database is 2.2TB I have snap manager for sql running on one server and it does two snap shots per day and deletes any older than two days.

within windows i view the drive on one server and the sql drive shows a total size of 2.92TB and free sapce of 363gb

on the mirored server the total size is 2.92TB and the free size is over 900gb.

within OnCommand the when i view the volumes it shows as 67% used when infact if you go by what windows shows as free space its more around the 88% mark. The available space is 1.3TB within OnCommand

when i then look at the luns its shows 87% used and the second server and 69% used.

Both drives presented to each server are from the same aggregate and thin provisioning is enabled. I am confused as the only data on the two servers is the database at 2.2TB that is mirrored. Snap shot output below which shows its not related to that.

%/used %/total date name

---------- ---------- ------------ --------

0% ( 0%) 0% ( 0%) Jun 07 16:01 sqlsnap__servername__recent (busy,vclone)

1% ( 1%) 1% ( 0%) Jun 07 08:56 sqlsnap__servername_06-07-2012_08.56.01

pnapc1>

Filesystem total used avail capacity Mounted on

vol/servername_user_db_servername/ 4000GB 2671GB 1328GB 67% /

/vol/servername_user_db_servername/.snapshot 0GB 27GB 0GB

Filesystem total used avail capacity Mounted on

/vol/servername_user_db_servername/ 4000GB 2087GB 1912GB 52% /vol/servername/erxgateway_user_db_servername

/vol/servername_user_db_servername/.snapshot 0GB 0GB 0GB ---% /vol/servername_user_db_servername/.snapshot

any help appreciated.

Thanks

Re: data inconsistency on two drives

aborzenkov — Fri, 08 Jun 2012 02:48:03 GMT

There really should be a FAQ somewhere

Once block is allocated to a LUN, it remains allocated on NetApp even if operating system later marks it as "free". So one host at some point had 2.6TB of data on a file system on the LUN. That now excess data are deleted in file system does not make blocks that once contained deleted data available for NetApp.

If you are using SnapDrive, you could try space reclamation to return free space on file system to NetApp free space pool.

Re: data inconsistency on two drives

christin — Fri, 15 Jun 2012 17:17:21 GMT

This looks like a support-related question. If your issue persists, please open a case with NetApp Support.

Regards,

Christine

topic Re: data inconsistency on two drives in Data Protection

data inconsistency on two drives

Re: data inconsistency on two drives

Re: data inconsistency on two drives