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
